简单的商品管理系统

package com.sw; import java.awt.CardLayout; import java.awt.Color; import java.awt.Panel; import java.awt.Rectangle; 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.JLabel; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.table.DefaultTableModel; import com.JJdbc.Goods; import com.JJdbc.JAction; import com.JJdbc.JactionDe; public class TextAt{ static int a = 1; public TextAt(){ } public static JPanel PP1(){ JPanel p = new JPanel(); JLabel jb5 = new JLabel("欢迎来到商品管理系统"); p.add(jb5); return p; } public static JPanel PP2() { JPanel p = new JPanel(); p.setLayout(null); JLabel Lsno = new JLabel("商品编号"); JLabel Lsname = new JLabel("商品名字"); JLabel Lmname = new JLabel("商品产地"); JLabel Lqty = new JLabel("商品数量"); JLabel L1 = new JLabel(""); JLabel L2 = new JLabel(""); JLabel L3 = new JLabel(""); JLabel L4 = new JLabel(""); JTextField Tsno = new JTextField(); JTextField Tsname = new JTextField(); JTextField Tmname = new JTextField(); JTextField Tqty = new JTextField(); JButton Blogin = new JButton("提交"); Lsno.setBounds(new Rectangle(245, 38, 67, 34)); Lsname.setBounds(new Rectangle(245, 88, 67, 34)); Lmname.setBounds(new Rectangle(245, 138, 67, 34)); Lqty.setBounds(new Rectangle(245,186, 66, 26)); Tsno.setBounds(new Rectangle(315, 39,210, 33)); Tsname.setBounds(new Rectangle(315, 89,210, 33)); Tmname.setBounds(new Rectangle(315, 139,210, 33)); Tqty.setBounds(new Rectangle(315, 189,210, 33)); L1.setBounds(new Rectangle(535, 39,210, 33)); L2.setBounds(new Rectangle(535, 88, 67, 34)); L3.setBounds(new Rectangle(535, 138, 67, 34)); L4.setBounds(new Rectangle(535,186, 66, 26)); Blogin.setBounds(new Rectangle(315, 229,210, 33)); Blogin.addActionListener(new ActionListener(){ @Override public void actionPerformed(ActionEvent e){ if("提交".equals(e.getActionCommand())){ String n1 = Tsno.getText().toString(); String n2 = Tsname.getText().toString(); String n3 = Tmname.getText().toString(); String n4 = Tqty.getText().toString(); if(n1.length() == 0){ L1.setText("商品编号不能为空"); Chuangkou("商品编号不能为空"); }else{ if(n2.length() == 0){ L2.setText("商品名字不能为空"); L1.setText(""); Chuangkou("商品名字不能为空"); }else{ if(n3.length() == 0){ L3.setText("商品产地不能为空"); L2.setText(""); Chuangkou("商品产地不能为空"); }else{ if(n4.length() == 0){ L3.setText("商品数量不能为空"); L2.setText(""); Chuangkou("商品数量不能为空"); }else{ int n5 = Integer.parseInt(Tqty.getText()); L4.setText(""); Goods s1=new Goods(); s1.setSno(n1); s1.setSname(n2); s1.setMname(n3); s1.setQty(n5); try { JAction.Ginserts(s1); } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } Chuangkou("录入成功"); Tsno.setText("") ; Tsname.setText("") ; Tmname.setText("") ; Tqty.setText("") ; } } } } } } }); p.add(Lsno); p.add(Lsname); p.add(Lmname); p.add(Lqty); p.add(Tsno); p.add(Tsname); p.add(Tmname); p.add(Tqty); p.add(L1); p.add(L2); p.add(L3); p.add(L4); p.add(Blogin); return p; } public static JPanel PP3() { JPanel p = new JPanel(); final Object[] c= {"sno","sname","mname","qty"}; try { ArrayList<Goods> ss = JAction.GA(); int column = ss.size(); final Object[][] ra =new Object[column][7]; int i = 0; for(Goods s:ss){ ra[i][0]=s.getSno(); ra[i][1]=s.getSname(); ra[i][2]=s.getMname(); ra[i][3]=s.getQty(); i++; } //JTable friend = new JTable((Object[][]) ra,c); DefaultTableModel dtm=new DefaultTableModel(ra,c); JTable friend=new JTable(dtm); friend.setRowHeight(30); friend.setRowHeight(0,20); friend.setRowMargin(5); friend.setRowSelectionAllowed(true); friend.setSelectionBackground(Color.white); friend.setSelectionForeground(Color.red); friend.setGridColor(Color.black); friend.selectAll(); friend.setRowSelectionInterval(0,2); friend.clearSelection(); friend.setDragEnabled(false); friend.setShowGrid(false); friend.setShowHorizontalLines(true); friend.setShowVerticalLines(true); //friend.setValueAt("t", 0, 0); friend.doLayout(); friend.setBackground(Color.lightGray); JScrollPane p3 = new JScrollPane(friend); JPanel p1 = new JPanel(); p1.add(p3); p.add(p1); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return p; } public static JPanel PP4(){ JPanel p = new JPanel(); p.setLayout(null); JLabel Lsno = new JLabel("商品编号"); JLabel Lsname = new JLabel("商品名字"); JLabel Lmname = new JLabel("商品产地"); JLabel Lqty = new JLabel("商品数量"); JLabel L1 = new JLabel(""); JLabel L2 = new JLabel(""); JLabel L3 = new JLabel(""); JLabel L4 = new JLabel(""); JTextField Tsno = new JTextField(); JTextField Tsname = new JTextField(); JTextField Tmname = new JTextField(); JTextField Tqty = new JTextField(); JButton B1 = new JButton("根据商品编号修改"); JButton B2 = new JButton("根据商品名字修改"); Lsno.setBounds(new Rectangle(245, 38, 67, 34)); Lsname.setBounds(new Rectangle(245, 88, 67, 34)); Lmname.setBounds(new Rectangle(245, 138, 67, 34)); Lqty.setBounds(new Rectangle(245,186, 66, 26)); Tsno.setBounds(new Rectangle(315, 39,210, 33)); Tsname.setBounds(new Rectangle(315, 89,210, 33)); Tmname.setBounds(new Rectangle(315, 139,210, 33)); Tqty.setBounds(new Rectangle(315, 189,210, 33)); L1.setBounds(new Rectangle(535, 39,210, 33)); L2.setBounds(new Rectangle(535, 88, 67, 34)); L3.setBounds(new Rectangle(535, 138, 67, 34)); L4.setBounds(new Rectangle(535,186, 66, 26)); B1.setBounds(new Rectangle(315, 229,210, 33)); B2.setBounds(new Rectangle(315, 279,210, 33)); B1.addActionListener(new ActionListener(){ @Override public void actionPerformed(ActionEvent e){ if("根据商品编号修改".equals(e.getActionCommand())){ String n1 = Tsno.getText().toString(); String n2 = Tsname.getText().toString(); String n3 = Tmname.getText().toString(); String n4 = Tqty.getText().toString(); if(n1.length() == 0){ L1.setText("商品编号不能为空"); Chuangkou("商品编号不能为空"); }else{ if(n2.length() == 0){ L2.setText("商品名字不能为空"); L1.setText(""); Chuangkou("商品名字不能为空"); }else{ if(n3.length() == 0){ L3.setText("商品产地不能为空"); L2.setText(""); Chuangkou("商品产地不能为空"); }else{ if(n4.length() == 0){ L3.setText("商品数量不能为空"); L2.setText(""); Chuangkou("商品数量不能为空"); }else{ L4.setText(""); try { int n5 = Integer.parseInt(n4)