java jdbc oracle代码_通过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();

}

}