xlogin.jsp

来自「一款采用java技术编写的OA办公软件系统」· JSP 代码 · 共 48 行

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="dbc" scope="session" class="net.dmresearch.util.DBConnection" />
<jsp:useBean id="charset" scope="session" class="net.dmresearch.util.Charset" />
<jsp:useBean id="dateformat" scope="session" class="net.dmresearch.util.Dateformat" />
<%
	
	String user = request.getParameter("user");
	String pwd = request.getParameter("pwd");
	String cid= "";
	dbc.getConnection();
	String sql= "select part,id,username,cid from  users where user='"+user+"' and password='"+pwd+"' and checked=1 ";
	out.println(sql);
	
	ResultSet  rs = dbc.getRS(sql);
	String part="",id="",username="";
	try{
		while(rs.next()){
			part = rs.getString(1);
			id = rs.getString(2);
			username = (rs.getString(3));
			cid = rs.getString(4);
		}
	}
	catch(Exception e){
		out.println(e.getMessage());
	}
 
	rs = null;
	dbc.close();


	if((part==null)||(part.length()<1)){
		out.println("part= "+part);
		response.sendRedirect("../login.jsp?t=0");
	}
	else{
		session.setAttribute("part",part);
		session.setAttribute("user",user);
		session.setAttribute("id",id);
		session.setAttribute("cid",cid);
		session.setAttribute("username",username);
		out.println("partA= "+part);
		response.sendRedirect("../index.jsp");
	}

	/**/
	
%>