JDBC

package com.lovo.jdbc;


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


/**
 * JDBC 步骤
 * 1、加载驱动
 * 2、创建连接对象
 * 3、创建声明语句对象
 * 4、执行SQL语句，通过executeUpdate(sql)、executeQuery(sql)执行
 * 5、关闭各对象
 *
 */


public class JDBC {
//SQLServer驱动类路径
private String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//SQLServer连接字串
private String url = "jdbc:sqlserver://localhost:1433;DatabaseName=student";
//数据库连接用户名
private String userName = "sa";
//数据库连接密码
private String password = "mfkykiytb";
private Connection conn = null;
public JDBC(){
try {
//利用反射加载类
Class.forName(driver);
//创建连接
this.conn = DriverManager.getConnection(this.url, this.userName, this.password);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
public static void main(String[] args) {
JDBC jdbc = new JDBC();
jdbc.insertBatch();



}
public ResultSet getResult(String id1,String id2){
String sql = "select * from class where id = ? or id = ?";
try {
//声明并创建预处理语句对象
PreparedStatement ps = conn.prepareStatement(sql);
//设置预处理语句对象的各个参数，有几个问号就设置多少个
ps.setObject(1, id1);
ps.setObject(2, id2);
//执行
return ps.executeQuery();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

return null;
}
public void update(String id,String name){
String sql = "insert into class (id,name) values (?,?)";
try {
PreparedStatement ps = conn.prepareStatement(sql);

ps.setObject(1, id);
ps.setObject(2, name);
ps.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void insertBatch(){
try {
//声明并创建语句对象
Statement st = conn.createStatement();
//设置连接的自动提交为false，使操作不自动提交数据库
this.conn.setAutoCommit(false);
//语句对象的批量处理加入SQL语句
st.addBatch("insert into class (id,name) values ('12','AAA')");
st.addBatch("insert into class (id,name) values ('13','AAA')");
st.addBatch("insert into class (id,name) values ('14','AAA')");
st.addBatch("insert into class (id,name) values ('15','AAA')");
//执行批量处理中的SQL语句
st.executeBatch();
//提交
this.conn.commit();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
}