ResultSet result = prep.executeQuery();
ResultSetMetaData resmdata = result.getMetaData();
TextArea textDisplay;
int i = resmdata.getColumnCount();
while(result.next())
{
for (int j=1; j<=i; j++)
{
String str = resmdata.getColumnName(j);
textDisplay.append(str);
textDisplay.append(result.getString(j));
}
}
ResultSetMetaData resmdata = result.getMetaData();
TextArea textDisplay;
int i = resmdata.getColumnCount();
while(result.next())
{
for (int j=1; j<=i; j++)
{
String str = resmdata.getColumnName(j);
textDisplay.append(str);
textDisplay.append(result.getString(j));
}
}
在写个textarea这个类
就行了,
手头没有具体代码~~~
class servicelist extends JPanel
{
private DefaultTableModel philosophers;
private JTable table;
private JPanel panel;
public servicelist()
{
panel=new JPanel();
philosophers = new DefaultTableModel();
// add Columns to DefaultTableModel
philosophers.addColumn( "服务代号" );
philosophers.addColumn( "服务名称" );
philosophers.addColumn( "服务价格(美圆)" );
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:lilu");
Statement stmt=con.createStatement();
String sqlstring;
sqlstring="select * from serverType order by serverid";
ResultSet result=stmt.executeQuery(sqlstring);
while(result.next()){
String[] socrates = { result.getString(1), result.getString(2), result.getString(3) };
philosophers.addRow( socrates );
}
stmt.close();
con.close();
}catch(Exception e){ System.out.println(e); }
// create a JTable for philosophers DefaultTableModel
table = new JTable( philosophers );
panel.add( new JScrollPane( table ));
//panel.setSize(400,300);
add(panel);
}
}