jdbcodbc.java

这是一个对学习数据库时

//package jdbctest;

import java.sql.*;

public class Jdbcodbc{
  public static void main(String[] args) {
    String url="jdbc:odbc:supermarket";
    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 Sale";
      ResultSet rs=stmt.executeQuery(sql);
      System.out.println("UserID      "+"USerName     "+"UserPW     "+"UseStyle");
     // int count=0; 
      while(rs.next()){
      // if(count++==50)
      //   break;
      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");}
  }
}