Hi,
Here is my jsp page where i trying to display the data from table. Here form1 is the name of drop down list in my searchuser.jsp page. The content in the drop down list is a name of one column of the database. I am able to connect firstjsp page showing item available in drop down menu.But when I am running this page I am failing to connect it to database.
Whether My marked query is right or wrong?
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page language ="java" %>
<%@ page import="java.sql.*, javax.sql.*, javax.naming.*,java.io.*,java.util.*" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%
String form=request.getParameter("[B]form1[/B]");
try {
Connection connection = null;
Statement st = null;
ResultSet rs = null;
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mynewdatabase","root", "root123");
st=con.createStatement();
rs = st.executeQuery("select emailid ,password from user where emailid='"+form+"'");
rs.next();
String EMAIL = rs.getString("emailid");
String PASSWORD = rs.getString("password");
rs.close();
%>
<table border="1">
<%
while (rs.next()) {
%>
<tbody>
<tr><thead>
<tr>
<th><b>MODIFY USER</b></th>
</tr>
</thead>
<td>E-MAIL</td>
<td><input type="text" name="email" value=="<%=EMAIL%>" size="30" /> </td>
</tr>
<tr>
<td>PASSWORD</td>
<td><input type="text" name="password" value=="<%=PASSWORD%>" size="10" /></td>
</tr>
<tr>
<td><input type="submit" value="SUBMIT" name="submit" /></td>
<td><input type="reset" value="RESET" name="res" /></td>
</tr>
</tbody>
<% } %>
<%
rs.close();
st.close();
connection.close();
} catch (Exception ex) {
%>
<%
out.println("Unable to connect to database.");
}
%>
</table>
</body>
</html>
Any Suggestion is highly appreciated.
thanks and Regards
haresh