package cn.pzhu.dao.impl;
import cn.pzhu.dao.UserDAO;
import cn.pzhu.pojo.User;
import cn.pzhu.util.JDBCUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
public class UserDAOImpl implements UserDAO {
@Override
public int insert(User user) {
Connection con =JDBCUtil.getConnection();
PreparedStatement preparedStatement =null;
ResultSet resultSet=null;
try {
String sql ="INSERT INTO `user` VALUES(NULL,?,?)";
preparedStatement=con.prepareStatement(sql);
preparedStatement.setString(1, user.getUsername());
preparedStatement.setString(2, user.getPassword());
preparedStatement.execute();
return 1;
} catch (SQLException e) {
e.printStackTrace();
return 0;
}finally {
JDBCUtil.close(null,preparedStatement,con);
}
}
@Override
public int delete(String s) {
Connection con =JDBCUtil.getConnection();
PreparedStatement preparedStatement =null;
ResultSet resultSet=null;
try {
String sql ="delete from user where username =?";
assert con != null;
preparedStatement=con.prepareStatement(sql);
preparedStatement.setString(1,s);
preparedStatement.execute();
return 1;
} catch (SQLException e) {
e.printStackTrace();
return 0;
}finally {
JDBCUtil.close(null,preparedStatement,con);
}
}
@Override
public int update(User user) {
Connection con =JDBCUtil.getConnection();
PreparedStatement preparedStatement =null;
ResultSet resultSet=null;
try {
String sql ="update user set password=? where username=?";
assert con != null;
preparedStatement=con.prepareStatement(sql);
preparedStatement.setString(1, user.getPassword());
preparedStatement.setString(2, user.getUsername());
preparedStatement.execute();
return 1;
} catch (SQLException e) {
e.printStackTrace();
return 0;
}finally {
JDBCUtil.close(null,preparedStatement,con);
}
}
@Override
public User selectById(String s) {
Connection con = JDBCUtil.getConnection();
PreparedStatement preparedStatement =null;
ResultSet resultSet=null;
User resUser = new User();
try {
String sql= "select * from user where username=?";
preparedStatement=con.prepareStatement(sql);
preparedStatement.setString(1,s);
resultSet=preparedStatement.executeQuery();
// System.out.print(resultSet);
if(resultSet.next()){
String name=resultSet.getString("username");
String password =resultSet.getString("password");
resUser.setPassword(password);
resUser.setUsername(name);
}
}catch (Exception e){
e.printStackTrace();
return null;
}finally {
JDBCUtil.close(resultSet,preparedStatement,con);
}
return resUser;
}
@Override
public List<User> selectAll() {
return null;
}
}
exp5-202010803110.zip （136个子文件） 
UserDAOImpl.class 4KB UserDAOImpl.class 4KB JDBCServlet.class 3KB JDBCServlet.class 3KB TodoServlet1.class 3KB TodoServlet1.class 3KB RegistServlet.class 3KB RegistServlet.class 3KB ChangePasswordServlet.class 3KB ChangePasswordServlet.class 3KB LoginServlet1.class 2KB LoginServlet1.class 2KB DeleteServlet.class 2KB DeleteServlet.class 2KB UserServiceImpl.class 2KB UserServiceImpl.class 2KB UserUtil.class 2KB UserUtil.class 2KB RootFilter.class 2KB RootFilter.class 2KB JDBCUtil.class 2KB JDBCUtil.class 2KB User.class 2KB User.class 2KB UserInfo.class 2KB UserInfo.class 2KB EncodingFilter.class 1KB EncodingFilter.class 1KB TestServlet.class 1KB TestServlet.class 1KB LoginoutServlet.class 1KB LoginoutServlet.class 1KB Message.class 858B Message.class 858B GeneralDAO.class 523B GeneralDAO.class 523B UserService.class 292B UserService.class 292B UserDAO.class 241B UserDAO.class 241B .gitignore 184B server.iml 403B
mysql-connector-java-8.0.16.jar 2.19MB protobuf-java-3.6.1.jar 1.36MB testng-7.6.1.jar 965KB standard.jar 384KB standard.jar 384KB jstl-impl-1.2.jar 383KB jquery-3.6.0.jar 306KB junit-4.10.jar 247KB jcommander-1.82.jar 86KB hamcrest-core-1.1.jar 75KB javax.servlet.jsp.jstl-api-1.2.2.jar 45KB slf4j-api-1.7.36.jar 40KB javax.servlet.jsp.jstl-api-1.2.1.jar 32KB jstl.jar 20KB jstl.jar 20KB jsr305-3.0.2.jar 19KB UserDAOImpl.java 3KB JDBCServlet.java 3KB TodoServlet1.java 2KB JDBCUtil.java 2KB UserServiceImpl.java 2KB RegistServlet.java 2KB RootFilter.java 2KB TestServlet.java 2KB LoginServlet1.java 1KB ChangePasswordServlet.java 1KB UserUtil.java 1KB EncodingFilter.java 1KB User.java 1KB DeleteServlet.java 1KB UserInfo.java 1KB LoginoutServlet.java 747B Message.java 622B GeneralDAO.java 429B UserService.java 367B UserDAO.java 120B jquery3.6.0.js 292KB todo.jsp 3KB todo.jsp 3KB show.jsp 2KB show.jsp 2KB register.jsp 2KB register.jsp 2KB head.jsp 1KB head.jsp 1KB login.jsp 1KB login.jsp 1KB JdbcShow.jsp 935B JdbcShow.jsp 935B JdbcShow.jsp 935B success.jsp 733B success.jsp 733B regist.jsp 728B regist.jsp 728B changepassword.jsp 655B changepassword.jsp 654B select.jsp 586B select.jsp 586B共 136 条
- 1
- 2
资源评论
给明凯一个冠军吧
- 粉丝: 0
- 资源: 1
