ODBC源已经配置好,没错
=====================================================================================================================================
private JTable getJTable() {
if (jTable == null) {
TableColumn tableColumn10 = new TableColumn();
tableColumn10.setHeaderValue("备注");
TableColumn tableColumn9 = new TableColumn();
tableColumn9.setHeaderValue("供应商");
TableColumn tableColumn8 = new TableColumn();
tableColumn8.setHeaderValue("合计");
TableColumn tableColumn7 = new TableColumn();
tableColumn7.setHeaderValue("进货数量");
TableColumn tableColumn6 = new TableColumn();
tableColumn6.setHeaderValue("进货单价");
TableColumn tableColumn5 = new TableColumn();
tableColumn5.setHeaderValue("进货日期");
TableColumn tableColumn4 = new TableColumn();
tableColumn4.setHeaderValue("进货人");
TableColumn tableColumn3 = new TableColumn();
tableColumn3.setHeaderValue("商品编码");
TableColumn tableColumn2 = new TableColumn();
tableColumn2.setHeaderValue("规格");
TableColumn tableColumn1 = new TableColumn();
tableColumn1.setHeaderValue("商品名称");
TableColumn tableColumn = new TableColumn();
tableColumn.setHeaderValue("商品大类");
tableColumn.setResizable(true);
tableColumn.setModelIndex(0);
tableColumn.setIdentifier("商品大类");
jTable = new JTable();
jTable.setAutoCreateColumnsFromModel(false);
jTable.setLocation(new Point(0, 0));
jTable.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
jTable.setBackground(new Color(102, 102, 0));
jTable.setCellSelectionEnabled(true);
jTable.setCursor(new Cursor(Cursor.E_RESIZE_CURSOR));
jTable.setFocusCycleRoot(true);
jTable.setGridColor(new Color(153, 153, 0));
jTable.setIntercellSpacing(new Dimension(2, 2));
jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jTable.setShowGrid(true);
jTable.addColumn(tableColumn);
jTable.addColumn(tableColumn1);
jTable.addColumn(tableColumn2);
jTable.addColumn(tableColumn3);
jTable.addColumn(tableColumn4);
jTable.addColumn(tableColumn5);
jTable.addColumn(tableColumn6);
jTable.addColumn(tableColumn7);
jTable.addColumn(tableColumn8);
jTable.addColumn(tableColumn9);
jTable.addColumn(tableColumn10);
Connection con;//与特定数据库的连接(会话)。
Statement sta;
ResultSet rs;//表示数据库结果集的数据表,通常通过执行查询数据库的语句生成。
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动程序
}
catch(ClassNotFoundException ee)
{ System.out.println(""+ee);
}
try {con=DriverManager.getConnection("jdbc:odbc:sell","","");
sta=con.createStatement();
rs=sta.executeQuery("SELECT * FROM 采购进货表");
while(rs.next())//遍历ResultSet
{
Vector<String> vector = new Vector<String>();
DateFormat df =DateFormat.getDateInstance();
vector.addElement(rs.getString("商品大类"));
vector.addElement(rs.getString("商品名称"));
vector.addElement(rs.getString("规格"));
vector.addElement(String.valueOf(rs.getInt("商品编码")));
vector.addElement(rs.getString("进货人"));
vector.addElement(rs.getString(df.format("进货日期")));
vector.addElement(String.valueOf(rs.getFloat("进货单价")));
vector.addElement(String.valueOf(rs.getInt("进货数量")));
vector.addElement(String.valueOf(rs.getFloat("合计")));
vector.addElement(rs.getString("供应商"));
vector.addElement(rs.getString("备注"));
}
//关闭连接
rs.close();
sta.close();
con.close();
}
catch(SQLException ex)
{ System.out.println(ex);}
}
return jTable;
}
=====================================================================================================================================
private JTable getJTable() {
if (jTable == null) {
TableColumn tableColumn10 = new TableColumn();
tableColumn10.setHeaderValue("备注");
TableColumn tableColumn9 = new TableColumn();
tableColumn9.setHeaderValue("供应商");
TableColumn tableColumn8 = new TableColumn();
tableColumn8.setHeaderValue("合计");
TableColumn tableColumn7 = new TableColumn();
tableColumn7.setHeaderValue("进货数量");
TableColumn tableColumn6 = new TableColumn();
tableColumn6.setHeaderValue("进货单价");
TableColumn tableColumn5 = new TableColumn();
tableColumn5.setHeaderValue("进货日期");
TableColumn tableColumn4 = new TableColumn();
tableColumn4.setHeaderValue("进货人");
TableColumn tableColumn3 = new TableColumn();
tableColumn3.setHeaderValue("商品编码");
TableColumn tableColumn2 = new TableColumn();
tableColumn2.setHeaderValue("规格");
TableColumn tableColumn1 = new TableColumn();
tableColumn1.setHeaderValue("商品名称");
TableColumn tableColumn = new TableColumn();
tableColumn.setHeaderValue("商品大类");
tableColumn.setResizable(true);
tableColumn.setModelIndex(0);
tableColumn.setIdentifier("商品大类");
jTable = new JTable();
jTable.setAutoCreateColumnsFromModel(false);
jTable.setLocation(new Point(0, 0));
jTable.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
jTable.setBackground(new Color(102, 102, 0));
jTable.setCellSelectionEnabled(true);
jTable.setCursor(new Cursor(Cursor.E_RESIZE_CURSOR));
jTable.setFocusCycleRoot(true);
jTable.setGridColor(new Color(153, 153, 0));
jTable.setIntercellSpacing(new Dimension(2, 2));
jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
jTable.setShowGrid(true);
jTable.addColumn(tableColumn);
jTable.addColumn(tableColumn1);
jTable.addColumn(tableColumn2);
jTable.addColumn(tableColumn3);
jTable.addColumn(tableColumn4);
jTable.addColumn(tableColumn5);
jTable.addColumn(tableColumn6);
jTable.addColumn(tableColumn7);
jTable.addColumn(tableColumn8);
jTable.addColumn(tableColumn9);
jTable.addColumn(tableColumn10);
Connection con;//与特定数据库的连接(会话)。
Statement sta;
ResultSet rs;//表示数据库结果集的数据表,通常通过执行查询数据库的语句生成。
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动程序
}
catch(ClassNotFoundException ee)
{ System.out.println(""+ee);
}
try {con=DriverManager.getConnection("jdbc:odbc:sell","","");
sta=con.createStatement();
rs=sta.executeQuery("SELECT * FROM 采购进货表");
while(rs.next())//遍历ResultSet
{
Vector<String> vector = new Vector<String>();
DateFormat df =DateFormat.getDateInstance();
vector.addElement(rs.getString("商品大类"));
vector.addElement(rs.getString("商品名称"));
vector.addElement(rs.getString("规格"));
vector.addElement(String.valueOf(rs.getInt("商品编码")));
vector.addElement(rs.getString("进货人"));
vector.addElement(rs.getString(df.format("进货日期")));
vector.addElement(String.valueOf(rs.getFloat("进货单价")));
vector.addElement(String.valueOf(rs.getInt("进货数量")));
vector.addElement(String.valueOf(rs.getFloat("合计")));
vector.addElement(rs.getString("供应商"));
vector.addElement(rs.getString("备注"));
}
//关闭连接
rs.close();
sta.close();
con.close();
}
catch(SQLException ex)
{ System.out.println(ex);}
}
return jTable;
}
解决方案 »
- 求高手指点:java.io.FileNotFoundException: D:\晋级\jdbc\01_传智播客JDBC_jdbc的理论概述 (拒绝访问。)
- JList能否改变指定单元格背景颜色?
- 求解
- 帮我设置下环境变量classpath和Path设置
- 如何让jsp中让表头大小固定?
- 如何解析这个字符串?
- 有偿转让Java即时通信工具源程序及设计文档
- 对Java参数传递不懂的请进来!
- 用java怎样判断一个Email地址是真实存在的?(救命呀!~~~>_<~~~)
- 高手救命:关于Runtime.getRuntime().exec()方法的问题
- 在swt里多线程操作snmp轮循的问题
- split 对“.”分割无效?
感觉我的没错哈
抛出这个异常