import java.io.*;
import java.sql.*;
import java.util.*;
public class TestConnect {
//1.创建获取连接方法
public static Connection getConnection() throws SQLException, IOException
{
//2.读取database.properties文件里的属性内容。属性文件内容在本文最后,放在项目下
Properties props = new Properties();
FileInputStream in = new FileInputStream("database.properties");
props.load(in);
in.close();
//3.获取驱动
String drivers = props.getProperty("jdbc.drivers");
if (drivers != null) System.setProperty("jdbc.drivers", drivers);
//4.获取连接地址
String url = props.getProperty("jdbc.url");
//5.获取用户名
String username = props.getProperty("jdbc.username");
//6.获取密码
String password = props.getProperty("jdbc.password");
return DriverManager.getConnection(url, username, password);
}
public static void main(String[] args) {
try {
//7.获取连接
Connection conn=getConnection();
try{
//8.创建语句集
Statement stat=conn.createStatement();
//9.结果集
ResultSet result = stat.executeQuery("SELECT * FROM person");
//获得元数据,即表中列字段名
showResultSet(stat);
//10.关闭结果集
result.close();
}finally{
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
//此方法获取表中元数据和数据,并打印在控制台
public static void showResultSet(Statement stat) throws SQLException
{
ResultSet result=stat.getResultSet();
ResultSetMetaData metaData=result.getMetaData();
int columnCount=metaData.getColumnCount();
for(int i=1;i<=columnCount;i++){
if(i>1)
System.out.print(",");
System.out.print(metaData.getColumnLabel(i));
}
System.out.println();
while(result.next())
{
for(int i=1;i<=columnCount;i++){
if(i>1)
System.out.print(",");
System.out.print(result.getString(i));
}
System.out.println();
}
result.close();
}
}
在项目里导入ojdbc6_g.jar Oracle jar包。官网可下载
database.properties文件内容:
jdbc.drivers=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@localhost:1521:orcl //orcl为数据库实例
jdbc.username=你的数据库用户名
jdbc.password=密码
然后就是建立数据库
SQL>CREATE TABLE PERSON(NAME CHAR(10),AGE NUMBER);
SQL>INSERT INTO PERSON VALUES('AAA','10');
SQL>EXIT
执行上面代码,执行结果:
NAME,AGE
AAA ,10