| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
ne3g
10年前发布

使用JDBC链接Oracle代码

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