java multiple users with single connection

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

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