<%@ page language="java" import="java.util.*" import="java.sql.*" pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("UTF-8");
// 表单接收参数 用 //
String user = request.getParameter("txtname");
String pass = request.getParameter("txtpass");
String flagtype=request.getParameter("flagtype");
session.setAttribute("_Ftype",flagtype);
if (flagtype.equals("1"))
{
String StrSQL="select ID,adName,adPass from AdminInfo where adName='"+user+"' and adPass='"+pass+"'";
try{
// 通过ODBC模式连接 数据库,前提需要先创建一个 dataMgr的 数据源
ResultSet rs = SQLHelper.GetResultSet(StrSQL);
int i=0;
while(rs.next())
{
i++;
session.setAttribute("UFlag", "1");
session.setAttribute("UserID", rs.getString("ID"));
session.setAttribute("UserName", rs.getString("ADName"));
rs.close();
response.sendRedirect("editpass.jsp");
}
if (i ==0)
{
rs.close();
out.write("<script>alert('登录失败');history.back();</script>");
return;
}
}
catch(Exception e)
{
}
}
else if(flagtype.equals("2"))
{
String StrSQL="select ID,CName,CPass from companyList where CName='"+user+"' and CPass='"+pass+"'";
try{
// 通过ODBC模式连接 数据库,前提需要先创建一个 dataMgr的 数据源
ResultSet rs = SQLHelper.GetResultSet(StrSQL);
int i=0;
while(rs.next())
{
i++;
session.setAttribute("UFlag", "2");
session.setAttribute("UserID", rs.getString("ID"));
session.setAttribute("UserName", rs.getString("CName"));
rs.close();
response.sendRedirect("editpass.jsp");
}
if (i ==0)
{
rs.close();
out.write("<script>alert('登录失败');history.back();</script>");
return;
}
}
catch(Exception e)
{
}
}
else
{
String StrSQL="select ID,IDCard,SName,SPass from soldierList where IDCard='"+user+"' and SPass='"+pass+"'";
try{
// 通过ODBC模式连接 数据库,前提需要先创建一个 dataMgr的 数据源
ResultSet rs = SQLHelper.GetResultSet(StrSQL);
int i=0;
while(rs.next())
{
i++;
session.setAttribute("UFlag", "3");
session.setAttribute("UserID", rs.getString("ID"));
session.setAttribute("UserName", rs.getString("SName"));
rs.close();
response.sendRedirect("editpass.jsp");
}
if (i ==0)
{
rs.close();
out.write("<script>alert('登录失败');history.back();</script>");
return;
}
}
catch(Exception e)
{
}
}
%>