package com.bochy;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
/**
* @author zhaoYuguang
* @version 1.0 链接Mysql数据库工具类
* */
public class ViewTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
// 加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
// 得到连接
Connection ct = DriverManager.getConnection(
"jdbc:oracle:thin:@127.0.0.1:1521:orcl", "scott", "admin");
Statement sm = ct.createStatement();
java.sql.ResultSet rs = sm.executeQuery("select * from test2");
while (rs.next()) {
System.out.println("用户名:" + rs.getString(2));
}
rs.close();
sm.close();
ct.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
oracle连接
最新推荐文章于 2023-05-17 21:51:43 发布