作者:乔山办公网日期:
返回目录:excel表格制作
当然可以 excel就是表格吗 用JTable 就行了
public void inithavesold(){//建立查询已销售商品表格、模型e79fa5e98193e58685e5aeb9363
try {
Vector<String> columnName = new Vector<String>();//字段名
Vector<Vector<Object>> dataVector = new
Vector<Vector<Object>>(); //存储所有数据,里面每个小的Vector是存单行的
columnName.add("编号");
columnName.add("商品名");
columnName.add("数量");
columnName.add("价格");
columnName.add("总盈利");
conn = DataBase.getconnection();
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from havesold");
while(rs.next()){
Vector<Object> vec = new Vector<Object>();//就是这个存单行的,最后放到上面的大的Vector里面
for(int i=1;i<=5;i++){
vec.add(rs.getObject(i));
}
dataVector.add(vec);
}
tmhavesold = new DefaultTableModel();//建立默认的JTable模型
tmhavesold.setDataVector(dataVector, columnName);//设定模型数据和字段
DataBase.free(conn, stmt, rs);
} catch (SQLException e) {
e.printStackTrace();
}
jtable.setModel(tmhavesold);
}
table = new JTable(dtModel);
table.setBounds(29, 24, 484, 216);
contentPane.add(table);
String path = textField.getText();
Read read=new Read();
read.openExcel(path);
String[][] data = new String[read.getRowCount(0)][read.getColCount(0)];
for (int i = 0; i <read.getRowCount(0); i++) {
for (int j = 0; j < read.getColCount(0); j++) {
data[i][j] = read.getCellContent(j, i);
}
}
String[] names = new String[] { "1", "2", "3" };
dtModel = new DefaultTableModel(data, names);
textField.getText();是你百读度取问Excel文件的根答目录专。属