Sandhya.B
2 Answer(s) a year and 10 months ago
Posted in : JDBC
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...
July 13, 2011 at 11:18 AM
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.
July 13, 2011 at 11:39 AM
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>
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
