掉的java 是:
/*checkUserBy* :登陆用户身份验证
0: 普通用户
1: 超级用户
-1:登陆失败
*/
package Net;
import java.sql.*;
import java.io.*;
import java.util.*;public class LoginInfo
{
public int CheckUserbyOper(String strOper,String strPass)
{
OperatorManagerInfo operinfo;
String strsql;
cOperatormanager cb;
int ret=0;
cb=new cOperatormanager();
operinfo=new OperatorManagerInfo();
strsql="select *from snmp_operatormanager where operator=\'"+strOper+"\' and pass=\'";
strsql+=strPass+"\'";
ret=operinfo.OpenDb(strsql);
if(ret<=0)//验证失败
{
operinfo.Close();
return -1;
}
cb=(cOperatormanager)operinfo.GetRecord(0);
if(cb.iIsAdmin==1)
ret=1;
operinfo.Close();
return ret;
}
public int CheckUserByMobile(String strMobile,String strPass)
{
OperatorManagerInfo operinfo;
String strsql;
cOperatormanager cb;
int ret=0;
cb=new cOperatormanager();
operinfo=new OperatorManagerInfo();
strsql="select *from snmp_operatormanager where mobliephone=\'"+strMobile+"\' and pass=\'";
strsql+=strPass+"\'";
ret=operinfo.OpenDb(strsql);
if(ret<=0)//验证失败
{
operinfo.Close();
return -1;
}
cb=(cOperatormanager)operinfo.GetRecord(0);
if(cb.iIsAdmin==1)
ret=1;
operinfo.Close();
return ret;
}
public int CheckUserByCode(int iCode,String strPass)
{
OperatorManagerInfo operinfo;
String strsql;
cOperatormanager cb;
int ret=0;
cb=new cOperatormanager();
operinfo=new OperatorManagerInfo();
strsql="select *from snmp_operatormanager where code="+iCode+" and pass=\'";
strsql+=strPass+"\'";
ret=operinfo.OpenDb(strsql);
if(ret<=0)//验证失败
{
operinfo.Close();
return -1;
}
cb=(cOperatormanager)operinfo.GetRecord(0);
if(cb.iIsAdmin==1)
ret=1;
operinfo.Close();
return 0;
}
}
/*checkUserBy* :登陆用户身份验证
0: 普通用户
1: 超级用户
-1:登陆失败
*/
package Net;
import java.sql.*;
import java.io.*;
import java.util.*;public class LoginInfo
{
public int CheckUserbyOper(String strOper,String strPass)
{
OperatorManagerInfo operinfo;
String strsql;
cOperatormanager cb;
int ret=0;
cb=new cOperatormanager();
operinfo=new OperatorManagerInfo();
strsql="select *from snmp_operatormanager where operator=\'"+strOper+"\' and pass=\'";
strsql+=strPass+"\'";
ret=operinfo.OpenDb(strsql);
if(ret<=0)//验证失败
{
operinfo.Close();
return -1;
}
cb=(cOperatormanager)operinfo.GetRecord(0);
if(cb.iIsAdmin==1)
ret=1;
operinfo.Close();
return ret;
}
public int CheckUserByMobile(String strMobile,String strPass)
{
OperatorManagerInfo operinfo;
String strsql;
cOperatormanager cb;
int ret=0;
cb=new cOperatormanager();
operinfo=new OperatorManagerInfo();
strsql="select *from snmp_operatormanager where mobliephone=\'"+strMobile+"\' and pass=\'";
strsql+=strPass+"\'";
ret=operinfo.OpenDb(strsql);
if(ret<=0)//验证失败
{
operinfo.Close();
return -1;
}
cb=(cOperatormanager)operinfo.GetRecord(0);
if(cb.iIsAdmin==1)
ret=1;
operinfo.Close();
return ret;
}
public int CheckUserByCode(int iCode,String strPass)
{
OperatorManagerInfo operinfo;
String strsql;
cOperatormanager cb;
int ret=0;
cb=new cOperatormanager();
operinfo=new OperatorManagerInfo();
strsql="select *from snmp_operatormanager where code="+iCode+" and pass=\'";
strsql+=strPass+"\'";
ret=operinfo.OpenDb(strsql);
if(ret<=0)//验证失败
{
operinfo.Close();
return -1;
}
cb=(cOperatormanager)operinfo.GetRecord(0);
if(cb.iIsAdmin==1)
ret=1;
operinfo.Close();
return 0;
}
}
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java"%>
<%@ page import="java.util.*,Net.*" %>
<jsp:useBean id="loginInfo" class="Net.LoginInfo" scope="page"/>
<html>
<head>
<title>
login
</title>
</head>
<body bgcolor="#ffffff">
<h1>
用户登录
</h1>
<%
String sel=request.getParameter("sel");
String name=request.getParameter("UserName");
String password=request.getParameter("password");
// %>
<%
int login1 = loginInfo.CheckUserbyOper(name,password); if(("0").equals(request.getParameter("sel"))){
if( request.getParameter("UserName").equals(""))
response.sendRedirect("index.html");}
if(("1").equals(request.getParameter("sel")))
{
response.sendRedirect("error.jsp");
}
%>
<form method="post" action="login.jsp">
<br><br>
<select size="1" name="sel">
<option value="0">用户名</option>
<option value="1">工号</option>
<option value="2">手机号</option>
</select><td width=310 height=23 bgcolor=#F4F4F4>
用户名
<input name="UserName" type=text size=12 ><br><br>
密码
<input name="Password" type=password size=8><input type="submit" name="Submit" value="Submit">
<input type="reset" value="Reset">
</form>
</body>
</html>
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java"%>
<%@ page import="java.util.*,Net.*" %>
<jsp:useBean id="loginInfo" class="Net.LoginInfo" scope="page"/>
<html>
<head>
<title>
login
</title>
</head>
<body bgcolor="#ffffff">
<h1>
用户登录
</h1>
<%
String sel=request.getParameter("sel");
String name=request.getParameter("UserName");
String password=request.getParameter("password");
// %>
<%
int login1 = loginInfo.CheckUserbyOper(name,password); if(("0").equals(request.getParameter("sel"))){
if( request.getParameter("UserName").equals(""))
response.sendRedirect("index.html");}
if(("1").equals(request.getParameter("sel")))
{
response.sendRedirect("error.jsp");
}
%>
<form method="post" action="login.jsp">
<br><br>
<select size="1" name="sel">
<option value="0">用户名</option>
<option value="1">工号</option>
<option value="2">手机号</option>
</select><td width=310 height=23 bgcolor=#F4F4F4>
用户名
<input name="UserName" type=text size=12 ><br><br>
密码
<input name="Password" type=password size=8><input type="submit" name="Submit" value="Submit">
<input type="reset" value="Reset">
</form>
</body>
</html>