<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String uname =request.getParameter("uname");
String pwd = request.getParameter("pwd");
String usertype = request.getParameter("usertype");
String adminvalue="person";
if(adminvalue.equals(usertype))
{ 
  String sql="select * from scott.person where uname='"+uname+"' and pwd='"+pwd+"' "; 
ResultSet rs=stmt.executeQuery(sql); 
   if(!rs.next()){
   out.print("<SCRIPT language=JavaScript>alert('錯(cuò)誤的用戶名或密碼，請(qǐng)重新輸入！');");
  out.print("javascript:history.go(-1)</SCRIPT>");
   }else{
	   session.putValue("puid", uname); 
  response.sendRedirect("person/main.jsp"); 
   }
   
}else{
   
  String sql="select * from scott.company where uname='"+uname+"' and pwd='"+pwd+"' "; 
ResultSet rs=stmt.executeQuery(sql); 
   if(!rs.next()){
    out.print("<SCRIPT language=JavaScript>alert('錯(cuò)誤的用戶名或密碼，請(qǐng)重新輸入！');");
  out.print("javascript:history.go(-1)</SCRIPT>");
   }else{
   session.putValue("cuid", uname); 
   response.sendRedirect("company/main.jsp"); 
      }
} %>