java miniposs_。-j;2 (︶︿︶)x-优快云博客

本文链接：https://blog.youkuaiyun.com/yongjian1092/article/details/6523784

本文介绍了一个名为MiniPoss的简易销售点系统实现细节。该系统使用Java Swing构建图形界面，并通过SQL Server数据库进行商品信息的查询及价格计算。系统能够根据输入的商品序列号和购买数量动态显示商品详情和总价。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Code:

Code:
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
public class Mainpanel implements ActionListener {
JTextArea area2 = new JTextArea(1, 8);
JTextArea area1 = new JTextArea(9, 23);
JTextArea area3 = new JTextArea(1, 8);
JTextArea area7 = new JTextArea(9, 5);
JTextArea area4 = new JTextArea(1, 8);
JButton confirm = new JButton("计算");
JTextField ProductsId = new JTextField(16);
JTextField ProductsOrderCount = new JTextField(16);
JButton sure = new JButton("8");
String s1 = new String();
String s2 = new String();
int temp = 0, temp1 = 0;
float result, price, abc, receivprice1_show;
Connection connection = null;
Statement stmt = null, stmt1 = null;
ResultSet rs1 = null, rs2 = null;
String user = "sa";
String password = "0019891128";
public Mainpanel() {
JFrame panel = new JFrame("MiniPoss系统");
ProductsId.setFont(new Font("黑体", 1, 20));
ProductsOrderCount.setFont(new Font("黑体", 1, 20));
JPanel pane1 = new JPanel();
pane1.setLayout(new GridLayout(1, 3));
JButton button1 = new JButton(new ImageIcon("img/button1.png"));
JButton button2 = new JButton(new ImageIcon("img/button2.png"));
JButton button3 = new JButton(new ImageIcon("img/button3.png"));
JButton button4 = new JButton(new ImageIcon("img/button4.png"));
button1.setPreferredSize(new Dimension(72, 72));
button2.setPreferredSize(new Dimension(72, 72));
button3.setPreferredSize(new Dimension(72, 72));
button4.setPreferredSize(new Dimension(72, 72));
pane1.add(button1);
pane1.add(button2);
pane1.add(button3);
pane1.add(button4);
JPanel pane = new JPanel();
pane.setLayout(new FlowLayout());
JLabel ProductsIdlab = new JLabel("商品序列号：");
JLabel ProductsOrderCountlab = new JLabel("购买的数量：");
confirm.addActionListener(this);
area1.setFont(new Font("宋体", 5, 19));
area1.setLineWrap(true);
area1.setEditable(false);
JLabel item1 = new JLabel("序列号商品名称单价数量 ");
item1.setFont(new Font("微软雅黑", 1, 17));
area7.setFont(new Font("宋体", 0, 19));
area7.setEditable(false);
JLabel sum = new JLabel(" 总价：");
sum.setFont(new Font("黑体", 1, 20));
sum.setForeground(Color.white);
area2.setFont(new Font("黑体", 1, 20));
area2.setBackground(new Color(236, 239, 240));
area2.setEditable(false);
JLabel pay = new JLabel(" 实收：");
pay.setFont(new Font("黑体", 1, 20));
pay.setForeground(Color.white);
area3.setFont(new Font("黑体", 1, 20));
area3.setBackground(new Color(236, 239, 240));
sure.addActionListener(this);
sure.setFont(new Font("黑体", 1, 7));
sure.setPreferredSize(new Dimension(40, 25));
JLabel repay = new JLabel(" 应找：");
repay.setFont(new Font("黑体", 1, 20));
repay.setForeground(Color.white);
area4.setFont(new Font("黑体", 1, 20));
area4.setBackground(new Color(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);
Container cp = panel.getContentPane();
panel.setSize(300, 540);
panel.setResizable(false);
panel.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
ImageIcon img = new ImageIcon("img/13.png");
JLabel imgLabel = new JLabel(img);
panel.getLayeredPane().add(imgLabel, new Integer(Integer.MIN_VALUE));
imgLabel.setBounds(0, 0, img.getIconWidth(), img.getIconHeight());
((JPanel) cp).setOpaque(false);
panel.setLocationRelativeTo(null);
panel.setVisible(true);
}
public void JDBC() {
try {
// 建立连接
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connection = DriverManager.getConnection("jdbc:sqlserver:"
+ "//localhost:1433;DatabaseName=MiniPoss", user, password);
int x = temp;
// 创建statement
switch (x) {
case 001:
stmt = connection.createStatement();
String sqlQuery001 = "SELECT * FROM product where 序列号='001'";
rs1 = stmt.executeQuery(sqlQuery001);
break;
case 002:
stmt = connection.createStatement();
String sqlQuery002 = "SELECT * FROM product where 序列号='002'";
rs1 = stmt.executeQuery(sqlQuery002);
break;
case 003:
stmt = connection.createStatement();
String sqlQuery003 = "SELECT * FROM product where 序列号='003'";
rs1 = stmt.executeQuery(sqlQuery003);
break;
case 004:
stmt = connection.createStatement();
String sqlQuery004 = "SELECT * FROM product where 序列号='004'";
rs1 = stmt.executeQuery(sqlQuery004);
break;
case 005:
stmt = connection.createStatement();
String sqlQuery005 = "SELECT * FROM product where 序列号='005'";
rs1 = stmt.executeQuery(sqlQuery005);
break;
case 006:
stmt = connection.createStatement();
String sqlQuery006 = "SELECT * FROM product where 序列号='006'";
rs1 = stmt.executeQuery(sqlQuery006);
break;
case 007:
stmt = connection.createStatement();
String sqlQuery007 = "SELECT * FROM product where 序列号='007'";
rs1 = stmt.executeQuery(sqlQuery007);
break;
case 010:
stmt = connection.createStatement();
String sqlQuery010 = "SELECT * FROM product where 序列号='008'";
rs1 = stmt.executeQuery(sqlQuery010);
break;
case 011:
stmt = connection.createStatement();
String sqlQuery011 = "SELECT * FROM product where 序列号='009'";
rs1 = stmt.executeQuery(sqlQuery011);
break;
case 012:
stmt = connection.createStatement();
String sqlQuery012 = "SELECT * FROM product where 序列号='010'";
rs1 = stmt.executeQuery(sqlQuery012);
break;
}
ResultSetMetaData rsmd = rs1.getMetaData();
int j = rsmd.getColumnCount();
System.out.println(rsmd.getColumnName(1) + "/t"
+ rsmd.getColumnName(1) + "/t" + rsmd.getColumnName(1)
+ "/t");
System.out.println("----------------------------");
while (rs1.next()) {
for (int i = 0; i < j; i++) {
System.out.print(rs1.getString(i + 1));
System.out.print(" ");
area1.append(rs1.getString(i + 1));
}
System.out.println("");
}
} catch (ClassNotFoundException e) {
System.out.println("无法找到驱动类");
System.out.println(e.toString());
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (rs1 != null)
rs1.close();
if (stmt != null)
stmt.close();
if (connection != null)
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
public void getAnswer() {
try {
// 建立连接
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connection = DriverManager.getConnection("jdbc:sqlserver:"
+ "//localhost:1433;DatabaseName=MiniPoss", user, password);
int x1 = temp1;
// 创建statement
switch (x1) {
case 001:
stmt1 = connection.createStatement();
String sqlQuery1 = "SELECT 单价 FROM product where 序列号='001'";
rs2 = stmt1.executeQuery(sqlQuery1);
break;
case 002:
stmt1 = connection.createStatement();
String sqlQuery2 = "SELECT 单价 FROM product where 序列号='002'";
rs2 = stmt1.executeQuery(sqlQuery2);
break;
case 003:
stmt1 = connection.createStatement();
String sqlQuery3 = "SELECT 单价 FROM product where 序列号='003'";
rs2 = stmt1.executeQuery(sqlQuery3);
break;
case 004:
stmt1 = connection.createStatement();
String sqlQuery4 = "SELECT 单价 FROM product where 序列号='004'";
rs2 = stmt1.executeQuery(sqlQuery4);
break;
case 005:
stmt1 = connection.createStatement();
String sqlQuery5 = "SELECT 单价 FROM product where 序列号='005'";
rs2 = stmt1.executeQuery(sqlQuery5);
break;
case 006:
stmt1 = connection.createStatement();
String sqlQuery6 = "SELECT 单价 FROM product where 序列号='006'";
rs2 = stmt1.executeQuery(sqlQuery6);
break;
case 007:
stmt1 = connection.createStatement();
String sqlQuery7 = "SELECT 单价 FROM product where 序列号='007'";
rs2 = stmt1.executeQuery(sqlQuery7);
break;
case 010:
stmt1 = connection.createStatement();
String sqlQuery8 = "SELECT 单价 FROM product where 序列号='008'";
rs2 = stmt1.executeQuery(sqlQuery8);
break;
case 011:
stmt1 = connection.createStatement();
String sqlQuery9 = "SELECT 单价 FROM product where 序列号='009'";
rs2 = stmt1.executeQuery(sqlQuery9);
break;
case 012:
stmt1 = connection.createStatement();
String sqlQuery10 = "SELECT 单价 FROM product where 序列号='010'";
rs2 = stmt1.executeQuery(sqlQuery10);
break;
}
ResultSetMetaData rsmd1 = rs2.getMetaData();
int j1 = rsmd1.getColumnCount();
while (rs2.next()) {
for (int i1 = 0; i1 < j1; i1++) {
abc = rs2.getInt(1);
String countnum = ProductsOrderCount.getText();
int count = Integer.parseInt(countnum);
result = abc * count;
System.out.print(result);
String answer = String.valueOf(result);
area2.append(answer + "元");
}
System.out.print("/n");
}
} catch (ClassNotFoundException e) {
System.out.println("无法找到驱动类");
System.out.println(e.toString());
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (rs2 != null)
rs2.close();
if (stmt1 != null)
stmt1.close();
if (connection != null)
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
public static void main(String[] args) {
Mainpanel panel = new Mainpanel();
}
public void actionPerformed(ActionEvent e) {
JButton b = (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();
}
} else if (b == sure) {
String receivprice = area3.getText();
int receivprice1 = Integer.parseInt(receivprice);
receivprice1_show = receivprice1 - result;
String answer2 = String.valueOf(receivprice1_show);
area4.append(answer2 + "元");
}
}
}