java miniposs

Code:
importjavax.swing.*;
importjava.awt.*;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.ResultSetMetaData;
importjava.sql.SQLException;
importjava.sql.Statement;
importjava.util.ArrayList;

publicclassMainpanelimplementsActionListener{

JTextAreaarea2=newJTextArea(1,8);
JTextAreaarea1=newJTextArea(9,23);
JTextAreaarea3=newJTextArea(1,8);
JTextAreaarea7=newJTextArea(9,5);
JTextAreaarea4=newJTextArea(1,8);

JButtonconfirm=newJButton("计算");
JTextFieldProductsId=newJTextField(16);
JTextFieldProductsOrderCount=newJTextField(16);
JButtonsure=newJButton("8");

Strings1=newString();
Strings2=newString();
inttemp=0,temp1=0;
floatresult,price,abc,receivprice1_show;

Connectionconnection=null;
Statementstmt=null,stmt1=null;
ResultSetrs1=null,rs2=null;
Stringuser="sa";
Stringpassword="0019891128";

publicMainpanel(){
JFramepanel=newJFrame("MiniPoss系统");
ProductsId.setFont(newFont("黑体",1,20));

ProductsOrderCount.setFont(newFont("黑体",1,20));

JPanelpane1=newJPanel();
pane1.setLayout(newGridLayout(1,3));
JButtonbutton1=newJButton(newImageIcon("img/button1.png"));
JButtonbutton2=newJButton(newImageIcon("img/button2.png"));
JButtonbutton3=newJButton(newImageIcon("img/button3.png"));
JButtonbutton4=newJButton(newImageIcon("img/button4.png"));
button1.setPreferredSize(newDimension(72,72));
button2.setPreferredSize(newDimension(72,72));
button3.setPreferredSize(newDimension(72,72));
button4.setPreferredSize(newDimension(72,72));
pane1.add(button1);
pane1.add(button2);
pane1.add(button3);
pane1.add(button4);

JPanelpane=newJPanel();
pane.setLayout(newFlowLayout());

JLabelProductsIdlab=newJLabel("商品序列号：");
JLabelProductsOrderCountlab=newJLabel("购买的数量：");
confirm.addActionListener(this);
area1.setFont(newFont("宋体",5,19));
area1.setLineWrap(true);
area1.setEditable(false);

JLabelitem1=newJLabel("序列号商品名称单价数量");
item1.setFont(newFont("微软雅黑",1,17));

area7.setFont(newFont("宋体",0,19));
area7.setEditable(false);

JLabelsum=newJLabel("总价：");
sum.setFont(newFont("黑体",1,20));
sum.setForeground(Color.white);

area2.setFont(newFont("黑体",1,20));
area2.setBackground(newColor(236,239,240));
area2.setEditable(false);
JLabelpay=newJLabel("实收：");
pay.setFont(newFont("黑体",1,20));
pay.setForeground(Color.white);

area3.setFont(newFont("黑体",1,20));
area3.setBackground(newColor(236,239,240));

sure.addActionListener(this);
sure.setFont(newFont("黑体",1,7));
sure.setPreferredSize(newDimension(40,25));

JLabelrepay=newJLabel("应找：");
repay.setFont(newFont("黑体",1,20));
repay.setForeground(Color.white);

area4.setFont(newFont("黑体",1,20));
area4.setBackground(newColor(236,239,240));
area4.setEditable(false);

pane.add(pane1);
pane.add(ProductsIdlab);
pane.add(ProductsId);
pane.add(ProductsOrderCountlab);
pane.add(ProductsOrderCount);
pane.add(confirm);
pane.add(item1);
pane.add(area1);
pane.add(area7);

pane.add(sum);
pane.add(area2);
pane.add(pay);
pane.add(area3);
pane.add(sure);
pane.add(repay);
pane.add(area4);

panel.setContentPane(pane);

Containercp=panel.getContentPane();
panel.setSize(300,540);
panel.setResizable(false);
panel.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
ImageIconimg=newImageIcon("img/13.png");
JLabelimgLabel=newJLabel(img);
panel.getLayeredPane().add(imgLabel,newInteger(Integer.MIN_VALUE));
imgLabel.setBounds(0,0,img.getIconWidth(),img.getIconHeight());
((JPanel)cp).setOpaque(false);
panel.setLocationRelativeTo(null);
panel.setVisible(true);

}

publicvoidJDBC(){

try{
//建立连接
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connection=DriverManager.getConnection("jdbc:sqlserver:"
+"//localhost:1433;DatabaseName=MiniPoss",user,password);
intx=temp;
//创建statement
switch(x){
case001:
stmt=connection.createStatement();
StringsqlQuery001="SELECT*FROMproductwhere序列号='001'";
rs1=stmt.executeQuery(sqlQuery001);
break;

case002:
stmt=connection.createStatement();
StringsqlQuery002="SELECT*FROMproductwhere序列号='002'";
rs1=stmt.executeQuery(sqlQuery002);
break;

case003:
stmt=connection.createStatement();
StringsqlQuery003="SELECT*FROMproductwhere序列号='003'";
rs1=stmt.executeQuery(sqlQuery003);
break;
case004:
stmt=connection.createStatement();
StringsqlQuery004="SELECT*FROMproductwhere序列号='004'";
rs1=stmt.executeQuery(sqlQuery004);
break;
case005:
stmt=connection.createStatement();
StringsqlQuery005="SELECT*FROMproductwhere序列号='005'";
rs1=stmt.executeQuery(sqlQuery005);
break;
case006:
stmt=connection.createStatement();
StringsqlQuery006="SELECT*FROMproductwhere序列号='006'";
rs1=stmt.executeQuery(sqlQuery006);
break;
case007:
stmt=connection.createStatement();
StringsqlQuery007="SELECT*FROMproductwhere序列号='007'";
rs1=stmt.executeQuery(sqlQuery007);
break;
case010:
stmt=connection.createStatement();
StringsqlQuery010="SELECT*FROMproductwhere序列号='008'";
rs1=stmt.executeQuery(sqlQuery010);
break;
case011:
stmt=connection.createStatement();
StringsqlQuery011="SELECT*FROMproductwhere序列号='009'";
rs1=stmt.executeQuery(sqlQuery011);
break;
case012:
stmt=connection.createStatement();
StringsqlQuery012="SELECT*FROMproductwhere序列号='010'";
rs1=stmt.executeQuery(sqlQuery012);
break;

}

ResultSetMetaDatarsmd=rs1.getMetaData();
intj=rsmd.getColumnCount();
System.out.println(rsmd.getColumnName(1)+"/t"
+rsmd.getColumnName(1)+"/t"+rsmd.getColumnName(1)
+"/t");
System.out.println("----------------------------");
while(rs1.next()){

for(inti=0;i<j;i++){

System.out.print(rs1.getString(i+1));
System.out.print("");
area1.append(rs1.getString(i+1));

}
System.out.println("");
}

}catch(ClassNotFoundExceptione){
System.out.println("无法找到驱动类");
System.out.println(e.toString());
}catch(SQLExceptione){
e.printStackTrace();
}finally{
try{
if(rs1!=null)
rs1.close();
if(stmt!=null)
stmt.close();
if(connection!=null)
connection.close();
}catch(Exceptione){
e.printStackTrace();
}
}

}

publicvoidgetAnswer(){

try{
//建立连接
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connection=DriverManager.getConnection("jdbc:sqlserver:"
+"//localhost:1433;DatabaseName=MiniPoss",user,password);

intx1=temp1;
//创建statement
switch(x1){
case001:
stmt1=connection.createStatement();
StringsqlQuery1="SELECT单价FROMproductwhere序列号='001'";
rs2=stmt1.executeQuery(sqlQuery1);
break;

case002:
stmt1=connection.createStatement();
StringsqlQuery2="SELECT单价FROMproductwhere序列号='002'";
rs2=stmt1.executeQuery(sqlQuery2);
break;

case003:
stmt1=connection.createStatement();
StringsqlQuery3="SELECT单价FROMproductwhere序列号='003'";
rs2=stmt1.executeQuery(sqlQuery3);
break;
case004:
stmt1=connection.createStatement();
StringsqlQuery4="SELECT单价FROMproductwhere序列号='004'";
rs2=stmt1.executeQuery(sqlQuery4);
break;
case005:
stmt1=connection.createStatement();
StringsqlQuery5="SELECT单价FROMproductwhere序列号='005'";
rs2=stmt1.executeQuery(sqlQuery5);
break;
case006:
stmt1=connection.createStatement();
StringsqlQuery6="SELECT单价FROMproductwhere序列号='006'";
rs2=stmt1.executeQuery(sqlQuery6);
break;
case007:
stmt1=connection.createStatement();
StringsqlQuery7="SELECT单价FROMproductwhere序列号='007'";
rs2=stmt1.executeQuery(sqlQuery7);
break;
case010:
stmt1=connection.createStatement();
StringsqlQuery8="SELECT单价FROMproductwhere序列号='008'";
rs2=stmt1.executeQuery(sqlQuery8);
break;
case011:
stmt1=connection.createStatement();
StringsqlQuery9="SELECT单价FROMproductwhere序列号='009'";
rs2=stmt1.executeQuery(sqlQuery9);
break;
case012:
stmt1=connection.createStatement();
StringsqlQuery10="SELECT单价FROMproductwhere序列号='010'";
rs2=stmt1.executeQuery(sqlQuery10);
break;
}

ResultSetMetaDatarsmd1=rs2.getMetaData();
intj1=rsmd1.getColumnCount();

while(rs2.next()){

for(inti1=0;i1<j1;i1++){
abc=rs2.getInt(1);
Stringcountnum=ProductsOrderCount.getText();
intcount=Integer.parseInt(countnum);
result=abc*count;
System.out.print(result);
Stringanswer=String.valueOf(result);
area2.append(answer+"元");

}
System.out.print("/n");
}

}catch(ClassNotFoundExceptione){
System.out.println("无法找到驱动类");
System.out.println(e.toString());
}catch(SQLExceptione){
e.printStackTrace();
}finally{
try{
if(rs2!=null)
rs2.close();
if(stmt1!=null)
stmt1.close();
if(connection!=null)
connection.close();
}catch(Exceptione){
e.printStackTrace();
}
}
}

publicstaticvoidmain(String[]args){

Mainpanelpanel=newMainpanel();

}

publicvoidactionPerformed(ActionEvente){
JButtonb=(JButton)e.getSource();
s1=ProductsId.getText();
s2=ProductsOrderCount.getText();
if(b==confirm){
area2.setText("");
area3.setText("");
area4.setText("");
area7.append(""+s2+"/n");
System.out.println(s1);
System.out.println(s2);
if(s1.equals("001")){
temp=001;
JDBC();
temp1=001;
getAnswer();
}
if(s1.equals("002")){
temp=002;
JDBC();
temp1=002;
getAnswer();
}
if(s1.equals("003")){
temp=003;
JDBC();
temp1=003;
getAnswer();
}
if(s1.equals("004")){
temp=004;
JDBC();
temp1=004;
getAnswer();
}
if(s1.equals("005")){
temp=005;
JDBC();
temp1=005;
getAnswer();
}
if(s1.equals("006")){
temp=006;
JDBC();
temp1=006;
getAnswer();
}
if(s1.equals("007")){
temp=007;
JDBC();
temp1=007;
getAnswer();
}
if(s1.equals("008")){
temp=010;
JDBC();
temp1=010;
getAnswer();
}
if(s1.equals("009")){
temp=011;
JDBC();
temp1=011;
getAnswer();
}
if(s1.equals("010")){
temp=012;
JDBC();
temp1=012;
getAnswer();
}

}elseif(b==sure){

Stringreceivprice=area3.getText();
intreceivprice1=Integer.parseInt(receivprice);
receivprice1_show=receivprice1-result;
Stringanswer2=String.valueOf(receivprice1_show);
area4.append(answer2+"元");

}

}

}