jsp+javabean验证登录用户名和密码
jsp登陆页面代码
<%@ page language="java" pageEncoding="utf-8" contentType="text/html;charset=GBK" %>
<%@ page import="conn_Data.Conn_Data" %>
<jsp:useBean id="mybean" class="Conn_Data" scope="session"/>
<jsp:setProperty name="mybean" property="*" />
<html><body><font size=2>
<form action="login.jsp" Method="post">
用户名:<Input type=text name="userName" size=8>
密 码:<Input type=text name="userpassWord" size=8>
<input type=submit name="smt" value="提交">
</form>
<jsp:getProperty name="mybean" property="UserName" />
<jsp:getProperty name="mybean" property="UserpassWord" />
<jsp:getProperty name="mybean" property="Login" />
</font>
</body>
</html>
javabean验证类的代码
package conn_Data;
import java.sql.*;
public class Conn_Data
{
//数据连接
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; // 加载JDBC驱动
String dbURL_birthControl = "jdbc:sqlserver://localhost:1433;DatabaseName=birthControl;selectMethod=cursor"; // 连接服务器和数据库sample
String dbURL_xznew = "jdbc:sqlserver://localhost:1433;DatabaseName=xznew;selectMethod=cursor"; // 连接服务器和数据库sample
String userName;//用户名
String userpassWord;//密码
Connection conn_birthControl=null; //社区连接
Connection conn_xznew=null; //旧wis连接
Statement sql;
ResultSet rs;
public void setUserName(String s)
{
userName=s;
}
public String getUserName()
{
return userName;
}
public void setUserpassWord(String s)
{
userpassWord=s;
}
public String getUserpassWord()
{
return userpassWord;
}
public void Conn_DataNew ()
{
try {
Class.forName(driverName);
conn_birthControl = DriverManager.getConnection(dbURL_birthControl, userName, userpassWord);
conn_xznew = DriverManager.getConnection(dbURL_xznew, userName, userpassWord);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}catch (SQLException e) {
e.printStackTrace();
}
}
}