通过Java JDBC链接Oracle数据库

[java]代码库

public class OracleJdbcTest   
{   
String driverClass = 

"oracle.jdbc.driver.OracleDriver";   

Connection con;   

public void init

(FileInputStream fs) throws ClassNotFoundException, 

SQLException, FileNotFoundException, IOException   


{   
Properties props = new Properties();   


props.load(fs);   


String url = props.getProperty

("db.url");   
String 

userName = props.getProperty("db.user");   


String password = props.getProperty

("db.password");   
Class.forName(driverClass);   

con=DriverManager.getConnection(url, 

userName, password);   
}   

public void fetch() throws SQLException, 

IOException   
{   


PreparedStatement ps = 

con.prepareStatement("select SYSDATE from dual");   


ResultSet rs = ps.executeQuery

();   

while 

(rs.next())   
{   


// do the 

thing you do   
}

   
rs.close();   


ps.close();   


}   

public 

static void main(String[] args)   
{   


OracleJdbcTest test = new 

OracleJdbcTest();   
test.init();   
test.fetch

();   
}   
}  



public class OracleJdbcTest
{
String driverClass = 

"oracle.jdbc.driver.OracleDriver";


Connection con;


public void init(FileInputStream fs) throws ClassNotFoundException, 


SQLException, FileNotFoundException, IOException
{
Properties props = new Properties();
props.load

(fs);
String url = props.getProperty

("db.url");
String userName = props.getProperty

("db.user");
String password = props.getProperty

("db.password");
Class.forName(driverClass);


con=DriverManager.getConnection(url, userName, 

password);
}


public void fetch() throws SQLException, IOException
{
PreparedStatement ps = con.prepareStatement("select SYSDATE from 



dual");
ResultSet rs = ps.executeQuery();


while (rs.next())
{
// do the 

thing you do
}
rs.close();
ps.close

();
}


public static void main(String[] args)
{
OracleJdbcTest test = new OracleJdbcTest

();
test.init();
test.fetch();
}
}