<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //载入驱动程序类别
Connection con = DriverManager.getConnection("jdbc:odbc:BookDB"); //建立数据库链接
//建立Statement对象, 并设置记录指标类型为可前后移动
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("SELECT * FROM 表"); //建立ResultSet(结果集)对象,并执行SQL语句
%>
Connection con = DriverManager.getConnection("jdbc:odbc:BookDB"); //建立数据库链接
//建立Statement对象, 并设置记录指标类型为可前后移动
Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("SELECT * FROM 表"); //建立ResultSet(结果集)对象,并执行SQL语句
%>
决定转入后台管理页面,还是客户点菜页面。
--%><%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="javax.xml.parsers.*" %>
<%@ page import="org.w3c.dom.*" %>
<%@ page import="canyin.*" %> <jsp:useBean id="xmlBean" class="canyin.connXmlBean" scope="page" /><%
session.setMaxInactiveInterval(1800);
Document doc;
NodeList users;
String strExc="";
String strUsername,strPassword;strUsername=(String)request.getParameter("username");
strPassword=(String)request.getParameter("userpass");//校验数据是否为空
if (strUsername=="" || strPassword=="" ){
out.println("<script language='javascript'>");
out.println("alert('用户名或密码有空值!');");
out.println("window.location.href='/index.html';");
out.println("</script>");
return;
}xmlBean.connXml("webapps/canyin/data/users.xml");
doc=xmlBean.getXmlDoc();try{
users =doc.getElementsByTagName("user");
for (int i=0;i<users.getLength();i++){
Element user=(Element) users.item(i);
String strAtrNameValue=user.getAttributeNode("name").getNodeValue();
String strAtrPassWordValue=user.getAttributeNode("password").getNodeValue();
String strAtrRoleValue=user.getAttributeNode("roles").getNodeValue();
if (strAtrNameValue.equals(strUsername) && strAtrPassWordValue.equals(strPassword)){
if (strAtrRoleValue.equals("admin")){
out.println("<script language='javascript'>");
out.println("alert('欢迎管理员登陆系统!');");
out.println("</script>");
//设置标示用户身份的 session(sesUserRole) ,管理员身份为 admin
session.setAttribute("sesUserRole","admin");
//跳转到管理页面
response.sendRedirect("admin/admin_rest.jsp");
return;
}else{
//设置标示用户身份的 session(sesUserRole) ,管理员身份为 user
session.setAttribute("sesUserRole","user");
//跳转到普通用户页面
response.sendRedirect("index.jsp");
return;
} }else{
out.println("<script language='javascript'>");
out.println("alert('用户名或密码错误!');");
out.println("history.go(-1);");
out.println("</script>");
return;
} }
}catch(Exception e){
strExc=e.toString();
}
%>