- 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+"元");
- }
- }
- }