denglu.jsp
<%@ page contentType="text/html; import="java.util.*,java.text.*"%> charset=GB2312" language="java"
<%@include file="util/main.jsp"%>(页面头部) xml:namespace prefix = jsp />(页面尾部)
dlxx.jsp
<%@ page contentType="text/html; import="java.util.*,java.text.*"%> <%@page import="java.sql.*"%> <%@include file="util/main.jsp"%>
<% String yonghu1=request.getParameter("yonghu"); String pass1=request.getParameter("pass"); String dpass=""; try{ charset=GB2312" language="java"
Class.forName ("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String url="jdbc:sqlserver://localhost:1433;DataBaseName=liu";(数据库名) String dlname="sa"; String dlpass="123"; Connection conn=DriverManager.getConnection(url,dlname,dlpass); Statement ss=conn.createStatement(); String cx="select yh_pass from yh where yh_name='"+yonghu1+"'"; yh_pass/yh_name 数据库列 ( 表名,yh 表名) ResultSet rs=ss.executeQuery(cx); if(rs.next()){ dpass=rs.getString("yh_pass"); } rs.close();ss.close();conn.close(); }catch(Exception e){ out.println(e.toString()); } if(dpass.equals(pass1)){ response.sendRedirect("weclome.jsp");(欢迎页面) }else{ out.print(yonghu1+"不是数据库中用户,登录失败! !"); out.print("
用户名="+yonghu1); out.print("
密码="+dpass); out.print("
密码="+pass1); } %>