jsp + javabean + mysql简单登录系统的认证问题

开源问答技术问答

文字

无与伦比的发表于2015/11/04 16:49

阅读941

MySQL

Java

我可以使用纯jsp通过jdbc连接到并在页面上显示信息jsp登录验证，但是使用jsp + javabean只能测试与的连接jsp登录验证，而没有进行相应的验证.

用户包

package com.model.user;
public class User {
		
				private String username;
				private String password;
				public String getUsername() {
					return username;
				}
				public void setUsername(String username) {
					this.username = username;
				}
				public String getPassword() {
					return password;
				}
				public void setPassword(String password) {
					this.password = password;
				}
				
}

package com.model.DAO;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
//的连接
public class DB {
	private Connection conn = null;
	private Statement stmt = null;
	private ResultSet rs = null;
	// 执行查询并返回查询结果
	public  ResultSet query(String sql) {
		try {
			// 帐号密码
			String URL = "jdbc:mysql://127.0.0.1:3306/js";
			String USER = "root";
			String PASSWORD = "12345";
			// 1.加载驱动
			Class.forName("com.mysql.jdbc.Driver");
			// 2.连接
			conn = DriverManager.getConnection(URL, USER, PASSWORD);
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			System.out.println("验证");
		
		} 
		catch (Exception ex) {
			ex.printStackTrace();
		}
		return rs;
	}
	// 关闭连接
	public void close() {
		try {
			if (rs != null)
				rs.close();
			if (stmt != null)
				stmt.close();
			if (conn != null)
				conn.close();
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}
}

登录界面

<html>
<body>
  
  <center>
  <h1>用户登录</h1><hr>
  <form action="dologin.jsp" name="form1" method="post">
  用户名:<input type="text" name="username"><br>
  密   码:<input type="password" name="password"><br>
  <input type="submit" value="提交" name="submit"/>
  <input  type="reset" value="重置" name="reset"/> 
</form>
  </center>
  
  </body>
</html>

dologin.jsp

<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" import="java.util.*" contentType="text/html; charset=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>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'index.jsp' starting page</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
  
  <jsp:useBean id="user" class="com.model.user.User" scope="session"></jsp:useBean>
  <jsp:useBean id="DAO" class="com.model.DAO.DB"></jsp:useBean>
  <jsp:setProperty property="*" name="user"/>
  <body>
  <%
  							//获取帐号、密码
  						String u=user.getUsername();
  						String  pwd=user.getPassword();
  					    String sql = "select password from user where username= ' "+u+ "  ' ";
  						 ResultSet rs=DAO.query(sql);
  						
  						 if(rs.next())
  						 {
  						 		if(rs.getString(1).equals(pwd))
  						 				System.out.println("登录成功");
  						 		else
  						 		{
  						 				System.out.println("登录失败");
  						 		}
  						 }
  						 
  						
   %>
  
  </body>
</html>

为什么我只能去验证，而不能判断相应的帐户密码？的帐户密码为admin

最多可投票

Mr_K

2015/11/04 17:36

我不明白这是什么意思...

本文来自电脑杂谈，转载请注明本文网址：
https://www.pc-fly.com/a/jisuanjixue/article-223692-1.html