JDBC练习_insert语句和update语句
JDBC练习_insert语句
/* * account表 添加一条记录 insert语句 * */ public static void insert(){ Connection conn = null; Statement stmt = null; try { //注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //定义sql String sql = "insert into account values(null,'王五',3000)"; //获取Connection对象 conn = DriverManager.getConnection("jdbc:mysql:///db2", "root", "root"); //获取执行sql的对象 Statement stmt = conn.createStatement(); //执行sql int count = stmt.executeUpdate(sql);//影响行数 //6.处理结果 System.out.println(count); if (count > 0){ System.out.println("添加成功!"); }else { System.out.println("添加失败!"); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); }finally { if (stmt!=null){ try { stmt.close(); } catch (SQLException e) { e.printStackTrace(); } } if (conn!=null){ try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } }
JDBC练习_update语句
/* account表 修改记录 */ private static void update() { Connection conn = null; Statement stat = null; try { //注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); //获取Connection对象 conn = DriverManager.getConnection("jdbc:mysql:///db2", "root", "root"); //定义sql String sql = "update account set balance = 1500 where id = 3"; //获取执行sql的对象 Statement stat = conn.createStatement(); //执行sql int i = stat.executeUpdate(sql); //处理结果 System.out.println(i); if (i>0){ System.out.println("修改成功"); }else { System.out.println("修改失败"); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException throwables) { throwables.printStackTrace(); }finally { if (stat!=null){ try { stat.close(); } catch (SQLException throwables) { throwables.printStackTrace(); } } if (conn!=null){ try { conn.close(); } catch (SQLException throwables) { throwables.printStackTrace(); } } } }