作为一个刚接触Java的菜鸟当你能写出 Hello Word 之后,还想做一个读取 Oracle 数据库的例子
1.需要安装好Oracle,并且配置好Oracle的客户端。利用PL/SQL等工具能保证连接数据库
2.需要下载ojdbc6.jar包,可以通过百度或CSDN查找
3.菜鸟可能不知道如何引用ojdbc6.jar到自己的工程,可以在工程上右键点击Properties菜单,选取 Java Build Path分类的Libraries选项卡。进行如图设置
4.基本调试按键 F6,单步执行
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class T {
/**
* @param args
*/
public static void main(String[] args) {
System.out.println("---Enter Main--");
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
//Connection conn = DriverManager.getConnection(
// jdbc:oracle:thin:@Oracle服务器IP:1521:OralceSID名称", "Oracle用户","Oracle密码");
// "jdbc:oracle:thin:@10.152.0.51:1521:mySid", "User","Pass");
Connection conn = DriverManager.getConnection(
"jdbc:oracle:thin:@10.152.0.51:1521:cdfhq", "congou","congou");
System.out.println("连接OK");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("Select * From All_Tables Where RowNum < 10");
int i=0;
while (rs.next()) {
i++;
System.out.println("记录 " + i);
System.out.println(rs.getString( "Table_Name"));
// System.out.println(rs.getInt("INFOID"));
}
rs.close();
stmt.close();
conn.close();
} catch (ClassNotFoundException e) {
System.out.println("ClassNotFoundException");
} catch (SQLException e) {
System.out.println("SQLException");
}
}
}