JDBC编程六步(笔记)

JDBC编程六步

Connection conn = null;
Statement sta = null;
ResultSet rs = null;

1、注册驱动（反射方式）

//1、注册驱动（反射方式）
Class.forName("com.mysql.jdbc.Driver");

1、注册驱动（基础方式）

Driver driver = new com.mysql.jdbc.Driver();
DriverManager.registerDriver(driver);

2、获取连接

//2、获取连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/bjpowernode","root","123456");

3、获取数据库连接对象

//3、获取数据库连接对象
sta = conn.createStatement();

4、执行sql

String sql = "select ename,sal from emp;";

//4、执行sql
rs = sta.executeQuery(sql);

5、处理查询结果集

//5、处理查询结果集
while(rs.next()){
    String ename = rs.getString("ename");
    String sal = rs.getString("sal");
    System.out.println("名称："+ename+"，工资："+sal);
}

6、释放资源

//释放资源
if (rs != null) {
    try {
        rs.close();
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    }
}
if (sta != null) {
    try {
        sta.close();
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    }
}
if (conn != null) {
    try {
        conn.close();
    } catch (SQLException throwables) {
        throwables.printStackTrace();
    }
}

完整框架：

    Connection conn = null;
    Statement sta = null;
    ResultSet rs = null;
    try {
        //1、注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        //2、获取连接
       	conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/bjpowernode","root","(密码)");
        //3、获取数据库连接对象
        sta = conn.createStatement();
        //4、执行SQL
        String sql = "select ename,sal from emp;";
        rs = sta.executeQuery(sql);
        //5.处理查询结果集
        while(rs.next()){
            String ename = rs.getString("ename");
            String sal = rs.getString("sal");
            System.out.println("名称："+ename+"，工资："+sal);
        }
    } catch (Exception e) {
        e.printStackTrace();
    }finally{
        //释放资源
        if (rs != null) {
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if (sta != null) {
            try {
                sta.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }