`

连接ORACLE

阅读更多
 1 import java.sql.*;
 2 
 3 public class OracleConn
 4 {
 5     Connection conn;
 6     public OracleConn()
 7     {
 8         try
 9         {
10             Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
11             String  urlname = "jdbc:oracle:thin:@localhost:1521:hcm";
12             String user ="system";
13             String pw = "manager";
14             conn = DriverManager(urlname,user,pw).getConnection();
15         }
16         catch(Exception ep)
17         {
18             ep.printStackTrace();
19             conn = null;
20         }
21     }
22     public ResultSet getRS(String sql)
23     {
24         try
25         {
26             Statement stm = con.creatStatement();
27             ResultSet rs = stm.executeQuery(sql);
28             return rs;
29         }catch (Exception e)
30         {
31             e.printStackTrace();
32             return null;
33         }
34     }
oracle的连接,测试成功!
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics