解剖JDBS代码(浅显易懂)
1、首先在Eclipse里面新建一个类,名为EmpDB
2、程序内容:
package com.sie.train;
//导入Oracle JDBC的JAR包
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* @author SIE-ZKY
* @version 2019-4-19 上午11:36:04
* @description JDBC演示代码
*/
public class DeptDB {
public static void main(String[] args) {
try {
// (1)加载驱动,把驱动库加载到内存,会出现红色波浪线,alt+enter选第二个抛出异常
Class.forName("oracle.jdbc.driver.OracleDriver");
// (2)建立连接通道,会出现红色波浪线,alt+enter选第二个抛出异常
String url = "jdbc:oracle:thin:@61.145.96.125:1522:DEMO";// DEMO是数据库名,可从tnsnames.ora
String user = "apps";
String password = "apps";
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println("已建立连接通道");
// (3)创建Statement 对象,通过此对象向数据库发送SQL语句
String sql = "SELECT d.deptno,d.dname,d.loc FROM scott.dept d ";
Statement stmt = conn.createStatement();
// (4)执行SQL语句,这个ResultSet在内存内
ResultSet rSet = stmt.executeQuery(sql);
System.out.println("SQL语句已经执行完毕");
// (5)处理结果集ResultSet,这个next的作用是记录指针往下移,第二个作用是判断是否还有记录
while (rSet.next()) {
int deptno = rSet.getInt("deptno");
String dname = rSet.getString("dname");
String loc = rSet.getString("loc");
System.out.println("deptno:" + deptno + "\t dname:" + dname
+ " \t loc:" + loc);
}
// (6)关闭数据库连接,注意关闭顺序
// (6.1)先关闭结果集
rSet.close();
// (6.2)关闭Statement对象
stmt.close();
// (6.3)关闭连接对象Connection
conn.close();
System.out.println("已成功关闭数据库连接");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
3、结果: