📄 denglu.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>验证用户</title>
</head>
<body>
<%
String returnString = null;
String Userid = request.getParameter("logname"); // 数据库的用户名
String Password = request.getParameter("password") ; //数据库的密码
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:login","","");
Statement stmt = con.createStatement();
String sql= "select * from Users where username='" + Userid + "' and password='" + Password +"';" ;
ResultSet rs = stmt.executeQuery(sql);
if (rs.next())
{
returnString = rs.getString("username");
}
stmt.close();
con.close();
}
catch(SQLException e)
{
System.out.println(e);
}
if(returnString!=null)
out.println(returnString+"是合法用户");
else
out.println("用户名或密码错误");
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -