JTabel中加入数据库内容

   //只要写入要查询的SQL语句语句，和要填入数据库内容的JTabel名就可以了

 public void changeTable(String sql,JTable t){
  DefaultTableModel JTableModel = new DefaultTableModel();
  try{  

     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");                               //首先连接数据库
     String url="jdbc:odbc:payout";
     String user="ss";
     String password="";
     Connection conn=DriverManager.getConnection(url,user,password);
     Statement stmt=conn.createStatement   (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
      ResultSetMetaData matedata;
      ResultSet  rs=stmt.executeQuery(sql);
      matedata=rs.getMetaData();
      int cloumncout=matedata.getColumnCount();
      str=new String[cloumncout];
                                                                                                      //加入列名
     for(int i=0;i<cloumncout;i++){
             str[i]=matedata.getColumnName(i+1);
             JTableModel.addColumn(str[i]);
      }
     rs.last();
     int all=rs.getRow();
      rs.beforeFirst();
     while(rs.next()){                                                               //向表中加入内容，先用Vector容器提取一行的内容.
             Vector v=new Vector();                                           
             for(int i=0;i<cloumncout;i++){
                     v.addElement(rs.getString(i+1));     
             }
             JTableModel.addRow(v);                                      //然后将一行的内容放在JTabelModel大容器中
    }
   
    rs.close();
   stmt.close();
   conn.close();
   }catch(Exception e){System.out.println(e);}
   t.setModel(JTableModel);                                               //最后将弄好的JTabelModel放在表中。       
}