import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class JDBCTest {
public static void testConn() {
Connection conn = null;// 创建一个数据库连接
Statement stmt = null;// 创建编译语句对象
// PreparedStatement ps = null;// 创建预编译语句对象
ResultSet rs = null;// 创建一个结果集对象
try {
// 1.加载数据库驱动
// Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
// Class.forName("com.mysql.jdbc.Driver");
// Class.forName("org.postgresql.Driver");
Class.forName("oracle.jdbc.driver.OracleDriver");
// 2.创建数据库连接对象
// Connection conn =
// DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=db","sa","sqlpass");
// Connection conn =
// DriverManager.getConnection("jdbc:mysql://localhost:3306/db","root","123456");
// Connection conn =
// DriverManager.getConnection("jdbc:postgresql://localhost:5433/db","root","123456");
conn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:orcl", "scott", "scott");
// 3.创建数据库命令执行对象
stmt = conn.createStatement();
// PreparedStatement ps =
// conn.prepareStatement("select * from product where name =?");
// ps.setString(1, "测试");
// 4.执行数据库命令
rs = stmt.executeQuery("select * from product");
// ResultSet rs = ps.executeQuery();
// 5.遍历结果集set
while (rs.next()) {
int id = rs.getInt("id");
String name= rs.getString("name");
String info= rs.getString("info");
System.out.println(id + "\t" + name + "\t" + info);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
// 逐一将上面的几个对象关闭,因为不关闭的话会影响性能、并且占用资源
// 最后使用的最先关闭
if (rs != null)
rs.close();
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
System.out.println("已关闭数据库连接!");
} catch (Exception e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) throws Exception {
testConn();
}
}
很久没用jdbc了,有点生疏了。特写下此篇,记录一下。需要加载的数据库驱动包这里就不逐一注明了。
以上所有驱动包地址:点击打开链接