a6间谍菜鸟 a6间谍菜鸟
关注数: 40 粉丝数: 294 发帖数: 12,537 关注贴吧数: 272
求教啊,这个怎么互换位置 package test; import java.awt.BorderLayout; import java.awt.Dimension; import java.awt.FlowLayout; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.io.UnsupportedEncodingException; import java.sql.ResultSet; import java.util.List; import java.util.Vector; import javax.swing.JButton; import javax.swing.JDialog; import javax.swing.JLabel; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.table.DefaultTableModel; public class MyDialog extends JDialog { Vector columns=new Vector(); JTable table; public MyDialog() { this.setTitle("管理界面"); columns.add("水果编号"); columns.add("水果名称"); columns.add("水果单价"); columns.add("计价单位"); JPanel main_panel=new JPanel(); main_panel.setLayout(new BorderLayout(5,10)); JLabel label=new JLabel("水果列表",JLabel.CENTER); table=new JTable(); JScrollPane sp=new JScrollPane(table); sp.setPreferredSize(new Dimension(400,150)); JLabel lb_no=new JLabel("水果编号"); JLabel lb_name=new JLabel("水果名称"); JLabel lb_price=new JLabel("水果单价"); JLabel lb_unit=new JLabel("计价单位"); JTextField tf_no1=new JTextField(); JTextField tf_name1=new JTextField(); JTextField tf_price1=new JTextField(); JTextField tf_unit1=new JTextField(); JTextField tf_no2=new JTextField(); JTextField tf_name2=new JTextField(); JTextField tf_price2=new JTextField(); JTextField tf_unit2=new JTextField(); JTextField tf_no3=new JTextField(); JButton bt_add=new JButton("添加水果"); JButton bt_modify=new JButton("修改水果"); JButton bt_delete=new JButton("删除水果"); bt_add.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub if(check_exist(tf_no1.getText())>0) { JOptionPane.showMessageDialog(MyDialog.this, "水果编号已存在"); return; } String strSql="insert into fruit values(" +tf_no1.getText()+",'" +tf_name1.getText()+"'," +tf_price1.getText()+",'" +tf_unit1.getText()+"')"; int rt=update_data(strSql); if(rt>0) JOptionPane.showMessageDialog(MyDialog.this, "添加成功"); else JOptionPane.showMessageDialog(MyDialog.this, "添加失败"); load_data(null); } }); bt_modify.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub String strSql="update fruit set name='" +tf_name2.getText()+"',price=" +tf_price2.getText()+",unit='" +tf_unit2.getText()+"' where no="+tf_no2.getText(); int rt=update_data(strSql); if(rt>0) JOptionPane.showMessageDialog(MyDialog.this, "修改成功"); else JOptionPane.showMessageDialog(MyDialog.this, "修改失败"); load_data(null); } }); bt_delete.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent ae) { // TODO Auto-generated method stub String strSql="delete from fruit where no="+tf_no3.getText(); int rt=update_data(strSql); if(rt>0) JOptionPane.showMessageDialog(MyDialog.this, "删除成功"); else JOptionPane.showMessageDialog(MyDialog.this, "删除失败"); load_data(null); } }); JPanel panel=new JPanel(); panel.setLayout(new GridLayout(4, 5,10,5)); panel.add(lb_no); panel.add(lb_name); panel.add(lb_price); panel.add(lb_unit); panel.add(new JLabel()); panel.add(tf_no1); panel.add(tf_name1); panel.add(tf_price1); panel.add(tf_unit1); panel.add(bt_add); panel.add(tf_no2); panel.add(tf_name2); panel.add(tf_price2); panel.add(tf_unit2); panel.add(bt_modify); JButton bt_exit=new JButton("退出"); bt_exit.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub dispose(); } }); JButton bt_sort=new JButton("排序"); bt_sort.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub String strSql="select * from fruit order by price desc"; load_data(strSql); } }); panel.add(tf_no3); panel.add(bt_exit); panel.add(bt_sort); panel.add(new JLabel()); panel.add(bt_delete); main_panel.add(label, BorderLayout.NORTH); main_panel.add(sp, BorderLayout.CENTER); main_panel.add(panel, BorderLayout.SOUTH); FlowLayout flayout=new FlowLayout(FlowLayout.CENTER,5,20); this.setLayout(flayout); this.add(main_panel); this.setDefaultCloseOperation(JDialog.DISPOSE_ON_CLOSE); this.setSize(600,400); this.setLocationRelativeTo(null); load_data(null); } public int update_data(String strSql) { System.out.println(strSql); DBUtil db = new DBUtil(); int rt=0; try { rt = db.execUpdate(strSql); db.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return rt; } public void load_data(String strSql) { if(strSql==null) strSql="select * from fruit "; System.out.println(strSql); DBUtil db = new DBUtil(); try { ResultSet rs = db.execQuery(strSql); Vector vec=db.rs2vector(rs); DefaultTableModel model=new DefaultTableModel(vec,columns); table.setModel(model); rs.close(); db.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } public int check_exist(String no) { String strSql="select count(*) from fruit where no="+no; DBUtil db = new DBUtil(); int cnt=0; try { cnt = db.execCount(strSql); db.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return cnt; } public static void main(String[] args) { // TODO Auto-generated method stub MyDialog dialog=new MyDialog(); dialog.setVisible(true); } }
1 下一页