JAVA Swing自己编的数据库

package com.boyce.view; import java.awt.Component; import java.awt.EventQueue; import java.awt.FlowLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.MouseAdapter; import java.awt.event.MouseEvent; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import javax.swing.JButton; import javax.swing.JFrame; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.table.DefaultTableModel; import org.eclipse.wb.swing.FocusTraversalOnArray; import org.omg.CORBA.Request; import com.boyce.dao.TDao; import com.boyce.dao.impl.TDaoImpl; import com.boyce.util.DBUtil; import java.awt.Window.Type; import java.util.Vector; import javax.swing.JCheckBox; import javax.swing.ScrollPaneConstants; public class MainFrame { private JFrame frmjava; private JTable table; /** * Launch the application. */ public static void main(String[] args) { EventQueue.invokeLater(new Runnable() { public void run() { try { MainFrame window = new MainFrame(); window.frmjava.setVisible(true); } catch (Exception e) { e.printStackTrace(); } } }); } /** * Create the application. */ public MainFrame() { initialize(); } /** * Initialize the contents of the frame. */ private void initialize() { frmjava = new JFrame(); frmjava.setResizable(false); frmjava.addWindowListener(new WindowAdapter() { @Override public void windowOpened(WindowEvent e) { } @Override public void windowActivated(WindowEvent e) { TDao tDao = new TDaoImpl(); try { Vector v = new Vector(); table.setModel(tDao .getT_tableData("select * from t_tab", v)); } catch (Exception e1) { e1.printStackTrace(); } } }); frmjava.setTitle("我的java窗体"); frmjava.setBounds(100, 100, 518, 530); frmjava.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); frmjava.getContentPane().setLayout( new FlowLayout(FlowLayout.CENTER, 5, 5)); JButton btnNewButton = new JButton("删除选中行"); btnNewButton.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { int id = Integer.parseInt((String) table.getValueAt( table.getSelectedRow(), 0)); TDao tDao = new TDaoImpl(); try { tDao.deleteById(id, "delete from t_tab where id = ?"); System.out.println("删除ID为：[" + id + "]这条数据成功！"); Vector v = new Vector(); table.setModel(tDao .getT_tableData("select * from t_tab", v)); } catch (Exception e1) { e1.printStackTrace(); } } }); JScrollPane scrollPane = new JScrollPane(); scrollPane.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER); frmjava.getContentPane().add(scrollPane); table = new JTable(); table.addMouseListener(new MouseAdapter() { @Override public void mouseClicked(MouseEvent e) { int index = table.getSelectedRow();// 鼠标点击的行数 int id = Integer.parseInt((String) table.getValueAt(index, 0)); System.out.println("您选中了第" + index + "行,数据库ID为" + id + "！"); } }); scrollPane.setViewportView(table); table.setModel(new DefaultTableModel(new Object[][] { { null, null, null, null, null }, { null, null, null, null, null }, { null, null, null, null, null }, { null, null, null, null, null }, { null, null, null, null, null }, }, new String[] { "New column", "New column", "New column", "New column", "New column" })); frmjava.getContentPane().setFocusTraversalPolicy( new FocusTraversalOnArray(new Component[] { table })); JButton button = new JButton("增加新数据"); button.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { AddFrame aF = new AddFrame(); aF.setVisible(true); } }); frmjava.getContentPane().add(button); frmjava.getContentPane().add(btnNewButton); final JCheckBox checkBox = new JCheckBox("中英文显示字段"); checkBox.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { TDao dao = new TDaoImpl(); if (checkBox.isSelected()) { System.out.println("被选中"); Vector v = new Vector();// 设置自定义字段名存入Vector集合中 v.add("ID"); v.add("姓名"); v.add("年龄"); v.add("性别"); v.add("电话"); try { table.setModel(dao.getT_tableData( "select * from t_tab", v)); } catch (Exception e1) { e1.printStackTrace(); } } else { Vector v = new Vector();// 设置空的集合返回数据库默认字段名 try { table.setModel(dao.getT_tableData( "select * from t_tab", v)); } catch (Exception e1) { e1.printStackTrace(); } System.out.println("没选中"); } } }); frmjava.getContentPane().add(checkBox); } }