|
Logincheck.jsp
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
?
?
? <body>
? <%
? ? String driverName="oracle.jdbc.OracleDriver";
? ? String dbURL="jdbc:oracle:thin:@localhost:1521:test";
? ?String userName="system";
? ?String userPwd="1234";
? ?Connection conn = null;
? ResultSet rs = null;
? ? %>
? ? <%
? ?boolean flag=false;
? ? String user = request.getParameter("usern");
? ?System.out.println(user);
? ? String pass = request.getParameter("passw");
? ? System.out.println(pass);
?? try{
?? ?Class.forName("oracle.jdbc.OracleDriver");
??? conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:test","system","1234");
??? String sql="select * from Log where UN=‘ "+user+" ‘ and PD=‘ "+pass+" ‘ ";
??? Statement stmt = conn.createStatement();
??? System.out.println("stmt");
??? rs = stmt.executeQuery(sql);
? ?? System.out.println("rs suc");
? ?
??? ?if(rs.next()){
??? ??System.out.println("yes");
??? ??flag=true;
??? ??
??? ?}else{
??? ? ?flag=false;
?? ? ?System.out.println("no");
??? ?}
?? rs.close();
? ?stmt.close();
?? conn.close();
? ?
? ?? }catch(Exception err){
? ? ?System.out.println("error");
????? ? ? }
?????? ?
? ?
? ? if(flag){
? ? %>
? ? <jsp:forward page="suc.jsp"/>
? <%
? }else{
? ? ?? %>
? ? <jsp:forward page="error.jsp"/>
? ? ?? <%
? ? ? }
? ?? %>
? ?? </body>
? ?? </html>
?
Login.jsp（只截取主要部分）
<body>
? ? ?<form action="Logincheck.jsp" method="post">
? ???? ?<table align="center">
? ?? ??<tr> <td>用户名: <input type="text" name="usern" /></td> </tr>
? ? ???<tr> <td>密码: <input type="password" name="passw" /><a href="find.jsp">忘记密码？</a> </td></tr>
</table>
?? </form>
? </body>
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
