本文实例讲述了jdbc链接oracle数据库功能。分享给大家供大家参考，具体如下：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
package com.sefvang.jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class Db_conn { private static final String url = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String name = "system"; private static final String passwd = "sefvang"; private static final String Db_driver = "oracle.jdbc.OracleDriver"; public Connection 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(); } return conn; } public void close(Connection conn) { try { if (conn != null) { if (!conn.isClosed()) { conn.close(); } } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { Db_conn conn=new Db_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); }} |
希望本文所述对大家java程序设计有所帮助。
