JDBC - 删改查操作

package com.fy; import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; public class Test { public static void main(String[] args) throws Exception { //insert("司马懿"); //delete(5); update(1,"诸葛亮"); } public static void insert(String name) throws Exception{ //1. 注册驱动 Class.forName("com.mysql.jdbc.Driver"); //2. 获取数据库连接对象 Connection conn = DriverManager.getConnection("jdbc:mysql:///day0901","root","1234"); //3. 获取数据库连接对象, 发送SQL语句到数据库 Statement stmt = conn.createStatement(); //4. 编写SQL语句 String sql = "insert into tb2 values (null,'"+name+"')"; // String sql = "insert into tb2 values (null,'"+name+"')"; int row = stmt.executeUpdate(sql); if(row != 0){ System.out.println("添加成功"); }else { System.out.println("添加失败"); } //7. 释放资源 stmt.close(); conn.close(); } private static void update(int id ,String name)throws Exception { Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql:///day0901", "root", "1234"); String sql = "update tb2 set name = '"+name+"' where id = " + id; Statement stmt = conn.createStatement(); int row = stmt.executeUpdate(sql); if(row != 0){ System.out.println("修改成功"); }else{ System.out.println("修改失败"); } } private static void delete(int id) throws Exception { Class.forName("com.mysql.jdbc.Driver"); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/day0901", "root", "1234"); String sql = "delete from tb3 where id = "+id; Statement stmt = conn.createStatement(); int row = stmt.executeUpdate(sql); if(row != 0){ System.out.println("删除成功"); }else{ System.out.println("删除失败"); } stmt.close(); conn.close(); } }

数据库中表的记录修改成功