Another fruit stand in the Java project

Article Directory


Preface

Some time ago, I made a simple small project-fruit stall using Java basic knowledge collection and IO stream. It feels not addictive. Recently, I thought about redo it with GUI and Mysql database, called another fruit stall, let’s share it below. Code it


1. Screenshots of packages and tables

Insert picture description here


Insert picture description here


Insert picture description here

Second, the source code

1. JDBC connect to Mysql data

Administrator interface: add, delete, check and modify

package com.vector.service;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import com.vector.dao.Fruit;
import com.vector.units.ConnectMsql;

public class FruitDao {

	public static String add(Fruit fruit) {
		String s = null;
		try {
			// Connection connection = ConnectMsql.getConnectMsql();
			String sql = "insert into fruit(name,price,number) values(?,?,0)";
			Connection connection = ConnectMsql.getConnectMsql();

			PreparedStatement ad = connection.prepareStatement(sql);

			Statement stmt = connection.createStatement();
			ResultSet rs = stmt.executeQuery("select * from fruit");
			int f = 0;
			while (rs.next()) {
				if (fruit.getName().equals(rs.getString("name"))) {
					f = 1;
				}
				/*
				 * System.out.println(rs.getInt("id") + " " + rs.getString("name") + " " +
				 * rs.getDouble("price") + " " + rs.getInt("number"));
				 */
			}

			if (f == 0) {
				ad.setString(1, fruit.getName());
				ad.setDouble(2, fruit.getPrice());
				int i = ad.executeUpdate();
				if (i > 0) {
					// System.out.println("添加成功!");
					s = "添加成功!";
				} else {
					// System.out.println("水果重复,添加失败!");
					s = "水果重复,添加失败!";
				}
			} else {
				s = "水果重复,添加失败!";
			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			// e.printStackTrace();
		}
		return s;

	}

	public static String delete(String name) {
		String sql = "delete from fruit where name = ?";
		String s1 = null;
		Connection connection = ConnectMsql.getConnectMsql();
		PreparedStatement dele = null;
		try {
			dele = connection.prepareStatement(sql);
			dele.setString(1, name);
			int i = dele.executeUpdate();
			if (i > 0) {
				s1 = "删除成功!";
			} else {
				s1 = "删除失败!未找到该水果!";
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return s1;
	}

	public static String change(String name, double price) {
		String sql = "update fruit set price= ? where name= ?";
		String s2 = null;
		try {
			Connection connection = ConnectMsql.getConnectMsql();
			PreparedStatement upda = connection.prepareStatement(sql);
			upda.setDouble(1, price);
			// upda.setInt(2, 2);
			upda.setString(2, name);
			// System.out.println(name);
			int i = upda.executeUpdate();
			if (i > 0) {
				s2 = " 修改成功!";
			} else {
				s2 = "修改失败,水果不存在!";
			}
		} catch (SQLException e) {

			e.printStackTrace();
		}
		return s2;

	}

	public static ResultSet list() {
		ResultSet rs = null;

		Connection connection = ConnectMsql.getConnectMsql();
		Statement stmt;
		try {
			stmt = connection.createStatement();
			rs = stmt.executeQuery("select * from fruit");

			/*
			 * while (rs.next()) { s="序号:"+rs.getInt("id") + " 水果名称:" + rs.getString("name")
			 * + " 水果价格:" + rs.getDouble("price") + " ";
			 * System.out.println("序号:"+rs.getInt("id") + " 水果名称:" + rs.getString("name") +
			 * " 水果价格:" + rs.getDouble("price") + " " );
			 * 
			 * }
			 */

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return rs;

	}

}

User interface: Find fruits

package com.vector.service;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.vector.dao.Fruit;
import com.vector.units.ConnectMsql;

public class UFruitDao {

	public static List<Fruit> list = new ArrayList<>();
	static Fruit f = null;

	public static List Uadd(String name, int number) {
		ResultSet rs = null;
		Connection connection = ConnectMsql.getConnectMsql();
		try {

			Statement stmt = connection.createStatement();
			rs = stmt.executeQuery("select * from fruit");
			int k = 0;
			while (rs.next()) {
				if (rs.getString("name").equals(name)) {
					f = new Fruit(rs.getString("name"), rs.getDouble("price"), number);
					k = 1;
				}

				/*
				 * System.out.println("序号:" + rs.getInt("id") + " 水果名称:" + rs.getString("name")
				 * + " 水果价格:" + rs.getDouble("price") + " ");
				 */
			}
			if (k == 0) {
				System.out.println("水果不纯在,添加失败!");
			}
			k = 0;
			for (Fruit s : list) {
				if (s.getName().equals(name)) {
					s.setNumber(s.getNumber() + number);
					k = 1;
				}

			}
			if (k == 0)
				list.add(f);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

		return list;
	}
}

Establish disconnection

package com.vector.units;

import java.sql.*;

public class ConnectMsql {
	public static Connection connect;

	public static Connection getConnectMsql() {
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
			// Class.forName("org.gjt.mm.mysql.Driver");
			// System.out.println("成功加载Mysql驱动程序!");
		} catch (Exception e) {
			System.out.print("加载Mysql驱动程序时出错!");
			e.printStackTrace();
		}
		try {
			connect = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/fru?&useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true",
					"root", "zpx");

			// System.out.println("成功连接Mysql服务器!");
			Statement stmt = connect.createStatement();
		} catch (Exception e) {
			System.out.print("获取连接错误!");
			e.printStackTrace();
		}
		return connect;
	}

	public static void closeConnection() {
		if (connect != null) {
			try {
				connect.close();
				// sSystem.out.println("数据库连接关闭");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

}

2. GUI window interface

Start selection interface

package com.vector.view;
import java.awt.BorderLayout;
import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;

import com.vector.test.logon;
import com.vector.view.userInterface;

import javax.swing.JMenuBar;
import javax.swing.JMenu;
import javax.swing.JMenuItem;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.ImageIcon;
import javax.swing.JTextArea;
import java.awt.Color;
import java.awt.CardLayout;
import javax.swing.JLabel;
import javax.swing.SwingConstants;
import java.awt.SystemColor;

public class selInterface extends JFrame {

	private JPanel contentPane;

	/**
	 * Launch the application.
	 */
	public static void star() {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					selInterface frame = new selInterface();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public selInterface() {
		setIconImage(Toolkit.getDefaultToolkit().getImage("D:\\eclip\\FruitV\\src\\tubiao.png")); //左上角图标
		setTitle("\u6C34\u679C\u644A");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 600, 600);
		
		JMenuBar menuBar = new JMenuBar();
		menuBar.setToolTipText("");
		setJMenuBar(menuBar);
		
		JMenu menu = new JMenu("\u9875\u9762\u9009\u62E9");
		menuBar.add(menu);
		
		Monitor2 monitor = new Monitor2();
		JMenu menu_1 = new JMenu("\u7BA1\u7406\u5458\u754C\u9762");
		menu_1.setIcon(new ImageIcon("D:\\eclip\\FruitV\\src\\556.png"));   //管理员图标
		menu.add(menu_1);
		
		
		JMenuItem menuItem = new JMenuItem("\u767B\u5F55");
		menu_1.add(menuItem);
		menuItem.addActionListener(monitor);
		
		
		
		JMenuItem menuItem_2 = new JMenuItem("\u987E\u5BA2\u754C\u9762");
		menuItem_2.setIcon(new ImageIcon("D:\\eclip\\FruitV\\src\\557.png"));    //登录图标
		menu.add(menuItem_2);
		menuItem_2.addActionListener(monitor);
		contentPane = new JPanel();
		contentPane.setBackground(Color.WHITE);
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);
		
		JLabel lblNewLabel_1 = new JLabel("");
		lblNewLabel_1.setBounds(0, 71, 584, 465);
		lblNewLabel_1.setIcon(new ImageIcon("D:\\eclip\\FruitV\\src\\122.png"));     //顾客图标
		contentPane.add(lblNewLabel_1);
		
		JLabel label = new JLabel("\u6B22\u8FCE\u6765\u5230\u6C34\u679C\u644A");
		label.setBounds(245, 0, 99, 71);
		contentPane.add(label);
		
		JLabel lblNewLabel = new JLabel("");
		lblNewLabel.setIcon(new ImageIcon("D:\\eclip\\FruitV\\src\\lan.png"));      //窗口上方蓝色方块
		lblNewLabel.setBackground(Color.GREEN);
		lblNewLabel.setBounds(0, 0, 584, 71);
		contentPane.add(lblNewLabel);
		
		
		ImageIcon ig = new ImageIcon("D:\\eclip\\FruitV\\src\\tubiao.png");   //左上角图标
		
		
		ImageIcon img = new ImageIcon("D:\\eclip\\FruitV\\src\\QQ图片20210420205633.png");     //窗口背景图
		JLabel imgLabel = new JLabel(img);
		this.getLayeredPane().add(imgLabel, new Integer(Integer.MIN_VALUE));
		imgLabel.setBounds(0, 0, img.getIconWidth(), img.getIconHeight());
	}
}
class Monitor2 implements ActionListener {
	public void actionPerformed(ActionEvent e) {
		//System.out.println("有响应");
		String buttonName = e.getActionCommand();
		if(buttonName.equals("登录")) {
			logon.star();
		}
		
		if(buttonName.equals("顾客界面")) {
			System.out.println("顾客界面");
			userInterface.start();
			
		}
		
	}
}

Insert picture description here

User purchase fruit interface

package com.vector.view;

import java.awt.Image;
import java.awt.List;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.ArrayList;
import java.util.jar.JarFile;
import javax.swing.*;
import com.vector.dao.Fruit;
import com.vector.service.UFruitDao;

public class userInterface extends JFrame {
	public static ArrayList <Fruit> list;
	static double x;
    JPanel contentPane;
	Image im;
	Box boxH, boxH1; 
	Box boxVOne, boxVTwo; 
	Box button, show;
	Box show1, show2;
	public static JTextArea a1,a2; 
    
	public userInterface() {
		setLayout(new java.awt.FlowLayout());
		setResizable(false);
		contentPane = new JPanel();
		setContentPane(contentPane);
		contentPane.setOpaque(false);
		setVisible(true);
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		init();
	}

	void init() {
		ImageIcon ig = new ImageIcon("D:\\eclip\\FruitV\\src\\tubiao.png");
		im = ig.getImage();
		setIconImage(im);
		ImageIcon img = new ImageIcon("D:\\eclip\\FruitV\\src\\beijing.png");
		JLabel imgLabel = new JLabel(img);
		this.getLayeredPane().add(imgLabel, new Integer(Integer.MIN_VALUE));
		imgLabel.setBounds(0, 0, img.getIconWidth(), img.getIconHeight());
		
		boxH = Box.createHorizontalBox();
		boxVOne = Box.createVerticalBox();
		boxVTwo = Box.createVerticalBox();
		button = Box.createHorizontalBox();
		show = Box.createVerticalBox();
		show1 = Box.createVerticalBox();
		show2 = Box.createVerticalBox();
		boxH1 = Box.createHorizontalBox();
		
		JTextField t1 = new JTextField(10);
		JTextField t2 = new JTextField(10);
		JTextField t3 = new JTextField(10);
		
		 a1 = new JTextArea(9, 30);
		 a2 = new JTextArea(4, 30);
		JScrollPane s1=new JScrollPane(a1);
		JScrollPane s2=new JScrollPane(a2);
		
		JButton b1 = new JButton("确定添加");
		JButton b2 = new JButton("确定购买");
		JButton b3 = new JButton("确定付款");
		
		boxVOne.add(new JLabel("水果名称:"));
		boxVOne.add(new JLabel("水果数量(斤):"));
		boxVTwo.add(t1);
		boxVTwo.add(t2);
		button.add(b1);
		show.add(s1);
		show.add(Box.createVerticalStrut(20));
		show.add(Box.createHorizontalStrut(110));
		show.add(b2);
		show.add(Box.createVerticalStrut(20));
		boxH.add(boxVOne);
		boxH.add(Box.createHorizontalStrut(10));
		boxH.add(boxVTwo);
		boxH.add(button);
		add(boxH);
		add(show);
		boxH1.add(new JLabel("请付款:"));
		boxH1.add(Box.createHorizontalStrut(10));
		boxH1.add(t3);
		boxH1.add(b3);
		show2.add(boxH1);
		show2.add(Box.createVerticalStrut(10));
		show2.add(s2);
		add(show1);
		add(show2);
		Monitor1 monitor =new Monitor1();
		b1.addActionListener(monitor);
		b2.addActionListener(monitor);
		b3.addActionListener(monitor);
		monitor.setText1(t1);
		monitor.setText2(t2);
		monitor.setText3(t3);
	}
	public class Monitor1 implements ActionListener {
 
		JTextField text1,text2,text3;

		public void setText1(JTextField text1) {
			this.text1 = text1;
		}

		public void setText2(JTextField text2) {
			this.text2 = text2;
		}

		public void setText3(JTextField text3) {
			this.text3 = text3;
		}

		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			String buttonName = e.getActionCommand();
			try {
			if(buttonName.equals("确定添加")) {
				
				String name=text1.getText();
				String number0 = (String) text2.getText();
				int number = Integer.valueOf(number0.toString());
				
			    list =new ArrayList<>();
				list = (ArrayList<Fruit>) UFruitDao.Uadd(name, number);
				a1.setText("");
				for (Fruit s : list) {
					//System.out.println(s.toString());
					a1.append(s.toString()+"\n");
				}
				System.out.println("添加成功!");
				
			}
			if(buttonName.equals("确定购买")) {
				
				x=0;
				for (Fruit s : list) {
					x+=s.getNumber()*s.getPrice();
			}
				a1.append("请付款:"+x+"元。"+"\n");
			}
			if(buttonName.equals("确定付款")) {
				String money0 = (String) text3.getText();
				double money = Double.valueOf(money0.toString());
				double s=money-x;
				a2.setText("");
				if(s>0) {
					//System.out.println("付款成功,找你"+s+"元。");
					a2.append("付款成功,找你"+s+"元,慢走不送!");
				}
				if(s==0) {
					//System.out.println("付款成功,刚好够");
					a2.append("付款成功,刚好够,慢走不送!");
				}
				if(s<0) {
					//System.out.println("付款失败,钱不够");
					a2.append("付款失败,钱不够。");
				}	
			}
		}catch(Exception e2) {
			System.out.println("添加失败,请按要求输入!");
		}
		}
		
	}

	public static void start() {
		userInterface win = new userInterface();
		win.setBounds(100, 100, 600, 600);
		win.setTitle("水果摊");
	}
}


Insert picture description here

Administrator login interface

package com.vector.test;

import java.awt.BorderLayout;
import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;

import com.vector.view.admInterface;

import javax.swing.JLabel;
import java.awt.Color;
import javax.swing.JTextField;
import javax.swing.JPasswordField;
import javax.swing.JButton;
import javax.swing.ImageIcon;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class logon extends JFrame {

	
	private JPanel contentPane;
	private JTextField textField;
	private JPasswordField passwordField;

	/**
	 * Launch the application.
	 */
	public static void star() {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					logon frame = new logon();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public logon() {
		setIconImage(Toolkit.getDefaultToolkit().getImage("D:\\eclip\\FruitV\\src\\556.png"));
		setTitle("\u7BA1\u7406\u5458\u767B\u5F55\u7CFB\u7EDF");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 600, 600);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		setContentPane(contentPane);
		contentPane.setLayout(null);
		
		JLabel label = new JLabel("\u7BA1\u7406\u5458\u767B\u5F55\u7CFB\u7EDF");
		label.setForeground(new Color(139, 0, 139));
		label.setBounds(239, 38, 112, 15);
		contentPane.add(label);
		
		JLabel label_1 = new JLabel("\u7528\u6237\u540D\uFF1A");
		label_1.setBounds(120, 98, 54, 15);
		contentPane.add(label_1);
		
		textField = new JTextField();
		textField.setText("1+1=\uFF1F");
		textField.setBounds(179, 95, 214, 21);
		contentPane.add(textField);
		textField.setColumns(10);
		
		JLabel label_2 = new JLabel("\u5BC6\u7801\uFF1A");
		label_2.setBounds(120, 162, 54, 15);
		contentPane.add(label_2);
		
		Monitor3 monitor =new Monitor3();
		passwordField = new JPasswordField();
		passwordField.setBounds(179, 159, 214, 18);
		contentPane.add(passwordField);
		monitor.setP1(passwordField);
		
		JButton button = new JButton("\u767B\u5F55");
		button.setBounds(193, 228, 93, 23);
		contentPane.add(button);
		button.addActionListener(monitor);
		
		JButton button_1 = new JButton("\u9000\u51FA");
		button_1.setBounds(296, 228, 93, 23);
		contentPane.add(button_1);
		button_1.addActionListener(monitor);
		
		JLabel label_4 = new JLabel("\u731C\u731C\u5BC6\u7801\u662F\u4EC0\u4E48......");
		label_4.setForeground(new Color(139, 0, 0));
		label_4.setBounds(231, 341, 176, 15);
		contentPane.add(label_4);
		
		JLabel lblNewLabel = new JLabel("");
		lblNewLabel.setIcon(new ImageIcon("D:\\eclip\\FruitV\\src\\dongtai.gif"));
		lblNewLabel.setBounds(231, 379, 123, 99);
		contentPane.add(lblNewLabel);
		
		JLabel lblNewLabel_1 = new JLabel("");
		lblNewLabel_1.setBounds(401, 162, 106, 15);
		contentPane.add(lblNewLabel_1);
	}
}
class Monitor3 implements ActionListener {
	JPasswordField p1;
	public void setP1(JPasswordField p1) {
		this.p1 = p1;
	}
	public void actionPerformed(ActionEvent e) {
		String s=p1.getText();
		String buttname=e.getActionCommand();
		if(buttname.equals("登录")) {
			if(s.equals("2")) {
				admInterface.start();
			}else {
				
				System.out.println("密码错误!");
			}
		}
		if(buttname.equals("退出")) {
			System.exit(0);
		}
	}
}
Insert picture description here

Administrator interface

package com.vector.view;

import java.awt.Component;
import java.awt.FlowLayout;
import java.awt.Image;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.swing.Box;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTextArea;
import javax.swing.JTextField;

import com.vector.dao.Fruit;
import com.vector.service.FruitDao;
import com.vector.units.ConnectMsql;

public class admInterface extends JFrame {
	public static JTextArea a1;
	public static JTextArea a2;
	Image im;
	public static Fruit fruit;

	public admInterface() {
		setLayout(new FlowLayout());
		setVisible(true);
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
		ImageIcon ig = new ImageIcon("D:\\eclip\\FruitV\\src\\tubiao.png");
		im = ig.getImage();
		setIconImage(im);
		// Component H= Box.createHorizontalStrut(10);
		// Component V= Box.createVerticalStrut(10);

		Box boxH1 = Box.createHorizontalBox();
		Box boxH2 = Box.createHorizontalBox();
		Box boxH3 = Box.createHorizontalBox();
		Box boxH4 = Box.createHorizontalBox();
		Box boxH5 = Box.createHorizontalBox();

		Box boxV = Box.createVerticalBox();

		JTextField t1 = new JTextField(10);
		JTextField t2 = new JTextField(10);
		JTextField t3 = new JTextField(10);
		JTextField t4 = new JTextField(10);
		JTextField t5 = new JTextField(10);

		JButton B1 = new JButton("确定添加");
		JButton B2 = new JButton("确定删除");
		JButton B3 = new JButton("确定修改");
		JButton B4 = new JButton("刷新");

		a1 = new JTextArea(8, 20);
		a2 = new JTextArea(11, 20);
		JScrollPane scroll1 = new JScrollPane(a1);
		JScrollPane scroll2 = new JScrollPane(a2);

		boxH1.add(new JLabel("水果名称:"));
		boxH1.add(t1);
		boxH1.add(Box.createHorizontalStrut(10));
		boxH1.add(new JLabel("水果价格(/斤):"));
		boxH1.add(t2);
		boxH1.add(Box.createHorizontalStrut(10));
		boxH1.add(B1);

		boxH2.add(new JLabel("水果名称:"));
		boxH2.add(Box.createHorizontalStrut(10));
		boxH2.add(t3);
		boxH2.add(Box.createHorizontalStrut(10));
		boxH2.add(B2);

		boxH3.add(new JLabel("水果名称:"));
		boxH3.add(Box.createHorizontalStrut(10));
		boxH3.add(t4);
		boxH3.add(Box.createHorizontalStrut(10));
		boxH3.add(new JLabel("水果新价格(/斤):"));
		boxH3.add(Box.createHorizontalStrut(10));
		boxH3.add(t5);
		boxH3.add(B3);

		boxH4.add(new JLabel("操作结果:"));
		boxH4.add(Box.createHorizontalStrut(10));
		boxH4.add(scroll1);

		boxH5.add(new JLabel("水果列表:"));
		boxH5.add(Box.createHorizontalStrut(10));
		boxH5.add(scroll2);

		boxV.add(Box.createVerticalStrut(10));
		boxV.add(new JLabel("增加水果"));
		boxV.add(Box.createVerticalStrut(10));
		boxV.add(boxH1);
		boxV.add(Box.createVerticalStrut(20));
		boxV.add(new JLabel("删除水果"));
		boxV.add(Box.createVerticalStrut(10));
		boxV.add(boxH2);
		boxV.add(Box.createVerticalStrut(20));
		boxV.add(new JLabel("更改水果价格"));
		boxV.add(Box.createVerticalStrut(10));
		boxV.add(boxH3);
		boxV.add(Box.createVerticalStrut(20));
		boxV.add(boxH4);
		boxV.add(Box.createVerticalStrut(20));
		boxV.add(boxH5);
		boxV.add(Box.createVerticalStrut(10));
		boxV.add(B4);

		add(boxV);
		Monitor monitor = new Monitor();
		B1.addActionListener(monitor);
		B2.addActionListener(monitor);
		B3.addActionListener(monitor);
		B4.addActionListener(monitor);
		monitor.settext1(t1);
		monitor.settext2(t2);
		monitor.settext3(t3);
		monitor.settext4(t4);
		monitor.settext5(t5);
	}

	public class Monitor implements ActionListener {

		JTextField text1, text2, text3, text4, text5;

		public void settext1(JTextField str) {
			text1 = str;
		}

		public void settext2(JTextField str) {
			text2 = str;
		}

		public void settext3(JTextField str) {
			text3 = str;
		}

		public void settext4(JTextField str) {
			text4 = str;
		}

		public void settext5(JTextField str) {
			text5 = str;
		}

		
		public void actionPerformed(ActionEvent e) {
			String buttonName = e.getActionCommand();

			try {
				if (buttonName.equals("确定添加")) {

					String name = text1.getText();
					String price0 = (String) text2.getText();
					double price = Double.valueOf(price0.toString());
					// System.out.println(name + price);
					fruit = new Fruit(name, price, 0);
					String s = FruitDao.add(fruit);
					a1.append(s + "\n");
					ConnectMsql.closeConnection();

				}

				if (buttonName.equals("确定删除")) {

					String name = text3.getText();

					String s = null;
					try {
						s = FruitDao.delete(name);
					} catch (Exception e1) {
						// TODO Auto-generated catch block
						// e1.printStackTrace();
						System.out.println("添加失败,请输入正确的格式!");
					}
					a1.append(s + "\n");
					ConnectMsql.closeConnection();
				}

				if (buttonName.equals("确定修改")) {
					String name = text4.getText();
					// System.out.println(name);
					String price0 = (String) text5.getText();
					String s = null;
					double price = Double.valueOf(price0.toString());
					try {
						s = FruitDao.change(name, price);
					} catch (Exception e2) {
						e2.printStackTrace();
					}
					a1.append(s + "\n");
					ConnectMsql.closeConnection();
				}

				if (buttonName.equals("刷新")) {
					ResultSet rs = FruitDao.list();
					try {
						a2.setText("");
						while (rs.next()) {

							a2.append("序号:" + rs.getInt("id") + ",   水果名称:" + rs.getString("name") + ",   水果价格:"
									+ rs.getDouble("price") + " \n");
						}

					} catch (SQLException e1) {
						// TODO Auto-generated catch block
						System.out.println("添加失败,请输入正确的格式!");
						// e1.printStackTrace();
					}
					ConnectMsql.closeConnection();
				}

			} catch (Exception e1) {
				System.out.println("添加失败,请依照正确格式输入!");
				a1.append("添加失败,请依照正确格式输入!");
			}
		}

	}
	public static void start() {
		admInterface win = new admInterface();
		win.setBounds(100, 100, 600, 700);
		win.setTitle("管理员页面");
	}

}

Insert picture description here

3. Fruit attributes

package com.vector.dao;

public class Fruit {
	private String name;
	private double price;
	private int number;

	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public double getPrice() {
		return price;
	}
	public void setPrice(double price) {
		this.price = price;
	}
	public int getNumber() {
		return number;
	}
	public void setNumber(int number) {
		this.number = number;
	}
	public Fruit( String name, double price, int number) {

		
		this.name = name;
		this.price = price;
		this.number = number;
	}
	
	public String toString() {
		return "水果名称:"+name+",水果价格:"+price+",购买水果数量:"+number;
	}
	

}

4.main method

package com.vector.domain;

import com.vector.view.selInterface;

public class mainV {
	public static void main(String[] args) {
		selInterface.star();
	}

}

to sum up

Refuse white prostitution, give Sanlian encouragement!

Insert picture description here