This article introduces the jdbc encapsulation process from the java introduction column. I hope it can help students who are learning java!
JDBC encapsulation process:
Declare jdbc parameters
Declare jdbc variables
Load driver
Create connection object
Create SQL command
Create SQL command object
Placeholder assignment
Execute SQL command
Process the result
Close the resource
The encapsulation example is as follows:
import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; import com.bjsxt.entity.DBUtil; public class TestTrainsaltion { public static void main(String[] args) { //事物的练习 /** * 1、创建jdbc参数 * 2、创建jdbc变量 * 3、加载驱动 * 4、创建连接 * 5、创建SQL命令对象 * 6、创建SQL命令 * 7、执行SQL命令 * 8、处理结果 * 9、关闭资源 */ // //1、创建jdbc参数 // String driver = "oracle.jdbc.OracleDriver"; // String url="jdbc:oracle:thin:@localhost:1521:XE"; // String username="scott"; // String passwd="123456"; // //创建jdbc变量 Connection conn = null; PreparedStatement ps = null; //3、加载驱动 try { // Class.forName(driver); // //4、创建连接 // conn = conn = DriverManager.getConnection(url, username, passwd); conn=DBUtil.getConnection(); //5、开启事物 conn.setAutoCommit(false); //6、创建SQL命令对象 String sql="update t_account set money=money+? where aname=?"; //7、创建命令对象 ps = conn.prepareStatement(sql); //8、给占位符赋值 int i=0; //转账 ps.setDouble(1, 500); ps.setString(2, "李四"); int executeUpdate4 = ps.executeUpdate(); int executeUpdate3 = executeUpdate4; int executeUpdate2 = executeUpdate3; int executeUpdate = executeUpdate2; i = executeUpdate; ps.setDouble(1, -500); ps.setString(2, "张三"); i+=ps.executeUpdate(); //处理结果 if(i>=2){ System.out.println("转账成功"); }else{ System.out.println("转账失败"); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { ps.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }
The above is the detailed content of What is the encapsulation process of jdbc in java. For more information, please follow other related articles on the PHP Chinese website!