如何把数据库的数据,放在jtable中?能否给个完整的例子!!!!!!!!!!!!! 
谢了
可能不能给大家分了呀 新手,帮帮呀 

解决方案 »

  1.   

    import java.sql.*;
    public class ExampleJDBC
    {
      public static void main(String args[])
       {
         String name,xuehao;  Date date;  int  math,physics,english;
         Connection con;   Statement  sql;  ResultSet rs;
                   String url="jdbc:odbc:redsun";
         try {     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}//加载桥
             catch(ClassNotFoundException e){}
         try {con=DriverManager.getConnection(url);
                 sql=con.createStatement();//创建SQL语句
                 //所有学生的成绩:
                  rs=sql.executeQuery("SELECT * FROM chengjibiao");
                             //SELECT * FROM student.chengjibiao WHERE 学号='4'
                             //SELECT * FROM student.chengjibiao  WHERE 英语>=90
                  while(rs.next())
                         {
                           name=rs.getString(2);     xuehao=rs.getString(1);
                           date = rs.getDate(3);       math=rs.getInt("数学");
                            physics=rs.getInt("物理");    english=rs.getInt("英语");
                           System.out.print("姓名:  "+name+" ");
                            System.out.print("学号:  "+xuehao+" ");
                           System.out.print("出生:  "+date.toString()+" ");
                           System.out.print("数学:  "+math+" ");
                           System.out.print("物理:  "+physics+" ");
                            System.out.print("英语:  "+english+" ");
                            System.out.println("。");
                            }
                          con.close();}
                      catch(SQLException e1) {}
         }
    }