登陆界面代码:adminlogin.html
连接数据的 jsp 页面代码:adminlogin.jsp <%@ page contentType="text/html;charset=GB2312" language="java" import="java.sql.*" %> <% if (request.getParameter("Username")!=null &;&;
request.getParameter("Password")!=null) { String strName=request.getParameter("Username"); String strPass=request.getParameter("Pass
word"); Class.forName("com.my
sql.jdbc.Driver"); String strConn="jdbc:
mysql://localhost:3306/ent_information";
String strUser="root"; String strPassword="root"; Connection conn=DriverManager.getConnection(strConn,strUser,strPassword); Statement stat=conn.createStatement(); String strSql="SELECT COUNT(*) FROM admin WHERE
Admin_name='"+strName+"' and Admin_pass='"+strPass+"'"; ResultSet result=stat.executeQuery(strSql); result.next(); if (result.getInt(1)==1) { session.setAttribute("login","OK"); response.sendRedirect("manager_function.jsp"); } else { out.println("
登录错误,请输入正确的用户名和密码
"); } } %>