public ShowSale(){
JFrame my=new JFrame();
JLabel lb=new JLabel(" 总销售额:");
JPanel p=new JPanel();
JTextField tf=new JTextField();
Object ob[][];
Object name[]={"编号","连锁店","商品代号","单价","数量","总价"};
DefaultTableModel dtm;
JTable table;
setLocation(0,50);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:MyOdbc","","");
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from [Sheet1$] where 编号<>'0';");
rs.last();
int lastNumber=rs.getRow();
ob=new Object[lastNumber][6];
int i=0;
String t,o;
float total=0;
rs.beforeFirst();
while(rs.next()){
ob[i][0]=rs.getLong(1);
ob[i][1]=rs.getString(2);
ob[i][2]=rs.getString(3);
ob[i][3]=rs.getString(4);
ob[i][4]=rs.getInt(5);
ob[i][5]=rs.getFloat(6);
total+=rs.getFloat(6);
i++;
}
o=Float.toString(total); //将总价转换为STRING
dtm=new DefaultTableModel(ob,name);
table=new JTable(dtm);
table.setFont(new Font("黑体",Font.BOLD,16));
JScrollPane jt=new JScrollPane();
setLayout(new BorderLayout());
jt.setViewportView(table);
add(jt,BorderLayout.CENTER);
tf.setText(""+o);
p.setLayout(new GridLayout(1,4,5,5));
lb.setFont(new Font("黑体",Font.BOLD,16));
tf.setFont(new Font("黑体",Font.BOLD,16)); p.add(lb);
p.add(tf);
add(p,BorderLayout.SOUTH);
setTitle("所有销售记录");
setSize(850,500);
setVisible(true);
con.close();
}
catch(Exception e){
e.printStackTrace();
}}}
//大致如何实现,在哪个地方要增加什么算法,求高手指点
JFrame my=new JFrame();
JLabel lb=new JLabel(" 总销售额:");
JPanel p=new JPanel();
JTextField tf=new JTextField();
Object ob[][];
Object name[]={"编号","连锁店","商品代号","单价","数量","总价"};
DefaultTableModel dtm;
JTable table;
setLocation(0,50);
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:MyOdbc","","");
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from [Sheet1$] where 编号<>'0';");
rs.last();
int lastNumber=rs.getRow();
ob=new Object[lastNumber][6];
int i=0;
String t,o;
float total=0;
rs.beforeFirst();
while(rs.next()){
ob[i][0]=rs.getLong(1);
ob[i][1]=rs.getString(2);
ob[i][2]=rs.getString(3);
ob[i][3]=rs.getString(4);
ob[i][4]=rs.getInt(5);
ob[i][5]=rs.getFloat(6);
total+=rs.getFloat(6);
i++;
}
o=Float.toString(total); //将总价转换为STRING
dtm=new DefaultTableModel(ob,name);
table=new JTable(dtm);
table.setFont(new Font("黑体",Font.BOLD,16));
JScrollPane jt=new JScrollPane();
setLayout(new BorderLayout());
jt.setViewportView(table);
add(jt,BorderLayout.CENTER);
tf.setText(""+o);
p.setLayout(new GridLayout(1,4,5,5));
lb.setFont(new Font("黑体",Font.BOLD,16));
tf.setFont(new Font("黑体",Font.BOLD,16)); p.add(lb);
p.add(tf);
add(p,BorderLayout.SOUTH);
setTitle("所有销售记录");
setSize(850,500);
setVisible(true);
con.close();
}
catch(Exception e){
e.printStackTrace();
}}}
//大致如何实现,在哪个地方要增加什么算法,求高手指点
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货