DBConnectTest.java

来源：互联网发布：angularjs源码下载编辑：程序博客网时间：2024/06/13 04:56
import java.sql.*;
public class DBConnectTest {  private static Connection conn;
  public static void main(String[] args) {    // 测试连接Oracle817数据库    testOracleConnect();    // 测试连接Mssql2000数据库    // testMSSQLConnect();  }  static void testOracleConnect() {    try {      Class.forName("oracle.jdbc.driver.OracleDriver");      String lUrl = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";      conn = DriverManager.getConnection(lUrl, "scott", "tiger");      String sSQL = "select empno,ename from EMP";      Statement stmt = conn.createStatement();      ResultSet rsResult = stmt.executeQuery(sSQL);      while (rsResult.next()) {        System.out.println(rsResult.getString(2));      }      rsResult.close();      stmt.close();      conn.close();    } catch (Exception e) {      System.out.println("Not Found:" + e.getMessage());    }  }  static void testMSSQLConnect() {    try {      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");      String lUrl = "jdbc:microsoft:sqlserver://127.0.0.1:1433";      conn = DriverManager.getConnection(lUrl, "sa", "pwd");      String sSQL = "select people_name from hr_people";      Statement stmt = conn.createStatement();      ResultSet rsResult = stmt.executeQuery(sSQL);      while (rsResult.next()) {        System.out.println(rsResult.getString(1));      }      rsResult.close();      stmt.close();      conn.close();    } catch (Exception e) {      System.out.println("Not Found:" + e.getMessage());    }  }}