Java小项目另一个水果摊

发布于2021-06-07 22:24 阅读(929) 评论(0) 点赞(19) 收藏(5)

文章目录

前言
一、包和表截图
二、源代码
总结
- 拒绝白嫖，给个三连鼓励一下吧！

前言

前一段时间利用Java基础知识集合和IO流做了个简单的小项目-水果摊，感觉不过瘾，最近又想着用GUI和Mysql数据库重做一下，名为另一个水果摊，下面就来分享一下代码吧

一、包和表截图

在这里插入图片描述

二、源代码

1.JDBC连接Mysql数据

管理员界面：增删查改

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;

	}

}

用户界面：查找水果

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;
	}
}

建立断开连接

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窗口界面

开始选择界面

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();
			
		}
		
	}
}

在这里插入图片描述

用户购买水果界面

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("水果摊");
	}
}

在这里插入图片描述

管理员登录界面

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);
		}
	}
}

在这里插入图片描述

管理员界面

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("管理员页面");
	}

}

在这里插入图片描述

3.水果属性

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方法

package com.vector.domain;

import com.vector.view.selInterface;

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

}