数据库读取到grid

来源：互联网发布：淘宝买护肤品是否正品编辑：程序博客网时间：2024/05/22 11:20

当按下按钮的时候提取数据库信息

public void widgetSelected(SelectionEvent e) {
   try {
    table.removeAll();
    //table.
    Statement stmt=pfzhao.ychis.app.books.db.mysqlconn.getConnection().createStatement();
    String sql="select * from Book_User";
    ResultSet rs=stmt.executeQuery(sql);
    int index=0;

//遍历结果集
    while (rs.next()){
     int i=0;
     Book_User_ID=rs.getInt("Book_User_ID");
     Book_User_Name=rs.getString("Book_User_Name");
     Book_User_PassWord=rs.getString("Book_User_PassWord");
     Book_User_Enable=rs.getBoolean("Book_User_Enable");
     TableItem item=new TableItem(table, SWT.NONE);

//创建表列单元
     item.setText(i++,Book_User_ID+"");
     item.setText(i++,Book_User_Name);
     item.setText(i++,Book_User_PassWord);
     item.setText(i++,Book_User_Enable+"");
    }
    rs.close();
    stmt.close();

   } catch (SQLException e1) {
    // TODO Auto-generated catch block
    e1.printStackTrace();
   } catch (IOException e1) {
    // TODO Auto-generated catch block
    e1.printStackTrace();
   }

   }
  })