表格啊~~!自己也在做这个,发现自己学的东西太少了~~!下面是网上搜来的,自己加工了下~!对自己很有帮助~!下决心要用心看API了。有不合理的地方请大家多多提醒~~!谢谢啦
String [] columnName;/表头文字//
Object [][]rowData;表内荣格式
JTable jTable = new JTable();建立表格//
String []columnName ={}
Object [][]rowData = new Object[row][col];
Connection connn=null;
try {
int count=0;
int col=0;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String DataBase_URL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=库";
connn=DriverManager.getConnection(DataBase_URL, "sa", "sa");
Statement stmt=connn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM 表");
while(rs.next())
{
rowData[count][col] = rs.getString("列");
rowData[count][col] = rs.getString("列");
rowData[count][col] = rs.getString("列");
rowData[count][col] = rs.getString("列");
rowData[count][col] = rs.getString("列");
rowData[count][col] = rs.getString("列");
count++;
col++;
}
rs.close();//用完要关上哦
stmt.close();
connn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
model = new DefaultTableModel(row, col);
jTable = new JTable(model);
TableRowSorter sorter = new TableRowSorter(model);
jTable.setRowSorter(sorter);
scroll=new JScrollPane(jTable);
jTable.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent e) {
if(jTable.getValueAt(jTable.getSelectedRow(),0)!=null)
{
StringBuffer s = new StringBuffer ((String)jTable.getValueAtjTable.getSelectedRow(),0)); //获取所选中的行的第一个位置的内容
s.append(((String)jTable.getValueAt(jTable.getSelectedRow(),0)));//把后面的几列加进来
S0=jTable.getValueAt(jTable.getSelectedRow(), 0).toString();
S1=jTable.getValueAt(jTable.getSelectedRow(), 1).toString();
S2=jTable.getValueAt(jTable.getSelectedRow(), 2).toString();
S3=jTable.getValueAt(jTable.getSelectedRow(), 3).toString();
S4=jTable.getValueAt(jTable.getSelectedRow(), 4).toString();
S5=jTable.getValueAt(jTable.getSelectedRow(), 5).toString();
System.out.println("选中的信息:"+S0+"、"+S1+"、"+S2+"、"+S3+"、"+S4);
}
});
大体上是这样,不知道长时间和反复测试后会有什么影响,这个是我想知道的。谢谢