首页>代码>jsp+servlet+jdbc使用cookie做到系统用户自动登录的java web项目实例>/自动登录/autoLogin/src/com/dao/impl/UserDaoImpl.java
package com.dao.impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.dao.UserDao; import com.entity.User; import com.util.DBUtils; public class UserDaoImpl implements UserDao{ @Override public User getUserByName(String username) { Connection con = null; PreparedStatement ps = null; ResultSet rs = null; try { con = DBUtils.getConnection(); ps = con.prepareStatement("SELECT * FROM t_user WHERE username=?"); ps.setString(1, username); rs = ps.executeQuery(); if (rs.next()) { return new User(rs.getInt("id"), rs.getString("username"), rs.getString("password")); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return null; } }