手机信息管理系统【控制台+MySQL】（Java课设）

import java.sql.*; import java.util.Scanner; public class AdminManage { //创建Scanner对象来进行键盘输入 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 type= scanner.next(); System.out.println("价格"); String price= scanner.next(); System.out.println("出厂时间"); String time = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; //创建PreparedStatement对象用来执行数据库语句 PreparedStatement stmt = null; ResultSet rs = null; try { //调用工具类JDBCUtils来获得一个Connection连接对象 con = JDBCUtils.getConnection(); //定义一个sql语句 String sql = "insert into phone values(?,?,?,?,?)"; // 执行sql语句 stmt = con.prepareStatement(sql); //定义每个？号对用的参数 stmt.setString(1, id); stmt.setString(2, name); stmt.setString(3, type); stmt.setString(4, price); stmt.setString(5, time); //执行数据库操作 stmt.executeUpdate(); System.out.println("录入成功！！！"); } catch (Exception e) { // 打印异常 e.printStackTrace(); }finally { //调用JDBCUtils的close方法关闭上面的三个对象 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(); //调用Connection对象的createStatement方法得到一个Statement对象 stmt = con.createStatement(); //返回一个结果集 rs =stmt.executeQuery("select * from phone"); System.out.println("---------------------查询结果如下所示---------------------"); while(rs.next()) { System.out.println("手机序号："+rs.getString("id")+"\t手机厂商："+rs.getString("name") +"\t手机型号："+rs.getString("type")+"\t价格："+rs.getString("price") +"\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 type= scanner.next(); System.out.println("请输入需要修改的价格"); String price= scanner.next(); System.out.println("请输入需要修改的出厂时间"); String time = scanner.next(); //注册驱动 使用驱动连接数据库 Connection con = null; PreparedStatement stmt = null; ResultSet rs = null; try { con = JDBCUtils.getConnection(); String sql = "update phone set name=?,type=?,price=?, time=? where id = ?"; stmt = con.prepareStatement(sql); stmt.setString(1, name); stmt.setString(2, type); stmt.setString(3, price); 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(); String sql = "delete from phone where id =?"; stmt = con.prepareStatement(sql); 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(); } //按厂商查询 public static void selectByName() throws SQLException { System.out.println("----------根据厂商查询手机信息----------"); System.out.println("请输入需要查询的厂商"); String num = scanner.next(); //注册驱动 使用驱动连接数据库 String sql = "select * from phone where name = ?"; PreparedStatement pst = null; ResultSet rs = null; Connection conn = JDBCUtils.getConnection(); try { pst = conn.prepareStatement(sql); pst.setString(1, num); rs = pst.executeQuery(); System.out.println("---------------------查询结果如下所示---------------------"); while(rs.next()){ System.out.println("手机序号："+rs.getString("id")+"\t手机厂商："+rs.getString("name") +"\t手机型号："+rs.getString("type")+"\t价格："+rs.getString("price") +"\t出厂时间："+rs.getString("time")); } } catch (SQLException e) { e.printStackTrace(); } UserManage.adminMenu(); } }