package com.fjp.servlet.login.dao.impl;
import com.fjp.servlet.login.dao.LoginDao;
import com.fjp.servlet.login.pojo.User;
import com.fjp.servlet.login.utils.DruidUtils;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;
import java.sql.SQLException;
import java.util.List;
/**
* @author fjp
* @version 1.0
* @description: TODO
* @date 2023/7/19 19:30
*/
public class LoginDaoImpl implements LoginDao {
private static QueryRunner queryRunner = new QueryRunner(DruidUtils.getdataSource());
@Override
public User login(String username, String password) {
String sql = "select * from users where username = ? and password = ?";
try {
return queryRunner.query(sql,new BeanHandler<User>(User.class),username,password);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
@Override
public List<User> findAll() {
String sql = "select * from users";
try {
return queryRunner.query(sql, new BeanListHandler<User>(User.class));
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
@Override
public User findById(int id) {
String sql = "select * from users where id = ?";
try {
return queryRunner.query(sql,new BeanHandler<User>(User.class),id);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
@Override
public int updateUser(User user) {
String sql = "update users set username =? , password = ? ,phone = ? where id = ?";
try {
return queryRunner.update(sql, user.getUsername(), user.getPassword(), user.getPhone(), user.getId());
} catch (SQLException e) {
e.printStackTrace();
}
return 0;
}
@Override
public int deleteUser(int id) {
String sql = "delete from users where id=?";
try {
return queryRunner.update(sql,id);
} catch (SQLException e) {
e.printStackTrace();
}
return 0;
}
@Override
public int addUser(User user) {
String sql = "insert into users values(?,?,?,?)";
try {
return queryRunner.update(sql,user.getId(),user.getUsername(),user.getPassword(),user.getPhone());
} catch (SQLException e) {
e.printStackTrace();
}
return 0;
}
@Override
public List<User> limitUser(int page, int pageSize) {
String sql = "select * from users limit ? ,?";
try {
return queryRunner.query(sql,new BeanListHandler<User>(User.class),page,pageSize);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
@Override
public List<User> fuzzyFind(String name) {
String sql ="select * from users where username like ?";
try {
return queryRunner.query(sql, new BeanListHandler<User>(User.class),name);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
@Override
public long countUser() {
String sql = "select count(id) from users";
try {
return queryRunner.query(sql,new ScalarHandler<>());
} catch (SQLException e) {
e.printStackTrace();
}
return 0;
}
}
信息管理系统-Servlet+javaBean+Druid+DButil （103个子文件） 
LoginDaoImpl.class 4KB LoginDaoImpl.class 4KB FindAllServlet.class 3KB FindAllServlet.class 3KB LimitServlet.class 3KB LimitServlet.class 3KB FindByIdServlet.class 3KB FindByIdServlet.class 3KB FuzzyFindServlet.class 2KB FuzzyFindServlet.class 2KB LoginServiceImpl.class 2KB LoginServiceImpl.class 2KB UpdateUserServlet.class 2KB UpdateUserServlet.class 2KB AddUserServlet.class 2KB AddUserServlet.class 2KB LoginServlet.class 2KB LoginServlet.class 2KB AddServlet.class 2KB AddServlet.class 2KB DeleteUserServlet.class 2KB DeleteUserServlet.class 2KB CountServlet.class 2KB CountServlet.class 2KB DruidUtils.class 2KB DruidUtils.class 2KB User.class 1KB User.class 1KB HelloServlet.class 1KB UsersServlet.class 934B UsersServlet.class 934B DaoTest.class 910B DaoTest.class 910B databasetest.class 841B databasetest.class 841B LoginService.class 780B LoginService.class 780B LoginDao.class 768B LoginDao.class 768B login.css 2KB login.css 2KB .gitignore 184B
login.html 1KB login.html 1KB Servlet.iml 3KB
druid-1.1.10.jar 2.63MB druid-1.1.10.jar 2.63MB mysql-connector-java-8.0.16.jar 2.19MB mysql-connector-java-8.0.16.jar 2.19MB commons-dbutils-1.7.jar 95KB commons-dbutils-1.7.jar 95KB LoginDaoImpl.java 4KB FindAllServlet.java 3KB LimitServlet.java 2KB FindByIdServlet.java 2KB AddUserServlet.java 2KB LoginServiceImpl.java 2KB UpdateUserServlet.java 2KB LoginServlet.java 1KB DruidUtils.java 1KB AddServlet.java 1KB FuzzyFindServlet.java 1KB DeleteUserServlet.java 1KB User.java 1KB CountServlet.java 1KB LoginDao.java 756B LoginService.java 704B databasetest.java 617B UsersServlet.java 574B DaoTest.java 492B index.jsp 584B index.jsp 584B MANIFEST.MF 91B db.properties 238B db.properties 238B db.properties 238B workspace.xml 10KB uiDesigner.xml 9KB pom.xml 2KB Project_Default.xml 1KB Servlet_war_exploded.xml 931B jarRepositories.xml 864B rebel.xml 726B rebel.xml 726B rebel.xml 726B Maven__org_junit_platform_junit_platform_commons_1_7_1.xml 657B Maven__org_junit_platform_junit_platform_engine_1_7_1.xml 650B compiler.xml 641B Maven__org_junit_jupiter_junit_jupiter_engine_5_7_1.xml 639B Maven__org_junit_jupiter_junit_jupiter_api_5_7_1.xml 618B Maven__javax_servlet_javax_servlet_api_4_0_1.xml 602B Maven__org_apiguardian_apiguardian_api_1_1_0.xml 596B misc.xml 596B Servlet_war.xml 564B Maven__org_opentest4j_opentest4j_1_2_0.xml 557B runConfigurations.xml 346B web.xml 304B web.xml 304B mysql_connector_java_8_0_16.xml 276B encodings.xml 267B共 103 条
- 1
- 2
资源评论
