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

import java.sql.*;
import java.util.*;
 
public   class   FirstJDBCPro {
  public  static void main(String[] args){
    if(args.length < 4){
    System.out.println("Usage: java "+FirstJDBCPro.class.getName()
                               + " dbdriver dburl user password"
                               );
    return;
    }
    Connection con = null;
    Statement stm = null;
    ResultSet rs = null;
  try{
       //1. Register jdbc drivers
       Class.forName(args[0]);
       //2. Create database connection through DriverManager
       con = DriverManager.getConnection(args[1], args[2],args[3]);
       //con = DriverManager.getConnection(args[1],"",""); no name and no pwd
  //3. Prepare statement
       stm = con.createStatement();
       //4. Execute statement
       rs = stm.executeQuery("select * from tbl_user");
       //5. handle result
       while(rs.next()){
         System.out.print("id: " + rs.getString(1));
         System.out.print("\tname: " + rs.getString(2));
     System.out.println("\tpassword: "+rs.getString(3));
       }
     }catch(Exception e){ e.printStackTrace();}
     finally{//6. release resources
        if(rs != null) try{ rs.close(); }catch(Exception e){}
        if(stm != null) try{ stm.close(); }catch(Exception e){}
        if(con != null) try{ con.close(); }catch(Exception e){}
     }
  }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

RETCODE = -1
ERROR - Generating SQLException...
SQLException: SQLState(IM002) vendor code(0)
java.sql.SQLException: [Microsoft][ODBC 驅動程式管理員] 找不到資料來源名稱且未指
定預設的驅動程式
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
        at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at dbconnect.main(dbconnect.java:19)
Closing connection (SQLFreeConnect), hDbc=405279480
Closing environment (SQLFreeEnv), hEnv=405279312
getConnection failed: java.sql.SQLException: [Microsoft][ODBC 驅動程式管理員] 找
不到資料來源名稱且未指定預設的驅動程式
Database access failedjava.sql.SQLException: [Microsoft][ODBC 驅動程式管理員] 找
不到資料來源名稱且未指定預設的驅動程式

1
2
3
4
5
6
7
8
9
10
11
12

SQL> desc ktable1;
 名稱                                      空值?    型態
 ----------------------------------------- -------- ----------------------------
 C1                                                 VARCHAR2(100)
 
SQL> select * from ktable1;
 
C1
--------------------------------------------------------------------------------
200
300
400

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

import java.sql.*;
 
public class dbquery {
 
  
  public static void main(String[] args) {
    Connection myconn;
    Statement sqlstatement;
    ResultSet rs;
    try{
      //載入JDBC-ODBC driver
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      //使用data sourece來連結資料庫
      myconn = DriverManager.getConnection("jdbc:odbc:kktest","kuser1","k1234");
      sqlstatement =  myconn.createStatement();
      rs = sqlstatement.executeQuery("select * from ktable1");
      while (rs.next())
      {
        //該ktable1只有一個欄位
        String col1 = rs.getString(1);
        System.out.println(col1);
      }
      rs.close();
      sqlstatement.close();
      myconn.close();
      System.exit(0);
      
    }
    catch (Exception e)
    {
      System.err.println(e);
    }
    
  }
 
}

1
2
3
4
5
6
7
8
9
10

D:\Documents and Settings\^_^\test1>tnsping ktest
 
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 09-8月 -2
005 10:12:25
 
(c) Copyright 1997 Oracle Corporation.  All rights reserved.
 
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=10.26.128.56)(PORT=1521))
OK (30 msec)