Home > Back-end >  Could you tell me why I have been from the form input database information transferred after to come
Could you tell me why I have been from the form input database information transferred after to come

Time:10-22

Here is my jdbc_1.
JSP file<% @ page language="Java" contentType="text/HTML. Charset=utf-8 "
PageEncoding="utf-8" % & gt;



<meta charset="utf-8" & gt;
Insert the title here

<body>
Name & lt; Input type="text" name="Cname" & gt;







Here is my cometruejdbc_1.
JSP file
<% @ page language="Java" contentType="text/HTML. Charset=utf-8 "
PageEncoding="utf-8" import="Java. SQL. *" % & gt;



<meta charset="utf-8" & gt;
Insert the title here

<body>
The customer information table & lt;/center>
<%
Out.println (" & lt; The table border=1 align=center width=700 & gt;" );
Out.println (" & lt; Tr>" );
Out.println (" & lt; Td align=center> Name & lt;/td>" );
Out.println (" & lt; Td align=center> The phone number & lt;/td>" );
Out.println (" & lt; Td align=center> Address & lt;/td>" );
Out.println (" & lt; Td align=center> Already bought equipment & lt;/td>" );
Out.println (" & lt; Td align=center> Amount payable & lt;/td>" );
Out.println (" & lt;/tr>" );
Class.forName("com.mysql.jdbc.Driver");
The Connection con=DriverManager. GetConnection (" JDBC: mysql://localhost: 3306/commerce ", "root", "XXX");
PreparedStatement STMT=con. PrepareStatement (" select * from the customer where Cname like?" );
String name=request. The getParameter (" Cname ");
STMT. SetString (1, name);
The ResultSet rs=STMT. ExecuteQuery ();
While (rs), next ())
{
Out.println (" & lt; Tr>" );
Out.println (" & lt; Td>" + rs. Get string (1) + "& lt;/td>" );
Out.println (" & lt; Td>" + rs. Get string (2) + "& lt;/td>" );
Out.println (" & lt; Td>" + rs. Get string (3) + "& lt;/td>" );
Out.println (" & lt; Td>" + rs. Get string (4) + "& lt;/td>" );
Out.println (" & lt; Td>" + rs. Get string (5) + "& lt;/td>" );
Out.println (" & lt;/tr>" );
}
Out.println (" & lt;/table>" );
rs.close();
STMT. Close ();
Con. The close ();
% & gt;




This is my code from the form input information

  • Related