编写一个网页，能够输入学生姓名的模糊资料，然后查询并显示符合条件学生的相关信息。

最新推荐文章于 2024-07-08 10:45:00 发布

写代码好难

最新推荐文章于 2024-07-08 10:45:00 发布

阅读量4.4k

点赞数 10

分类专栏： 1 文章标签： jsp java mysql jdbc

本文链接：https://blog.csdn.net/qq_45691937/article/details/116568256

版权

1 专栏收录该内容

9 篇文章

订阅专栏

html页面

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="gb2312"%>
<html>

<body>
	<form action="NewFile2.jsp" method="post">
	输入姓名<input type="text" name="stuno"><br>
	<input type="submit" value="模糊查询">
	</form>

</body>
</html>

jsp代码段：数据库用的是sql server

<%@ page language="java" import="java.sql.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<html>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
	Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
	
}catch(Exception e){
	out.print(e);
}
try{
	request.setCharacterEncoding("gb2312");
	String stuno=request.getParameter("stuno");
	out.print(stuno);
	String uri="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=JX";
	String user="sa";
	String password="123456";
	con=DriverManager.getConnection(uri,user,password);
	sql = con.createStatement();
	rs=sql.executeQuery("select*  from Student  where Sname like '%"+stuno+"%'");
	while(rs.next()){
		out.println(rs.getString(1));
		out.println(rs.getString(2));
		out.println(rs.getString(3));
		out.println(rs.getString(4));
		out.println(rs.getString(5));
		out.println("<br>");
	}
	
}catch(Exception e){
	out.print(e);
}
%>

	
</body>
</html>