javaWEB项目jsp+servlet+mysql完整版下载

package com.cc.dao.impl; import java.sql.*; import java.util.ArrayList; import java.util.List; import com.cc.dao.BaseDao; import com.cc.dao.IUserDao; import com.cc.entity.User; public class UserDaoImpl extends BaseDao implements IUserDao { public int addOneUser(User user) { // 增加用户的详细操作 int i = 0; String sql = "insert into users values(0,?,?,?,?,?,?,?)"; Connection conn = this.getConn(); try { PreparedStatement preStmt = conn.prepareStatement(sql); preStmt.setString(1, user.getUserName()); preStmt.setString(2, user.getUserPass()); preStmt.setString(3, user.getEmail()); preStmt.setInt(4, user.getAge()); preStmt.setString(5, user.getSex()); preStmt.setString(6, user.getRegisterDate()); preStmt.setString(7, user.getRecordDate()); i = preStmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } return i; } public int deleteOneUser(int userId) { // 删除用户的详细操作 int i = 0; String sql = "delete from users where userId =" + userId; Connection cnn = this.getConn(); try { Statement stmt = cnn.createStatement(); i = stmt.executeUpdate(sql); } catch (SQLException e) { e.printStackTrace(); } return i; } public int updateOneUser(User user) { // 更改用户的详细操作 int i = 0; String sql = "update users set userName=?,userPass=?,email=?,age=?,sex=?,recordDate=? where userId=" + user.getUserId(); Connection cnn = this.getConn(); try { PreparedStatement preStmt = cnn.prepareStatement(sql); preStmt.setString(1, user.getUserName()); preStmt.setString(2, user.getUserPass()); preStmt.setString(3, user.getEmail()); preStmt.setInt(4, user.getAge()); preStmt.setString(5, user.getSex()); preStmt.setString(6, user.getRecordDate()); i = preStmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } return i; } public User findOneUser(int userId) { // 查找用户的详细操作 User user =null; String sql = "select *from users where userId="+userId; Connection cnn =this.getConn(); try { Statement stmt = cnn.createStatement(); ResultSet rs = stmt.executeQuery(sql); //多个用户的时候需要用while，一个用户，只需要if if(rs.next()){ String userName = rs.getString(2); String userPass = rs.getString(3); String email = rs.getString(3); int age = rs.getInt(5); String sex = rs.getString(6); String loginDate = rs.getString(7); String login2Date = rs.getString(8); user = new User(userId,userName,userPass,email,age,sex,loginDate,login2Date); } } catch (SQLException e) { e.printStackTrace(); } return user; } public List<User> findAllUser() { List<User> users = new ArrayList<User>(); String sql = "select *from users "; Connection conn = this.getConn(); try { Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ int userid = rs.getInt(1); String userName = rs.getString(2); String userPass = rs.getString(3); String email = rs.getString(4); int age = rs.getInt(5); String sex = rs.getString(6); String loginDate = rs.getString(7); String login2Date = rs.getString(8); users.add(new User(userid,userName,userPass,email,age,sex,loginDate,login2Date)); } } catch (SQLException e) { e.printStackTrace(); } return users; } }