JDBC - Statement的增删改查

JDBC编程基本步骤
1.加载驱动程序：class.forName(driverClass) ;
加载Mysql驱动：class.forName(“com.mysql.jdbc.Driver”);
加载Oracle驱动：class.forName(“oracle.jdbc.driver.OracleDriver”);
2.获取数据库连接
Connection conn = DriverManager.getConnection( String url, String user , String password);
3.创建Statement对象 conn.createStatement(); —操作数据库，实现增删改查
Statement stmt = conn.createStatement();

具体代码如下：

package Procedure;

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

public class testStatement {

    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        //1.加载驱动程序
        String driver = "oracle.jdbc.driver.OracleDriver";
        Class.forName(driver);
        //2.获取数据库连接
        String  url ="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
        String user="scott";
        String password ="tiger";
        Connection conn = DriverManager.getConnection(url, user, password);
        //3.创建Statement对象，操作数据库，实现增删改查
        Statement stmt = conn.createStatement();
        //【查询】---将结果集放入ResultSet
        ResultSet rs = stmt.executeQuery("select * from emp");
        //遍历结果集rs
        while(rs.next()) {
            System.out.println(rs.getString(1)+"---"+rs.getString(2)+"---工资：￥"+rs.getString(6));
        }
        //【增加】
        String sql="insert into emp(empno,ename,sal) values('7277','Liwan',1500)";    //插入数据的SQL语句  
        int i = stmt.executeUpdate(sql);
        if(i==0){ 
            System.out.println("增加失败");  //如果成功i不为0，执行成功
        }
        //【修改】
        String sql1="update emp set ename ='wangwu' where empno = '7277'";    //修改数据的SQL语句  
        int j = stmt.executeUpdate(sql1);
        if(j==0){ 
            System.out.println("修改失败");  //如果成功i不为0，执行成功
        }
        //【删除】
        String sql2="delete from emp  where empno = '7277'";    //删除数据的SQL语句  
        int k = stmt.executeUpdate(sql2);
        if(k==0){ 
            System.out.println("删除失败");  //如果成功i不为0，执行成功
        }
        // 最后关闭连接
        if(conn!=null){   
              conn.close();
        }
        if(stmt!=null){  
              stmt.close();
        }
    }
}