简单的JSP登录程序

来源：互联网发布：怎么选课尔雅网络课程编辑：程序博客网时间：2024/05/30 04:40

声明。这种方式不推荐。初学者理解jsp用的。

<html><head><title>登录</title></head><body bgcolor="#ffffff"><form action="chkLogin.jsp" method="POST">  <input type="text" name="user" /><br />  <input type="password" name="pass" /><br />  <input type="Submit" value="提交" /></form></body></html>

chkLogin.jsp

<%@ page contentType="text/html; charset=GBK" %><%@ page import="java.sql.*" %><html><head><title>chkLogin</title></head><body bgcolor="#ffffff"><%  String user = request.getParameter("user");  String pass = request.getParameter("pass");  Connection con = null;  PreparedStatement ps = null;  ResultSet rs = null;  try  {    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");    con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=Test", "sa", "");    ps = con.prepareStatement("SELECT * FROM [User] WHERE UserName=? AND UserPwd =?");    ps.setString(1, user);    ps.setString(2, pass);    rs = ps.executeQuery();    if ( rs.next())    {      out.print("登录成功!");    }    else    {      out.print("登录失败!");    }  }catch(Exception ex)  {    ex.printStackTrace();  }finally{    if ( null != rs)    {      rs.close();      rs = null;    }    if ( null != ps)    {      ps.close();      ps = null;    }    if ( null != con){      con.close();      con = null;    }  }%></body></html>

0 0