QuestionAsk Questions?
nishi
java multiple users with single connection
2 Answer(s) 3 years and 8 months ago
Posted in : JSP-Servlet
2 Answer(s) 3 years and 8 months ago
Posted in : JSP-Servlet
View Answers
September 10, 2009 at 12:18 PM
Hi Friend,
Try the following code:
1)selectUser.jsp:
<html>
<form action="login.jsp" method="post">
Select User Type: <select name="userType">
<option value=""><--Select--></option>
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
</select>
<input type="submit" value="Submit">
</form>
</html>
2)login.jsp:
<%@ page language ="java" %>
<%
String userType=request.getParameter("userType");
%>
<html>
<body>
<form name="f1" method="post" action="..//LoginServlet">
<table align="center">
<tr>
<td>User Name</td><td><input type="text" name="user" ></td>
</tr>
<td>Email ID</td>
<td><input type="text" name="email"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Login"></td>
</tr>
</table>
<input type="hidden" name="type" value="<%=userType%>">
</form>
</body>
</html>
3)LoginServlet.java:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class LoginServlet extends HttpServlet{
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String username=request.getParameter("user");
String email=request.getParameter("email");
String userType=request.getParameter("type");
String table=userType.toLowerCase();
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement stmt=con.createStatement();
ResultSet rs=null ;
DatabaseMetaData meta = con.getMetaData();
rs = meta.getTables(null, null, null, new String[]{"TABLE"});
String tableName=null;
while (rs.next()) {
tableName = rs.getString("TABLE_NAME");
if(table.equals(tableName)){
out.println("<br>");
String strquery = "select * from "+tableName+" where username='"+username+"' && email='"+email+"'";
rs=stmt.executeQuery(strquery);
out.println("<table>");
while(rs.next()){
out.println("<tr><td>UserName:</td><td><input type='text' value='"+rs.getString(2)+"'></td></tr>");
out.println("<tr><td>Email:</td><td><input type='text' value='"+rs.getString(4)+"'></td></tr>");
out.println("<tr><td>Phone:</td><td><input type='text' value='"+rs.getString(5)+"'></td></tr>");
out.println("<tr><td>Address:</td><td><input type='text' value='"+rs.getString(6)+"'></td></tr>");
}
out.println("</table>");
}
}
con.close();
}
catch(Exception e){
out.println("exception occured" +e);
}
}
}
Thanks
Try the following code:
1)selectUser.jsp:
<html>
<form action="login.jsp" method="post">
Select User Type: <select name="userType">
<option value=""><--Select--></option>
<option value="A">A</option>
<option value="B">B</option>
<option value="C">C</option>
<option value="D">D</option>
</select>
<input type="submit" value="Submit">
</form>
</html>
2)login.jsp:
<%@ page language ="java" %>
<%
String userType=request.getParameter("userType");
%>
<html>
<body>
<form name="f1" method="post" action="..//LoginServlet">
<table align="center">
<tr>
<td>User Name</td><td><input type="text" name="user" ></td>
</tr>
<td>Email ID</td>
<td><input type="text" name="email"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Login"></td>
</tr>
</table>
<input type="hidden" name="type" value="<%=userType%>">
</form>
</body>
</html>
3)LoginServlet.java:
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class LoginServlet extends HttpServlet{
public void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String username=request.getParameter("user");
String email=request.getParameter("email");
String userType=request.getParameter("type");
String table=userType.toLowerCase();
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root","root";);
Statement stmt=con.createStatement();
ResultSet rs=null ;
DatabaseMetaData meta = con.getMetaData();
rs = meta.getTables(null, null, null, new String[]{"TABLE"});
String tableName=null;
while (rs.next()) {
tableName = rs.getString("TABLE_NAME");
if(table.equals(tableName)){
out.println("<br>");
String strquery = "select * from "+tableName+" where username='"+username+"' && email='"+email+"'";
rs=stmt.executeQuery(strquery);
out.println("<table>");
while(rs.next()){
out.println("<tr><td>UserName:</td><td><input type='text' value='"+rs.getString(2)+"'></td></tr>");
out.println("<tr><td>Email:</td><td><input type='text' value='"+rs.getString(4)+"'></td></tr>");
out.println("<tr><td>Phone:</td><td><input type='text' value='"+rs.getString(5)+"'></td></tr>");
out.println("<tr><td>Address:</td><td><input type='text' value='"+rs.getString(6)+"'></td></tr>");
}
out.println("</table>");
}
}
con.close();
}
catch(Exception e){
out.println("exception occured" +e);
}
}
}
Thanks
September 10, 2009 at 12:24 PM
Hi Friend,
For the above code,we have created four tables A,B,C,D in Database.
Hope that the above code will be helpful for you.
Thanks
For the above code,we have created four tables A,B,C,D in Database.
Hope that the above code will be helpful for you.
Thanks
Related Pages:
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.
Tutorial Topics
