主要功能实现:用户登录、用户信息的增加、删除、修改、查询等功能。
用户模块有用户界面,用户可以进行登录和注册,登录进入用户界面,可以对个人信息进行修改,可以更改自己的登录密码。
整体需求:
1)查询
2)添加用户信息
3)删除用户信息
4)查询详情,模糊查询
5)条件查询
6)修改
主页面:
新增功能页面实现:
删除功能:
查询功能:
dao层代码:增删改查
public class LoginDao { public static void main(String[] args) { } public static boolean queryLogin(String username,String password) throws SQLException { Statement stmt = null; ResultSet rs = null; String sql = "select * from tuserlogin where username=? and password=?"; Connection conn = SqlConnUtil.getConnectionUtils(); PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, username); ps.setString(2, password); rs = ps.executeQuery(); if(rs.next()) { return true; }else { return false; } } public ResultSet query() throws Exception { Statement stmt = null; ResultSet rs = null; String sql = "select * from tuserlogin"; Connection conn = SqlConnUtil.getConnectionUtils(); PreparedStatement ps = conn.prepareStatement(sql); return ps.executeQuery(); } //增加数据 public int insert(String id,String username,String password,String dj,String email) throws Exception { Statement stmt = null; ResultSet rs = null; String sql = "insert into tuserlogin values(?,?,?,?,?)"; Connection conn = SqlConnUtil.getConnectionUtils(); PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, id); ps.setString(3, username); ps.setString(2, password); ps.setString(4, dj); ps.setString(5, email); return ps.executeUpdate(); } //删除数据 public int delete(String id) throws Exception { Statement stmt = null; ResultSet rs = null; String sql = "delete from tuserlogin where id=?"; Connection conn = SqlConnUtil.getConnectionUtils(); PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, id); return ps.executeUpdate(); } //修改数据 public int update(String username,String password,String grade,String email, String id) throws Exception { Statement stmt = null; ResultSet rs = null; String sql = "UPDATE tuserlogin SET username=?,PASSWORD=?,grade=?,email=? WHERe id=?"; Connection conn = SqlConnUtil.getConnectionUtils(); PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, username); ps.setString(2, password); ps.setString(3, grade); ps.setString(4, email); ps.setString(5, id); return ps.executeUpdate(); } //查询 public ResultSet select(String neirong) throws SQLException { Statement stmt = null; ResultSet rs = null; String sql = "select * from tuserlogin where id=? or username=? or password=? or email=?"; Connection conn = SqlConnUtil.getConnectionUtils(); PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, neirong); ps.setString(2, neirong); ps.setString(3, neirong); ps.setString(4, neirong); return ps.executeQuery(); } //grade查询 public ResultSet select1(String neirong) throws SQLException { Statement stmt = null; ResultSet rs = null; String sql = "select * from tuserlogin where username=? or password=? or grade=? or email=?"; Connection conn = SqlConnUtil.getConnectionUtils(); PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, neirong); ps.setString(2, neirong); ps.setString(3, neirong); ps.setString(4, neirong); return ps.executeQuery(); } }
详细代码(32条消息) Java程序设计-用户管理系统-Java文档类资源-CSDN文库https://download.csdn.net/download/m0_59661114/85774936