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个文件
class:40个
jsp:30个
java:20个
需积分: 9 0 下载量 160 浏览量
2022-11-17
01:16:45
上传
评论
收藏 11.8MB ZIP 举报
温馨提示
exp5-202010803110.zip
资源推荐
资源详情
资源评论
收起资源包目录
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
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功