Code666 (代码贴、代码片段)

[Java] 通过Java JDBC链接Oracle数据库 →→→→→进入此内容的聊天室

来自 , 2020-11-21, 写在 Java, 查看 153 次.
URL http://www.code666.cn/view/c44e5038
  1.  
  2. public class OracleJdbcTest  
  3. {  
  4. String driverClass =
  5.  
  6. "oracle.jdbc.driver.OracleDriver";  
  7.  
  8. Connection con;  
  9.  
  10. public void init
  11.  
  13.  
  15.  
  16.  
  17. {  
  18. Properties props = new Properties();  
  19.  
  20.  
  21. props.load(fs);  
  22.  
  23.  
  24. String url = props.getProperty
  25.  
  26. ("db.url");  
  28.  
  29. userName = props.getProperty("db.user");  
  30.  
  31.  
  32. String password = props.getProperty
  33.  
  34. ("db.password");  
  35. Class.forName(driverClass);  
  36.  
  37. con=DriverManager.getConnection(url,
  38.  
  39. userName, password);  
  40. }  
  41.  
  42. public void fetch() throws SQLException,
  43.  
  45. {  
  46.  
  47.  
  49.  
  50. con.prepareStatement("select SYSDATE from dual");  
  51.  
  52.  
  53. ResultSet rs = ps.executeQuery
  54.  
  55. ();  
  56.  
  57. while
  58.  
  59. (rs.next())  
  60. {  
  61.  
  62.  
  63. // do the
  64.  
  65. thing you do  
  66. }
  67.  
  68.    
  69. rs.close();  
  70.  
  71.  
  72. ps.close();  
  73.  
  74.  
  75. }  
  76.  
  77. public
  78.  
  79. static void main(String[] args)  
  80. {  
  81.  
  82.  
  83. OracleJdbcTest test = new
  84.  
  85. OracleJdbcTest();  
  86. test.init();  
  87. test.fetch
  88.  
  89. ();  
  90. }  
  91. }  
  92.  
  93.  
  94.  
  95. public class OracleJdbcTest
  96. {
  97. String driverClass =
  98.  
  99. "oracle.jdbc.driver.OracleDriver";
  100.  
  101.  
  103.  
  104.  
  105. public void init(FileInputStream fs) throws ClassNotFoundException,
  106.  
  107.  
  109. {
  110. Properties props = new Properties();
  111. props.load
  112.  
  113. (fs);
  114. String url = props.getProperty
  115.  
  116. ("db.url");
  117. String userName = props.getProperty
  118.  
  119. ("db.user");
  120. String password = props.getProperty
  121.  
  122. ("db.password");
  123. Class.forName(driverClass);
  124.  
  125.  
  126. con=DriverManager.getConnection(url, userName,
  127.  
  128. password);
  129. }
  130.  
  131.  
  132. public void fetch() throws SQLException, IOException
  133. {
  134. PreparedStatement ps = con.prepareStatement("select SYSDATE from
  135.  
  136.  
  137.  
  138. dual");
  139. ResultSet rs = ps.executeQuery();
  140.  
  141.  
  142. while (rs.next())
  143. {
  144. // do the
  145.  
  146. thing you do
  147. }
  148. rs.close();
  149. ps.close
  150.  
  151. ();
  152. }
  153.  
  154.  
  155. public static void main(String[] args)
  156. {
  157. OracleJdbcTest test = new OracleJdbcTest
  158.  
  159. ();
  160. test.init();
  161. test.fetch();
  162. }
  163. }

回复 "通过Java JDBC链接Oracle数据库"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666