jdbc在建立连接的基础上发送sql语句的通道

话不多少，直接上代码：

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

public class MainClass {
	public static void main(String[] args) throws Exception {
		//1.注册驱动
		Class.forName("oracle.jdbc.driver.OracleDriver");
		//2.建立连接
		Connection conn = DriverManager.getConnection(
				"jdbc:oracle:thin:@localhost:1521:orcl", "wl", "123456");
		//测试连接
		System.out.println(conn.getAutoCommit());	
		//3.在连接的基础上建立发送sql语句的通道
		Statement sm = conn.createStatement();
		//发送sql语句
		//dql 
		//调用ResultSet rs = sm.executeQuery("select语句")，遍历结果集rs
		ResultSet rs = sm.executeQuery("select * from departments");
		
		while(rs.next()) {
			int department_id = rs.getInt("department_id");
			String department_name = rs.getString("department_name");
			System.out.println(department_id+","+department_name);
		}
		//dml 
		//int count = sm.executeUpdate("insert or update or delete语句")
		//返回的是影响的结果数
		int count = sm.executeUpdate("insert into departments values(201,'jishubu',202,1700)");
		int count = sm.executeUpdate("update departments set department_name = '技术部' where department_id = 201");
		System.out.println(count);	
		//关闭连接
		conn.close();
	}
}