denglu.jsp

来自「USB设计的一些源码!适合与USB开发的同学!还是蛮不错的!我用过一些!」· JSP 代码 · 共 36 行

JSP
36
字号
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?