下面是我的jdbc_1.jsp檔案
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
</head>
<body>
<form action="cometruejdbc_1.jsp" method="post">
姓名<input type="text" name="Cname">
<input type="submit" value="https://bbs.csdn.net/topics/提交">
<input type="reset" value="https://bbs.csdn.net/topics/重置">
</form>
</body>
</html>
下面是我的cometruejdbc_1.jsp檔案
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8" import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
</head>
<body>
<center>顧客資訊表</center>
<%
out.println("<table border= 1 align = center width= 700>");
out.println("<tr>");
out.println("<td align = center> 姓名 </td>");
out.println("<td align = center> 電話號碼 </td>");
out.println("<td align = center> 住址 </td>");
out.println("<td align = center> 已購器材 </td>");
out.println("<td align = center> 應付金額 </td>");
out.println("</tr>");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/commerce","root","xxx");
PreparedStatement stmt = con.prepareStatement("select * from customer where Cname like ?");
String name = request.getParameter("Cname");
stmt.setString(1,name);
ResultSet rs = stmt.executeQuery();
while(rs.next())
{
out.println("<tr>");
out.println("<td>"+rs.getString(1)+"</td>");
out.println("<td>"+rs.getString(2)+"</td>");
out.println("<td>"+rs.getString(3)+"</td>");
out.println("<td>"+rs.getString(4)+"</td>");
out.println("<td>"+rs.getString(5)+"</td>");
out.println("</tr>");
}
out.println("</table>");
rs.close();
stmt.close();
con.close();
%>
</body>
</html>
這是我的代碼從表單輸入資訊后的情況
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/184805.html
標籤：Java EE
上一篇：求免費可看的spring;springMVC;springboot;mybatis的課程視頻
下一篇：Idea啟動時報錯