「Java入門」JavaでJDBCを利用してOracleデータベースに接続する方法

2014年7月26日

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())
{
}
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())
{

}
rs.close();
ps.close

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

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