好像是这里面读不到数据,改了很久还是改不出来,求助!
package com.ding.dao;
import com.ding.entity.user;
import com.ding.util.DBHelper;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
/**
*
@author irin
*/
public class userDao extends DBHelper{
public user login(String username, String password){
user u = null;
String sql = "select * from user where username = ? and password=?";
try{
ResultSet rs = this.executeQuery(sql,username,password);
if(rs.next()){
u = new user();
u.setUsername(rs.getString(1));
u.setPassword(rs.getString(2));
}
}catch(Exception e){
e.printStackTrace();
}finally{
this.close();
}
return u;
}
}
package com.ding.servlet;
import com.ding.dao.userDao;
import com.ding.entity.user;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
@author irin
*/
public class userServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
doGet(req,resp);
}
private userDao userdao = new userDao();
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
req.setCharacterEncoding("utf-8");
String username = req.getParameter("user");
String password = req.getParameter("password");
user u = new user();
u.setUsername(username);
u.setPassword(password);
userDao userdao = new userDao();
if(userdao.login(username,password)!=null){
req.setAttribute("user",u );
resp.sendRedirect("welcome.jsp");
}
else
req.getRequestDispatcher("sorry.jsp").forward(req, resp);
}
}
package com.ding.entity;
/**
*
@author irin
*/
public class user {
// private int id;
private String username;
private String password;
// private String role;
public user() {
}
public user(String username, String password) {
this.username = username;
this.password = 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.ding.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
/**
*
@author irin
*/
public class DBHelper {
private Connection conn;
private PreparedStatement ps;
private ResultSet rs;
//获得连接
private void getConnection(){
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/dormitorymanage?characterEncoding=utf8&useSSL=true";
conn = DriverManager.getConnection(url,"root","Ding1234");
} catch (Exception e) {
e.printStackTrace();
}
}
//关闭
public void close(){
if(conn!=null){
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
conn = null;
}
if(ps!=null){
try {
ps.close();
} catch (Exception e) {
e.printStackTrace();
}
ps = null;
}
if(rs!=null){
try {
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
rs = null;
}
}
//更新--增加、修改、删除
public int executeUpdate(String sql,Object...objects){
try {
this.getConnection();
ps = conn.prepareStatement(sql);
if(objects!=null){
for(int i=0;i<objects.length;i++){
ps.setObject(i+1, objects[i]);
}
}
return ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally{
this.close();
}
return -1;
}
//查询
public ResultSet executeQuery(String sql,Object...objects){
try {
this.getConnection();
ps = conn.prepareStatement(sql);
if(objects!=null){
for(int i=0;i<objects.length;i++){
ps.setObject(i+1, objects[i]);
}
}
return rs = ps.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
}