使用JDBC添加和删除记录

import  java.sql.Connection;
import  java.sql.DriverManager;
import  java.sql.ResultSet;
import  java.sql.SQLException;
import  java.sql.Statement;

public   class  TestDML  ... {

    public static void main(String[] args) ...{
        Statement stmt = null;
        Connection conn = null;
        try ...{
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost/data?user=root&password=123456";
            conn = DriverManager.getConnection(url);
            stmt = conn.createStatement();
            //添加一条记录
            String insertSql = "insert into user values (2, 'I', 'love')";
            stmt.executeUpdate(insertSql);
            //删除一条记录
            String deleteSql = "delete from user where id=2";
            stmt.executeUpdate(deleteSql);
        } catch (ClassNotFoundException e) ...{
            e.printStackTrace();
        } catch (SQLException e) ...{
            e.printStackTrace();
        } finally ...{
            try ...{
                if(stmt != null) ...{
                    stmt.close();
                    stmt = null;
                }
                if(conn != null) ...{
                    conn.close();
                    conn = null;
                }
            } catch (SQLException e) ...{
                e.printStackTrace();
            }
        }
    }

}