jdbc-odbc.java

来自「这是一个对学习数据库时」· Java 代码 · 共 32 行

//package jdbctest;

import java.sql.*;

public class Jdbcodbc {
  public static void main(String[] args) {
    String url="jdbc:odbc:sqlserver";
    Connection conn;
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      System.out.println("succeed");

    }//try
    catch(Exception e1){e1.printStackTrace();System.out.println("can not find the driver");}
    try{
      conn=DriverManager.getConnection(url,"sa","8984427650");
      //System.out.println("database connect succeed");
      Statement stmt=conn.createStatement();
      String sql="select * from Shippers";
      ResultSet rs=stmt.executeQuery(sql);
      System.out.println("序列号"+"公司名"+"电话号码");
      while(rs.next()){
      System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3));}
     rs.close();
     conn.close();
  }
    catch(Exception e2){e2.printStackTrace();
    System.out.println("url problem");}
  }
}