<%@ page language="java" import ="java.sql.*" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<html>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
request.setCharacterEncoding("gb2312");//解决乱码
String stu=request.getParameter("stu");
//out.print(stu);测试
String sno=request.getParameter("sno");
//out.print(sno);测试
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
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 ='"+stu+"' and Sno='"+sno+"'");//数据库中匹配
if(rs.next()){
out.println("登陆成功!");
}
else{
out.println("登陆失败!");
}
%>
</body>
</html>
编写一个表单,提供学生登陆。输入学生的学号和姓名,如果匹配,则显示“登陆成功”,否则显示“登陆失败”
最新推荐文章于 2023-01-18 16:56:09 发布