checkpassword.jsp

jsp-公司管理系统-注册、会员管理等功能

<%-- 验证用户身份的CheckPassword.jsp程序 --%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.SQLException" %>
<%
request.setCharacterEncoding("gb2312");
String user=request.getParameter("user");
String pwd=request.getParameter("password");
//建立数据库连接并执行数据插入
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	conn=DriverManager.getConnection("jdbc:odbc:datasource_suit","sa","710318");
	/** 调用类型4的驱动程序的写法
	Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
	conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1041;User=sa;Password=710318;DatabaseName=db_suit"); 
	**/
	/*** 调用类型4的驱动程序的另一种Properties写法
	Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
	Properties props=new Properties();
	props.put("user","sa");
	props.put("password","710318");
	props.put("DataBaseName","db_suit");
	conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1041",props);
	***/
	stmt=conn.createStatement();
	//执行查询
	String strSQL="select * from t_userInfo where username='"+user+"' and password='"+pwd+"'";
	rs=stmt.executeQuery(strSQL);
	int count=0;
	while(rs.next()){
		count++;
	}
	if(count>0){ //身份正确，转到另一个网页处。
		session.setAttribute("user",user);
		session.setAttribute("password",pwd);
		response.sendRedirect("./SessionDemo.jsp");
	}
	else{  //身份不正确，重新调出登录页面。
		response.sendRedirect("../site_JSP/login.htm");
	}
}catch(Exception e){
	out.println("登录失败，请重式."+e);
}finally{
	try{
		if(rs!=null){
			rs.close();
		}
		if(stmt!=null){
			stmt.close();
		}
		if(conn!=null){
			conn.close();
		}
	}catch(SQLException sqle){}
}
%>