JAVA程序设计(Swing编程).docx

JAVA程序设计JAVA程序设计学生：占 豪学号：1305110130武汉轻工大学数学与计算机学院计算机类1303班_JAVA程序设计课程设计一、SWING编程一、Swing介绍Swing是一个用于开发Java应用程序用户界面的开发工具包。 以抽象窗口工具包（AWT）为基础使跨平台应用程序可以使用任何可插拔的外观风格。使用Swing开发图形界面比AWT更加优秀，因为Swing是一种轻量级组件，它采用100%的Java实现，不再依赖与本地的图形界面，所以可以在所有平台保持相同的运行效果，对跨平台支持比较出色。并且，Swing提供了比AWT更多的图形组件，因此可以开发出更美观的图形界面。二、实验目的使用Java做图形界面啦，了解图形用户界面基本组件的使用，布局管理器如何对组件进行管理以及事件处理机制的应用。三、实验内容1、实验任务使用Swing设计一个商品管理系统，实现对商店商品数据库的增、查、改、删的用户图形操作界面。商品Goods的四个属性为：（int）GoodsID、（String）GoodsName、（double）GoodsPrice、（String）GoodsDesc，分别表示商品的ID，名称，价格，描述。2、设计过程3、运行结果商品管理界面：添加商品界面修改商品界面功能：添加商品、查找商品、修改商品、删除商品添加商品： 查找商品：修改商品删除商品 四、附录程序代码Goods:public class Goods/ TODO 自定义 Goods 类(商品)private int GoodsID;private String GoodsName;private double GoodsPrice;private String GoodsDesc;public Goods(int goodsID, String goodsName, double goodsPrice, String goodsDesc)/ TODO 自定义 Goods 构造方法GoodsID = goodsID;GoodsName = goodsName;GoodsPrice = goodsPrice;GoodsDesc = goodsDesc;public int getGoodsID()return GoodsID;public void setGoodsID(int goodsID)GoodsID = goodsID;public String getGoodsName()return GoodsName;public void setGoodsName(String goodsName)GoodsName = goodsName;public double getGoodsPrice()return GoodsPrice;public void setGoodsPrice(double goodsPrice)GoodsPrice = goodsPrice;public String getGoodsDesc()return GoodsDesc;public void setGoodsDesc(String goodsDesc)GoodsDesc = goodsDesc;Overridepublic String toString() return Goods GoodsID= + GoodsID + , GoodsName= + GoodsName+ , GoodsPrice= + GoodsPrice + , GoodsDesc= + GoodsDesc+ ;GoodsDao:import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import Model.Goods;import Utils.ConnectDB;public class GoodsDaoConnectDB conn = new ConnectDB();public void Add(Goods goods) throws SQLExceptionString sql = INSERT INTO goods VALUES (+ goods.getGoodsID() + ,+ goods.getGoodsName() + ,+ goods.getGoodsPrice() + ,+ goods.getGoodsDesc() +);conn.insert(sql);public ArrayList GetAll() throws SQLExceptionResultSet res = null;tryString sql = SELECT * FROM goods;res = conn.select(sql);ArrayList allgoods = new ArrayList();while(res.next()Goods goods = new Goods(res.getInt(GoodsID), res.getString(GoodsName),res.getDouble(GoodsPrice), res.getString(GoodsDesc);allgoods.add(goods);return allgoods;finallyif (res != null)res.close();public ArrayList Search(String name) throws SQLExceptionResultSet res = null;tryString sql = SELECT * FROM goods WHERE GoodsName = + name + ;res = conn.select(sql);ArrayList somegoods = new ArrayList();while(res.next()Goods goods = new Goods(res.getInt(GoodsID), res.getString(GoodsName),res.getDouble(GoodsPrice), res.getString(GoodsDesc);somegoods.add(goods);return somegoods;finallyif (res != null)res.close();public void Modify(int id, Goods goods) throws SQLExceptionString sql = UPDATE goods SET + GoodsID = + goods.getGoodsID() + ,+ GoodsName = + goods.getGoodsName() + ,+ GoodsPrice = + goods.getGoodsPrice() + ,+ GoodsDesc = + goods.getGoodsDesc() + + WHERE GoodsID = + id +;conn.update(sql);public void Remove(Goods goods) throws SQLExceptionString sql = DELETE FROM goods WHERE GoodsID = + goods.getGoodsID() + ;conn.delete(sql);ConnectDB:import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class ConnectDBprivate Connection conn;private Statement stmt;public Connection getConn()String driver = com.mysql.jdbc.Driver;String url = jdbc:mysql:/:3306/store;String user = Housz;String pass = 123456;tryClass.forName(driver);return DriverManager.getConnection(url, user, pass);catch (Exception e)System.out.println(-MySQL 连接失败 -);e.printStackTrace();return null;public ResultSet select(String sql) throws SQLException/ TODO 在数据库中查询数据conn = getConn();stmt = conn.createStatement();ResultSet rs = stmt.executeQuery(sql);return rs;public void insert(String sql) throws SQLException/ TODO 在数据库中插入数据tryconn = getConn();stmt = conn.createStatement();stmt.executeUpdate(sql);finallyif (stmt != null)stmt.close();if (conn != null)conn.close();public void update(String sql) throws SQLException/ TODO 在数据库中修改数据tryconn = getConn();stmt = conn.createStatement();stmt.executeUpdate(sql);finallyif (stmt != null)stmt.close();if (conn != null)conn.close();public void delete(String sql) throws SQLException/ TODO 在数据库中删除数据tryconn = getConn();stmt = conn.createStatement();stmt.executeUpdate(sql);finallyif (stmt != null)stmt.close();if (conn != null)conn.close();ManageGUI:import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import java.util.ArrayList;import javax.swing.JButton;import javax.swing.JFrame;import javax.swing.JPanel;import javax.swing.JScrollPane;import javax.swing.JTable;import javax.swing.WindowConstants;import javax.swing.table.DefaultTableModel;import Dao.GoodsDao;import Model.Goods;public class ManageGUI implements ActionListenerprivate JFrame frame;private JPanel panel;private JScrollPane JSP;private JTable Table;private DefaultTableModel Model;private JButton add;private JButton search;private JButton update;private JButton delete;private ArrayList goodsList;public void Init()frame = new JFrame();frame.setTitle(商品管理);frame.setLocation(205, 150);frame.setSize(480, 400);panel = new JPanel();panel.setLayout(null);Object columnTitle = 编号, 名称, 价格, 描述 ;Table = new JTable();Model = new DefaultTableModel(new String , columnTitle);Table.setModel(Model);JSP = new JScrollPane(Table);JSP.setBounds(5, 5, 455, 275);panel.add(JSP);frame.add(panel);add = new JButton();search = new JButton();update = new JButton();delete = new JButton();panel.add(add);panel.add(search);panel.add(update);panel.add(delete);add.setText(添加商品);search.setText(查找商品);update.setText(修改商品);delete.setText(删除商品);add.setBounds(22, 305, 90, 25);search.setBounds(132, 305, 90, 25);update.setBounds(242, 305, 90, 25);delete.setBounds(352, 305, 90, 25);add.addActionListener(this);add.setActionCommand(add);search.addActionListener(this);search.setActionCommand(search);update.addActionListener(this);update.setActionCommand(update);delete.addActionListener(this);delete.setActionCommand(delete);frame.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);frame.setVisible(true);public static void main(String args)/ TODO Auto-generated method stubnew ManageGUI().Init();Overridepublic void actionPerformed(ActionEvent e)/ TODO Auto-generated method stubString cmd = e.getActionCommand();switch (cmd)case search:search();break;case add:new AddGUI().Init();break;case update:update();break;case delete:delete();break;public void search()try goodsList = new GoodsDao().GetAll(); catch (SQLException e) e.printStackTrace();for (int i = Model.getRowCount() - 1; i = 0; i-) Model.removeRow(i);for (int i = 0; i goodsList.size(); i+) Object row = goodsList.get(i).getGoodsID(), goodsList.get(i).getGoodsName(),goodsList.get(i).getGoodsPrice(), goodsList.get(i).getGoodsDesc() ;Model.addRow(row);public void update()int selectedRow = Table.getSelectedRow();if (selectedRow != -1)Goods goods = new Goods(int) Table.getValueAt(selectedRow, 0),(String) Table.getValueAt(selectedRow, 1),(double) Table.getValueAt(selectedRow, 2),(String) Table.getValueAt(selectedRow, 3);new UpdateGUI().Init(goods);elsenew WarnGUI(请先在主版面表格中选择一项商品信息！);public void delete()int selectedRow = Table.getSelectedRow();if (selectedRow != -1)Goods goods = new Goods(int) Table.getValueAt(selectedRow, 0),(String) Table.getValueAt(selectedRow, 1),(double) Table.getValueAt(selectedRow, 2),(String) Table.getValueAt(selectedRow, 3);try new GoodsDao().Remove(goods); catch (SQLException e) e.printStackTrace();Model.removeRow(selectedRow);elsenew WarnGUI(请先在主版面表格中选择一项商品信息！);AddGUI:import java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JTextField;import javax.swing.WindowConstants;import Dao.GoodsDao;import Model.Goods;public class AddGUIpublic void Init()JDialog AddJD = new JDialog();JPanel AddJP = new JPanel();JLabel IDJL = new JLabel(产品ID);JLabel nameJL = new JLabel(产品名);JLabel priceJL = new JLabel(价格);JLabel descJL = new JLabel(描述);JTextField ID = new JTextField();JTextField name = new JTextField();JTextField price = new JTextField();JTextField desc = new JTextField();JButton submit = new JButton(提交);JButton cancel = new JButton(取消);tryAddJD.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);AddJD.setVisible(true);AddJD.setTitle(添加商品);AddJD.setLocation(685, 150);AddJD.setSize(480, 320);AddJP.setLayout(null);AddJD.add(AddJP);AddJP.add(IDJL);AddJP.add(nameJL);AddJP.add(priceJL);AddJP.add(descJL);AddJP.add(ID);AddJP.add(name);AddJP.add(price);AddJP.add(desc);AddJP.add(submit);AddJP.add(cancel);IDJL.setBounds(50, 45, 75, 15);nameJL.setBounds(50, 85, 75, 15);priceJL.setBounds(50, 125, 75, 15);descJL.setBounds(50, 165, 75, 15);ID.setBounds(108, 40, 250, 30);name.setBounds(108, 80, 250, 30);price.setBounds(108, 120, 250, 30);desc.setBounds(108, 160, 250, 30);submit.setBounds(108, 210, 100, 30);cancel.setBounds(258, 210, 100, 30);submit.addActionListener(new ActionListener()Overridepublic void actionPerformed(ActionEvent eve)/ TODO Auto-generated method stubGoods goods = new Goods(Integer.parseInt(ID.getText(), name.getText(), Float.parseFloat(price.getText(), desc.getText();trynew GoodsDao().Add(goods);catch (SQLException e)e.printStackTrace();AddJD.dispose(););cancel.addActionListener(new ActionListener()Overridepublic void actionPerformed(ActionEvent eve)/ TODO Auto-generated method stubAddJD.dispose(););catch (Exception e)e.printStackTrace();UpdateGUIimport java.awt.event.ActionEvent;import java.awt.event.ActionListener;import java.sql.SQLException;import javax.swing.JButton;import javax.swing.JDialog;import javax.swing.JLabel;import javax.swing.JPanel;import javax.swing.JTextField;import javax.swing.WindowConstants;import Dao.GoodsDao;import Model.Goods;public class UpdateGUI public void Init(Goods go)/ TODO “修改商品信息”界面的初始化JDialog JD = new JDialog();JPanel UpdateJP = new JPanel();JLabel IDJL = new JLabel(产品ID);JLabel nameJL = new JLabel(产品名);JLabel priceJL = new JLabel(价格);JLabel descJL = new JLabel(描述);JTextField ID = new JTextField();JTextField name = new JTextField();JTextField price = new JTextField();JTextField desc = new JTextField();JButton submit = new JButton(提交);JButton cancel = new JButton(取消);tryJD.setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);JD.setVisible(true);JD.setTitle(修改商品信息);JD.setLocation(685, 150);JD.setSize(480, 320);UpdateJP.setLayout(null);JD.add(UpdateJP);UpdateJP.add(IDJL);UpdateJP.add(nameJL);UpdateJP.add(priceJL);UpdateJP.add(descJL);UpdateJP.add(ID);UpdateJP.add(name);UpdateJP.add(price);UpdateJP.add(desc);UpdateJP.add(submit);UpdateJP.add(cancel);IDJL.setBounds(50, 45, 75, 15);nameJL.setBounds(50, 85, 75, 15);priceJL.setBounds(50, 125, 75, 15);descJL.setBounds(50, 165, 75, 15);ID.setBounds(108, 40, 250, 30);name.setBounds(108, 80, 250, 30);price.setBounds(108, 120, 250, 30);desc.setBounds(108, 160, 250, 30);submit.setBounds(108, 210, 100, 30);cancel.setBounds(258, 210, 100, 30);submit.addActionListener(new ActionListener()Overridepublic void actionPerformed(ActionEvent ev) / TODO Auto-generated method stubint id = go.getGoodsID();Goods goods = new Goods(Integer.parseInt(ID.getText(), name.getText(), Float.parseFloat(price.getText(), desc.getText();/System.out.println(goods + - name = + name);trynew GoodsDao().Modify(id, goods);catch (SQLException e)e.printStackTrace();JD.dispose(););cancel.addActionListener(new ActionListener() Overridepublic void actionPerformed(ActionEvent e)/ TODO Auto-generated method stubJD.dispose(););catch (Exception e)e.printStackTrace();课程设计二、SERVLET编程1.实验截图/product_input/product_save数据库数据项目截图：2核心代码-SaveProduct.java-package cn.whpu.action;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.sql.Statement;import cn.whpu.model.Product;public class SaveProduct public void save(Product product) Connection conn = null;Statement stat = null;try conn = getConnection();stat = conn.createStatement();String sql = insert into product (name,description,price) values(+ product.getName()+ ,+ product.getDescription()+ , + product.getPrice() + );stat.execute(sql); catch (SQLException e) e.printStackTrace(); finally try if (stat != null)stat.close();if (conn != null)conn.close(); catch (SQLException e) e.printStackTrace();public static Connection getConnection() String dbDriver = com.mysql.jdbc.Driver;String username = root;String password = 123456;String url = jdbc:mysql:/localhost:3306/czj;Connection conn = null;try Class.forName(dbDriver);conn = DriverManager.getConnection(url, username, password); catch (SQLException e) e.printStackTrace(); catch (ClassNotFoundException e) e.printStackTrace();return conn;- ControllerServlet.java-import java.io.IOException;import javax.servlet.RequestDispatcher;import javax.servlet.ServletException;import javax.servlet.annotation.WebServlet;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import cn.whpu.action.SaveProduct;import cn.whpu.form.ProductForm;import cn.whpu.model.Product;WebServlet(name = ControllerServlet, urlPatterns = /product_input,/product_save )public class ControllerServlet extends HttpServlet private static final long serialVersionUID = 1579L;Overridepublic void doGet(HttpServletRequest request, HttpServletResponse response)throws IOException, ServletException process(