商品的录入和窗口表格商品的显示

水深无声 2022-07-12 16:55 112阅读 0赞

创库

import java.awt.*;
    import java.sql.*;
    import javax.swing.*;
    import javax.swing.table.JTableHeader;
    
    public class WareHouse extends JFrame{
    private JTable WareTable;
    //  带有滚动条的面板
    private JScrollPane scr;
    //   表头
    private JTableHeader jtH;
    	
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
    	new WareHouse().SelectFunction();
    }
    //	窗体
    	public WareHouse(){
    		this.setTitle("仓库");
    		this.setSize(400, 300);
    		scr=new JScrollPane();
    		this.setLocationRelativeTo(null);
    		this.setResizable(false);
    		this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    	    add(this.scr);
    	    setVisible(true);
    	}
    //  连接数据库
    	public Connection getConnection() throws SQLException, ClassNotFoundException{
    		Class.forName("com.mysql.jdbc.Driver");
    		Connection conn=DriverManager.getConnection(
    				"jdbc:mysql://localhost:3306/chenlong","root","123456");
    		return conn;
    	}
    //	查询方法
    	public void SelectFunction() throws ClassNotFoundException, SQLException{ 
    //		获取连接
    		Connection connection =getConnection();
    //		在连接的基础上发送锥形语句
    		Statement sta=connection.createStatement();
    		String sql="select * from commodity";
    		sta.execute(sql);
    //		记录   和 数据库有几条记录
    		ResultSet rs=sta.executeQuery(sql);
    		int count=0;
    		while (rs.next()){
    			count++;
    		}
    //		再次将执行语句放入ResultSet中
    		rs=sta.executeQuery(sql);
    //		定义对象存放获取的数据
    		Object[][] data=new Object[count][6];
    //		此时count从0开始遍历输出数据，不能讲count定义在object前面。发生数组越界
    		count=0;
    //		循环将数据放入到data中
    		while(rs.next()){
    			data[count][0]=rs.getInt("ID");
    			data[count][1]=rs.getString("Name");
    			data[count][2]=rs.getString("type");
    			data[count][3]=rs.getInt("purchase");
    			data[count][4]=rs.getInt("number");
    			data[count][5]=rs.getInt("price");
    			count++;
    // System.out.println(data[count][0]);
    //			此时完全将数据库里面的数据导出到data中
    		}
    //		使用表格来存放数据
    		//表头
    		String[] title={"编号","名称","类型","进价","数量","售价"};
            this.WareTable=new JTable(data,title);
            this.jtH=this.WareTable.getTableHeader();
            this.scr.getViewport().add(WareTable); 
    	}

import java.awt.*;
    import java.awt.event.*;
    import java.sql.*;
    
    import javax.print.DocFlavor.STRING;
    import javax.swing.*;
    
    public class CommodityJpanel extends JPanel implements ActionListener {
    	private JPanel jPanel,jPanel2,jPanelMain;
    	private JLabel label,label2,label3,label4,label5,label6;
    	private JTextField textFieldID,textFieldName,textFieldINPrice,textFieldNum,textFieldOutPrice;
    	private JComboBox jComboBox;
    	private JButton jButton;
    //	连接数据库
    	public static Connection ConnectionMySQL() throws ClassNotFoundException, SQLException{
    		Class.forName("com.mysql.jdbc.Driver");
    		 Connection connection=DriverManager.getConnection(
    				"jdbc:mysql://localhost:3306/chenlong","root","123456");
    		return connection;
    	}
    //	插入语句
    	public static void insert(
    			int string,String name,String object,String string2, String string3,String string4) 
    				throws ClassNotFoundException, SQLException{
    //		拿到链接
    		Connection conn=ConnectionMySQL();
    		Statement statement=conn.createStatement();
    		String sql="insert into Commodity(ID,Name,type,Purchase,number,price) values('"+string+"','"+name+"','"+object+"','"+string2+"','"+string3+"','"+string4+"')";
    		statement.execute(sql);
    	}
    	public void jpan(){
    		jPanel=new JPanel(new GridLayout(6,2));
    		jPanel2=new JPanel(new FlowLayout(FlowLayout.CENTER));
    		jPanelMain=new JPanel(new BorderLayout());//jpanelmain.add(borderlayout.north//.south)
    		label=new JLabel(" 商 品  编 号：");
    		label2=new JLabel(" 商 品 名 称  ：");
    		label3=new JLabel(" 商 品 类 型 ：");
    		label4=new JLabel(" 商 品 进 价 ：");
    		label5=new JLabel(" 商 品 数 量 ：");
    		label6=new JLabel(" 商 品 售 价：");
    		textFieldID=new JTextField();
    		textFieldName=new JTextField();
    		textFieldINPrice=new JTextField();
    		textFieldNum=new JTextField();
    		textFieldOutPrice=new JTextField();
    		jComboBox =new JComboBox();
    		jButton=new JButton("录入");
    		jButton.addActionListener(this);
    		jComboBox.addItem("服装");jComboBox.addItem("鞋子");jComboBox.addItem("饰品");
    		jPanel.add(label);jPanel.add(textFieldID);
    		jPanel.add(label2);jPanel.add(textFieldName);
    		jPanel.add(label3);jPanel.add(jComboBox);
    		jPanel.add(label4);jPanel.add(textFieldINPrice);
    		jPanel.add(label5);jPanel.add(textFieldNum);
    		jPanel.add(label6);jPanel.add(textFieldOutPrice);
    		jPanel2.add(jButton);
    		jPanelMain.add(BorderLayout.NORTH,jPanel);
    		jPanelMain.add(BorderLayout.SOUTH,jPanel2);
    		this.add(jPanelMain);
    	}
    	@Override
    	public void actionPerformed(ActionEvent e) {
    		// TODO Auto-generated method stub
    		if(e.getSource()==jButton){
    			String bString=(String) jComboBox.getSelectedItem();
    			try {
    				JOptionPane.showConfirmDialog(null, "确认录入", "返回", JOptionPane.YES_NO_OPTION);
    				insert(Integer.parseInt(textFieldID.getText()), textFieldName.getText(),
    						bString, textFieldINPrice.getText(),
    						textFieldNum.getText(), textFieldOutPrice.getText());
    			} catch (ClassNotFoundException e1) {
    				// TODO Auto-generated catch block
    				e1.printStackTrace();
    			} catch (SQLException e1) {
    				// TODO Auto-generated catch block
    				e1.printStackTrace();
    			}
    		}
    	}
    }
    
    
     import java.sql.Connection;
    import java.sql.SQLException;
    import javax.swing.*;
    
    public class CommodityMain extends JFrame{
    	
    public static void main(String[] args) throws ClassNotFoundException, SQLException {
    	new CommodityMain().setVisible(true);
    }
    public CommodityMain(){
    	 CommodityJpanel commodityJpanel=new CommodityJpanel();
    	this.setTitle("商品录入1.0————皮蛋小粥");
    	this.setSize(300,300);
    	this.setLocationRelativeTo(null);
    	this.setResizable(false);
    	this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    //	既要方法又要加入面板
    	commodityJpanel.jpan();
    	this.add(commodityJpanel);
    }
    }