example23_6.java.bak

不错的教程 适合中高级人员的使用

import java.sql.*;
public class Example23_5
{  public static void main(String args[])
   {  Connection con;Statement sql; ResultSet rs;
      try {  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  
          }
     catch(ClassNotFoundException e)
          {  System.out.println(""+e);
          }
      try
          {  con=DriverManager.getConnection("jdbc:odbc:redsun","snow","ookk");
             sql=con.createStatement();
             String condition="SELECT 姓名,英语 FROM chengjibiao ORDER BY 英语";
             rs=sql.executeQuery(condition);
             while(rs.next())
             { String  name=rs.getString(1);  
               int  english=rs.getInt(2);
               System.out.println("  姓名："+name);
               System.out.print("  英语："+english);
             }
            con.close();
           }
      catch(SQLException e1) { System.out.print(e1);}
   }    
}