超市会员管理系统【控制台+MySQL】（Java课设）

import java.sql.*; import java.util.Scanner; public class Manager { public static Scanner scanner = new Scanner(System.in); //插入语句 public static void insert() throws SQLException { System.out.println("----------增加超市会员信息数据----------"); System.out.println("超市会员的编号"); String id = scanner.next(); System.out.println("超市会员的姓名"); String name = scanner.next(); System.out.println("超市会员的性别"); String sex= scanner.next(); System.out.println("超市会员的电话"); String phone= scanner.next(); System.out.println("会员注册时间"); String time = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { //获取connection连接对象 con = JDBCUtils.getConnection(); //定义sql语句 String sql = "insert into member values(?,?,?,?,?)"; //预编译sql语句 stmt = con.prepareStatement(sql); //定义上面6个问号对应的值 stmt.setString(1, id); stmt.setString(2, name); stmt.setString(3, sex); stmt.setString(4, phone); stmt.setString(5, time); stmt.executeUpdate(); System.out.println("增加成功！"); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } UserManage.adminMenu(); } //显示所有信息 public static void selectAll() throws SQLException { //注册驱动 使用驱动连接数据库 Connection con = null; Statement stmt = null; ResultSet rs = null; try { //数据库的连接 con = JDBCUtils.getConnection(); stmt = con.createStatement(); //返回一个结果集 rs =stmt.executeQuery("select * from member"); System.out.println("-------------------------查询所有数据如下所示-------------------------"); while(rs.next()) { System.out.println(); System.out.println("超市会员的编号："+rs.getString("id") +"\t超市会员的姓名："+rs.getString("name")+"\t超市会员的性别：" +rs.getString("sex")+"\t超市会员的电话：" +rs.getString("phone")+"\t会员注册时间：" +rs.getString("time")); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } UserManage.adminMenu(); } //根据编号修改 public static void updateById() throws SQLException { System.out.println("----------根据超市会员编号修改超市会员信息----------"); System.out.println("请输入需要修改超市会员信息的超市会员编号"); String id = scanner.next(); System.out.println("请输入需要修改超市会员的姓名"); String name = scanner.next(); System.out.println("请输入需要修改超市会员信息的性别"); String sex= scanner.next(); System.out.println("请输入需要修改超市会员信息的电话"); String phone = scanner.next(); System.out.println("请输入需要修改会员注册时间"); String time = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { //数据库的连接 con = JDBCUtils.getConnection(); //定义sql语句 String sql = "update member set name=?,sex=?,phone=?, time=? where id = ?"; //预编译 stmt = con.prepareStatement(sql); //定义上面6个问号对应的值 stmt.setString(1, name); stmt.setString(2, sex); stmt.setString(3, phone); stmt.setString(4, time); stmt.setString(5, id); stmt.execute(); System.out.println("超市会员信息修改成功！"); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } UserManage.adminMenu(); } //根据编号删除 public static void deleteById() throws SQLException { System.out.println("----------根据超市会员编号删除超市会员信息----------"); System.out.println("请输入需要删除的超市会员编号"); String id = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { //数据库的连接 con = JDBCUtils.getConnection(); //定义sql语句 String sql = "delete from member where id =?"; //预编译 stmt = con.prepareStatement(sql); //定义上面1个问号对应的值 stmt.setString(1,id); stmt.execute(); System.out.println("超市会员删除成功！"); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtils.close(rs, stmt, con); } UserManage.adminMenu(); } }