?? aud.jsp
字號:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<html>
<head>
<title>
審核
</title>
</head>
<body>
<%!
String name;
String key;
String right;
String s;
boolean sign;
%>
<jsp:useBean id="m" scope="application" class="MD5.MD5"/>
<%
name=new String(request.getParameter("name").getBytes("ISO8859_1"), "GBK");
key=new String(request.getParameter("key").getBytes("ISO8859_1"), "GBK");
key=m.getMD5ofStr(key);
sign=true;
s="1";
%>
<jsp:useBean id="j" scope="application" class="jdbc.jdbc"/>
<%
try{
Connection con=j.getConnection();
Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from user_info";
ResultSet r=statement.executeQuery(sql);
while(r.next())
{
if(name.trim().equals((r.getString(1)).trim()) && key.equals((r.getString(2)).trim().trim()) && s.trim().equals(r.getString(4)))
{
j.releaseConnection(con);
sign=false;
request.getSession(true);
session.putValue("enter","wushili");
session.putValue("username",name);
response.sendRedirect("manager_frame.jsp");
}
else if(name.trim().equals((r.getString(1)).trim()) && key.trim().equals((r.getString(2)).trim()))
{
j.releaseConnection(con);
sign=false;
request.getSession(true);
session.putValue("enter","wushili");
session.putValue("username",name);
session.putValue("enterprise_name",(r.getString(3)).trim());
response.sendRedirect("frame.jsp");
}
}
if(sign)
{
j.releaseConnection(con);
response.sendRedirect("wrong.htm");
}
}
catch(SQLException ee){out.print("數據庫連接失敗！");}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -