本文实例讲述了jdbc链接oracle数据库功能。分享给大家供大家参考,具体如下:
代码如下
packagecom.sefvang.jdbc;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.SQLException;
publicclassDb_conn {
privatestaticfinalString url ="jdbc:oracle:thin:@localhost:1521:orcl";
privatestaticfinalString name ="system";
privatestaticfinalString passwd ="sefvang";
privatestaticfinalString Db_driver ="oracle.jdbc.OracleDriver";
publicConnection getConnection() {
Connection conn =null;
try{
Class.forName(Db_driver);
conn = DriverManager.getConnection(url, name, passwd);
if(conn !=null) {
System.out.println("success!!!");
}
}catch(ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}catch(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
returnconn;
}
publicvoidclose(Connection conn) {
try{
if(conn !=null) {
if(!conn.isClosed()) {
conn.close();
}
}
}catch(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
publicstaticvoidmain(String[] args) {
Db_conn conn=newDb_conn();
Connection con = conn.getConnection();
try{
PreparedStatement papt = con.prepareStatement("select tname from text where tid=1");
ResultSet rs = papt.executeQuery();
if(rs.next())
System.out.println(rs.getString(1));
}catch(SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
conn.close(con);
}
}
jdbc链接oracle数据库_jdbc连接oracle数据库功能实例
http://m.bbyears.com/shujuku/118590.html
推荐访问:oracle jdbc连接