JDBC进阶

PreparedStatement的使用：

conn = DriverManager.getConnection("jdbc:mysql://localhost/mydata?"
                    + "user=root&password=root");
            pstmt = conn.prepareStatement("insert into dept values (?,?,?)");
            pstmt.setInt(1,deptno);
            pstmt.setString(2,dname);
            pstmt.setString(3,loc);
            pstmt.executeUpdate();

transaction:

单词本身是交易的意思

在数据库中，保证语句要么同时执行成功，要么同时执行失败，典型例子银行转账

import java.sql.*;
public class TestJDBC {

    public static void main(String[] args)  {
        Connection conn = null;
        Statement stmt = null;
        try {
            Class.forName("oracle.jdbc.OracleDriver");
            conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","tigger");
            conn.setAutoCommit(false);
            stmt = conn.createStatement();
            stmt.addBatch("insert into example values(12,'Game','BeiJing')");
            stmt.addBatch("insert into example values(13,'Game','BeiJing')");
            stmt.addBatch("insert into example values(14,'Game','BeiJing')");
            stmt.executeBatch();
            conn.commit();
            conn.setAutoCommit(true);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
            if(conn != null) {
                try {
                    conn.rollback();//一旦出错，要重新设置成自动执行
                    conn.setAutoCommit(true);
                } catch (SQLException e1) {
                    e1.printStackTrace();
                }
            }
        }
        try {
            stmt.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

}