1)in registration page,when new user register his details,hw the details will b stored in db....(i knw hw to do it bt i ve some doubts in it),so plz give me the code in detail plzzz.....2)n hw do v knw whether that details r inserted in db(do v need to write select query in d same pgm)?
and here is my code tthe above query...i thk thr r some mistakes in ths,plz find out n tel me the mistake i ve done... '
<% try { Class.forName(driver);con = DriverManager.getConnection(url + db, user, pass); statement stmt=con.createstatement(); string uname=request.getparameter("username"); string pass=request.getparameter("pasword"); int count=stmt.executeUpdate("insert into abc(username,password) values("+uname+","+pass+"); if(count>0) { out.println("successful"); } else { out.println("unsucce..."); } } catch { .... }
also 3)code for retreiving the data frm db(tel me with statement n prepared stmt seperatly plzz...)...
4) actually i ve no data in db,after inserting user details only the data will b inserted in db,so hw to retrive that....
plzzz give the codes for all the abv 4 queries in detail,seperatly plzzz...
1)form.jsp:
<html> <form method="post" action="insert.jsp"> <table> <tr><td>First Name:</td><td><input type="text" name="fname"></td></tr> <tr><td>Last Name:</td><td><input type="text" name="lname"></td></tr> <tr><td>Email:</td><td><input type="text" name="email"></td></tr> <tr><td>Password:</td><td><input type="password" name="pass"></td></tr> <tr><td>Confirm Password:</td><td><input type="password" name="cpass"></td></tr> <tr><td>Date Of Birth</td><td><input type="text" name="dob"></td></tr> <tr><td>Age:</td><td><input type="text" name="age"></td></tr> <tr><td>Gender</td><td><input type="text" name="gender"></td></tr> <tr><td>Address:</td><td><input type="text" name="address"></td></tr> <tr><td>Country</td><td><input type="text" name="country"></td></tr> <tr><td>State:</td><td><input type="text" name="state"></td></tr> <tr><td>City</td><td><input type="text" name="city"></td></tr> <tr><td>Telephone No:</td><td><input type="text" name="tno"></td></tr> <tr><td>Mobile:</td><td><input type="text" name="mobile"></td></tr> <tr><td></td><td><input type="submit" value="Submit"></td></tr> </table> </form> </html>
2)insert.jsp:
<%@page import="java.sql.*,java.util.*"%> <% String fname=request.getParameter("fname"); String lname=request.getParameter("lname"); String email=request.getParameter("email"); String pass=request.getParameter("pass"); String cpass=request.getParameter("cpass"); String dob=request.getParameter("dob"); int age=Integer.parseInt(request.getParameter("age")); String gender=request.getParameter("gender"); String address=request.getParameter("address"); String country=request.getParameter("country"); String state=request.getParameter("state"); String city=request.getParameter("city"); int telephone=Integer.parseInt(request.getParameter("tno")); int mobile=Integer.parseInt(request.getParameter("mobile")); try{ Class.forName("com.mysql.jdbc.Driver"); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/roseindia", "root", "root"); Statement st=con.createStatement(); int i=st.executeUpdate("insert into student(firstname,lastname,email,pass,confirm_pass,dob,age,gender,address,country,state,city,telephone,mobile) values('"+fname+"','"+lname+"','"+email+"','"+pass+"','"+cpass+"','"+dob+"',"+age+",'"+gender+"','"+address+"','"+country+"','"+state+"','"+city+"',"+telephone+","+mobile+")"); out.println("Data is successfully inserted!"); } catch(Exception e){ System.out.println(e); e.printStackTrace(); } %>
If the values will get inserted then you will get the message on the browser 'Data is successfully inserted' as we have specified in the above code.
Retrieve data using Statement
<%@page import="java.sql.*"%> <table border=1> <% Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/roseindia","root","root"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("Select * from student"); if(rs.last()){ %> <tr><td><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td><td><%=rs.getString(4)%></td><td><%=rs.getString(5)%></td><td><%=rs.getString(6)%></td><td><%=rs.getString(7)%></td><td><%=rs.getString(8)%></td><td><%=rs.getString(9)%></td><td><%=rs.getString(10)%></td><td><%=rs.getString(11)%></td><td><%=rs.getString(12)%></td><td><%=rs.getString(13)%></td><td><%=rs.getString(14)%></td></tr> <% } %> </table>
Retrieve data using PreparedStatement
<%@page import="java.sql.*"%> <table border=1> <% Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/roseindia","root","root"); PreparedStatement pst=con.prepareStatement("Select * from student"); ResultSet rs=pst.executeQuery(); if(rs.last()){ %> <tr><td><%=rs.getString(1)%></td><td><%=rs.getString(2)%></td><td><%=rs.getString(3)%></td><td><%=rs.getString(4)%></td><td><%=rs.getString(5)%></td><td><%=rs.getString(6)%></td><td><%=rs.getString(7)%></td><td><%=rs.getString(8)%></td><td><%=rs.getString(9)%></td><td><%=rs.getString(10)%></td><td><%=rs.getString(11)%></td><td><%=rs.getString(12)%></td><td><%=rs.getString(13)%></td><td><%=rs.getString(14)%></td></tr> <% } %> </table>
Ads