querystudent.java

来自「基于数据库的基本应用问题」· Java 代码 · 共 29 行

import java.sql.*;
public class QueryStudent{
  public static void main(String args[]){
    String url="jdbc:odbc:mydata";
    String sql="SELECT * FROM student1";
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }catch(java.lang.ClassNotFoundException e){
       System.err.println(e.getMessage());
    }
    try{
      Connection con=DriverManager.getConnection(url,"",null);
      Statement stmt=con.createStatement();
      ResultSet rs=stmt.executeQuery(sql);
      while(rs.next()){
        String s1=rs.getString("name");
        String s2=rs.getString("sex");
        Date d=rs.getDate("birthday");
        boolean v=rs.getBoolean("leave");
        int n=rs.getInt("stnumber");
        System.out.println(s1+","+s2+","+d+","+v+","+n);
      }      
      stmt.close();
      con.close();
    }catch(SQLException ex){
       System.out.println("Message:"+ex.getMessage());
    }    
  }
}