会python真的可以为所欲为0(回)
447天前
这里还有人吗1(回)
632天前这里还有人吗0(回)
632天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
857天前到处都是羊，不想上班0(回)
937天前
鸽子
0(回)
941天前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 |
{ |
// code from http://yuncode.net |
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(); |
} |
} |
//源代码片段来自云代码http://yuncode.net |
|
