我在国企当实习程序猿的日子

GTSX_Text1.java：

主要功能都在这里。

package com.gtsx;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;import java.sql.*;
import java.text.SimpleDateFormat;//第三方控件
import hysun.util.DateChooser;
import java.util.Calendar;public class GTSX_Text1 {public static void main(String args[]) {new MainFrame();}
}class MainFrame extends JFrame implements ActionListener {public MainFrame() {super("书本入库管理系统");// 初始化 - UIcontentPane = this.getContentPane();FlowLayout fl = new FlowLayout();fl.setHgap(20);// 横向间距20像素contentPane.setLayout(fl);initSearchPanel();// 搜索显示面板initInputPanel(); // 书本入库信息录入面板// 初始化菜单条initMenuBar();// 初始化表格数据reflashTableData(SELECT_ALL_SQL);// 设置 大小 & 显示位置initHeightAndWidthAndPos();this.setSize(width, height);this.setLocation(xPos, yPos);this.setVisible(true);this.setDefaultCloseOperation(EXIT_ON_CLOSE);}/** 初始化UI - SearchPanel*/private void initSearchPanel() {// 初始化UI - searchPanelsearchPanel = new JPanel();contentPane.add(searchPanel, BorderLayout.CENTER);searchPanel.setLayout(bag);JLabel label1 = new JLabel("请输入书名：");goBtn = new JButton("查询");goBtn.addActionListener(this);text = new JTextField(25);BG = new ButtonGroup();idRB = new JRadioButton("按书本编号排序");authorRB = new JRadioButton("按作者排序");publishRB = new JRadioButton("按出版社排序");BG.add(idRB);BG.add(authorRB);BG.add(publishRB);idRB.addActionListener(this);authorRB.addActionListener(this);publishRB.addActionListener(this);idRB.setSelected(true);// 默认选中按书本编号查询// 初始化UI - searchPanel - tabletable = new JTable();scrollPane = new JScrollPane();scrollPane.setViewportView(table);scrollPane.setPreferredSize(new Dimension(500, 400));setCons(0, 3, 4, 3);searchPanel.add(scrollPane, c);setCons(0, 0, 1, 1);searchPanel.add(label1, c);setCons(1, 0, 2, 1);searchPanel.add(text, c);setCons(0, 1, 1, 1);searchPanel.add(idRB, c);setCons(1, 1, 1, 1);searchPanel.add(authorRB, c);setCons(2, 1, 1, 1);searchPanel.add(publishRB, c);setCons(3, 0, 1, 1);searchPanel.add(goBtn, c);}/** 初始化UI - inputPanel*/private void initInputPanel() {inputPanel = new JPanel();contentPane.add(inputPanel, BorderLayout.EAST);inputPanel.setLayout(bag);JLabel lb0 = new JLabel("书本编码：");setCons(0, 0, 1, 1);inputPanel.add(lb0, c);book_idTF = new JTextField(10);setCons(1, 0, 1, 1);inputPanel.add(book_idTF, c);JLabel lb2 = new JLabel("书名：");setCons(0, 1, 1, 1);inputPanel.add(lb2, c);book_nameTF = new JTextField(10);setCons(1, 1, 1, 1);inputPanel.add(book_nameTF, c);JLabel lb3 = new JLabel("作者：");setCons(0, 2, 1, 1);inputPanel.add(lb3, c);book_authorTF = new JTextField(10);setCons(1, 2, 1, 1);inputPanel.add(book_authorTF, c);JLabel lb5 = new JLabel("入库时间：");setCons(0, 3, 1, 1);inputPanel.add(lb5, c);book_dateTF = new JTextField(10);setCons(1, 3, 1, 1);inputPanel.add(book_dateTF, c);JButton select_date_btn = new JButton("选择日期");setCons(2, 3, 1, 1);inputPanel.add(select_date_btn, c);select_date_btn.addActionListener(new ActionListener() {@Overridepublic void actionPerformed(ActionEvent e) {// TODO Auto-generated method stubdc.setLocationRelativeTo(book_dateTF);dc.setVisible(true);Calendar cal = dc.getSelectedDate();if (cal != null) {book_dateTF.setText(FORMATTER.format(cal.getTime()));}}});JLabel lb4 = new JLabel("出版社：");setCons(0, 4, 1, 1);inputPanel.add(lb4, c);String nations[] = { "广铁出版社", "工业出版社", "湖南出版社", "卖萌出版社" };book_publishCB = new JComboBox(nations);book_publishCB.setMaximumSize(new Dimension(115, 20));book_publishCB.setMinimumSize(new Dimension(115, 20));book_publishCB.setPreferredSize(new Dimension(115, 20));setCons(1, 4, 1, 1);inputPanel.add(book_publishCB, c);inputBtn = new JButton("录入");inputBtn.addActionListener(this);setCons(1, 5, 1, 1);inputPanel.add(inputBtn, c);}/** GridBird 网格布局辅助函数*/public void setCons(int x, int y, int width, int height) {c.weightx = 1;c.weighty = 1;c.gridheight = height;c.gridwidth = width;c.gridx = x;c.gridy = y;}/** 初始化菜单条*/private void initMenuBar() {// TODO Auto-generated method stubmenuBar = new JMenuBar();menu = new JMenu("文件");exitItem = new JMenuItem("退出");//addBookItem.addActionListener(this);exitItem.addActionListener(this);//menu.add(addBookItem);menu.add(exitItem);menuBar.add(menu);this.setJMenuBar(menuBar);}/** 刷新表格数据 - 重载 1*/private void reflashTableData(String sql, String... pras) {reflashTableData(sql, -1, pras);}/** 刷新表格数据 - 重载2 int focusOnRowIndex; 是说明下要哪一行获得焦点。

-1表示默认情况。最后一行 */ private void reflashTableData(String sql, int focusOnRowIndex, String... pras) { // 清空JTable if (dtm != null) { dtm.setRowCount(0); } // 没有搜索条件就全排，默认加上order by xx if (sql.equals(SELECT_ALL_SQL)) { sql += getPostfix(); } ResultSet rs = DBHelper.query(sql, pras); fillCellData(rs);// 填充cellData数据 String[] columnNames = { "编号", "书名", "作者", "出版社", "入库时间", "DEL", "Edit" }; dtm = new myTablemodel(cellData, columnNames); table.setModel(dtm); // 删除按钮 this.table.getColumnModel().getColumn(delColumnIndex).setCellEditor( new MyDelButtonEditor(this.table)); this.table.getColumnModel().getColumn(delColumnIndex).setCellRenderer( new MyButtonRender("Del")); // 编辑按钮 this.table.getColumnModel().getColumn(editColumnIndex).setCellEditor( new MyEditButtonEditor(this.table, this)); this.table.getColumnModel().getColumn(editColumnIndex).setCellRenderer( new MyButtonRender("Edit")); this.table.setRowHeight(25); // 设置行焦点，默认最后一行，假设UI有操作就当前行 int allRowsCount = table.getRowCount(); table.requestFocus(); if (focusOnRowIndex == -1 || (allRowsCount - 1 + 1) == focusOnRowIndex) table.setRowSelectionInterval(allRowsCount - 1, allRowsCount - 1); else table.setRowSelectionInterval(focusOnRowIndex, focusOnRowIndex); } /* * 获取排序后缀字符串：order by xx 返回值为String */ private String getPostfix() { String postfix = null; if (idRB.isSelected()) { postfix = " order by book_id"; } else if (authorRB.isSelected()) { postfix = " order by book_author"; } else if (publishRB.isSelected()) { postfix = " order by book_publish"; } return postfix; } /* * 获取JTable 的 CellData 填充CellData的数据 */ private void fillCellData(ResultSet rs) { int rowCount = 0; try { columnNumber = rs.getMetaData().getColumnCount() + 2;// 加一个编辑一个删除 rs.last(); rowCount = rs.getRow(); if (rowCount > 0) { cellData = new Object[rowCount][columnNumber]; } else { cellData = new Object[1][columnNumber]; cellData[0][0] = "查无数据"; } rs.beforeFirst(); // 给cellData赋值 if (rs != null) { int i = 0; while (rs.next()) { for (int j = 0; j < columnNumber - 2; j++) { cellData[i][j] = rs.getObject(j + 1); } i++; } } } catch (SQLException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } } /* * 初始化UI的长宽和初始显示位置 */ private void initHeightAndWidthAndPos() { // TODO Auto-generated method stub Toolkit tk = Toolkit.getDefaultToolkit(); Dimension screenSize = tk.getScreenSize(); height = screenSize.height * 2 / 3; width = screenSize.width * 3 / 4; xPos = (screenSize.width - width) / 2; yPos = (screenSize.height - height) / 2; } /* * 响应按钮监听函数 (non-Javadoc) * * @see * java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent) */ @Override public void actionPerformed(ActionEvent e) { // TODO Auto-generated method stub if (e.getSource() == goBtn) { String searchText = this.text.getText(); if (searchText == "" || searchText.equals("")) { reflashTableData(SELECT_ALL_SQL, null); } else { String postfix = null; if (idRB.isSelected()) { postfix = " order by book_id"; } else if (authorRB.isSelected()) { postfix = " order by book_author"; } else if (publishRB.isSelected()) { postfix = " order by book_publish"; } String sql = "select * from aa_book where book_id = '" + searchText + "'" + postfix; // System.out.println(sql); reflashTableData(sql, null); } } if (e.getSource() == inputBtn) { String book_id_text = this.book_idTF.getText(); String book_name_text = this.book_nameTF.getText(); String book_author_text = this.book_authorTF.getText(); String book_publish_text = this.book_publishCB.getSelectedItem() .toString(); String book_date_text = this.book_dateTF.getText(); if (book_name_text.equals("") || book_author_text.equals("") || book_publish_text.equals("") || book_date_text.equals("")) { JOptionPane.showMessageDialog(null, "请您填写完整的数据！

", "错误哦~", JOptionPane.ERROR_MESSAGE); } else { String sql = "insert into aa_book(book_id,book_name,book_author,book_publish,create_time) values(?,?,?,?

,?

)"; String pras[] = { book_id_text, book_name_text, book_author_text, book_publish_text, book_date_text }; if (DBHelper.update(sql, pras) > 0) { JOptionPane.showMessageDialog(null, "录入成功！"); reflashTableData(SELECT_ALL_SQL, null); } else { JOptionPane.showMessageDialog(null, "书本编号已存在。", "错误哦~", JOptionPane.ERROR_MESSAGE); } } } if(e.getSource() == this.exitItem){ int returnVal = JOptionPane.showConfirmDialog(null, "确定离开?", "您点击了关闭按钮", JOptionPane.YES_NO_OPTION); if(returnVal == JOptionPane.YES_OPTION){ this.dispose(); System.exit(0); } } if(e.getSource() == idRB || e.getSource() == authorRB || e.getSource() == publishRB){ reflashTableData(SELECT_ALL_SQL, null); } } /* * 自己定义类myTablemodel 自己定义的DefaultTableModel 方便控制是否可编辑等属性 */ class myTablemodel extends DefaultTableModel { myTablemodel(Object[][] cells, String[] colnames) { super(cells, colnames); } public boolean isCellEditable(int row, int column) { if (column == delColumnIndex || column == editColumnIndex) { return true; } else { return false; } } } /* * 自己定义类MyDelButtonEditor 用来放在JTable中 */ public class MyDelButtonEditor extends DefaultCellEditor { private static final long serialVersionUID = -6546334664166791132L; private JPanel panel; private JButton button; public MyDelButtonEditor(JTable table) { // TODO Auto-generated constructor stub // DefautlCellEditor有此构造器，须要传入一个，但这个不会使用到。直接new一个就可以。 super(new JTextField()); // 设置点击几次激活编辑。 this.setClickCountToStart(1); this.initButton(table); this.initPanel(); // 加入按钮。

this.panel.add(this.button); } private void initButton(final JTable table) { this.button = new JButton(); // 设置按钮的大小及位置。 this.button.setBounds(0, 0, 50, 15); // 为按钮加入事件。这里仅仅能加入ActionListner事件，Mouse事件无效。

this.button.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { int res = JOptionPane.showConfirmDialog(null, "确认删除?", "请确定是否删除该行数据", JOptionPane.YES_NO_OPTION); if (res == JOptionPane.YES_OPTION) { int rowIndex = table.getSelectedRow(); Object book_id = table.getModel().getValueAt(rowIndex, 0); // System.out.println(book_id.toString()); String sql = "delete from aa_book where book_id = '" + book_id.toString() + "'"; if (DBHelper.update(sql, null) > 0) { JOptionPane.showMessageDialog(null, "删除成功"); reflashTableData(SELECT_ALL_SQL, rowIndex); } } // 触发取消编辑的事件，不会调用tableModel的setValue方法。

MyDelButtonEditor.this.fireEditingCanceled(); // 这里能够做其他操作。

// 能够将table传入，通过getSelectedRow,getSelectColumn方法获取到当前选择的行和列及其他操作等。 } }); } private void initPanel() { this.panel = new JPanel(); // panel使用绝对定位。这样button就不会充满整个单元格。 this.panel.setLayout(null); } /** * 这里重写父类的编辑方法。返回一个JPanel对象就可以（也能够直接返回一个Button对象，可是那样会填充满整个单元格） */ @Override public Component getTableCellEditorComponent(JTable table, Object value, boolean isSelected, int row, int column) { // 仅仅为按钮赋值就可以。

也能够作其他操作。 this.button.setText(value == null ?

"DEL" : String.valueOf(value)); return this.panel; } /** * 重写编辑单元格时获取的值。假设不重写，这里可能会为按钮设置错误的值。 */ @Override public Object getCellEditorValue() { return this.button.getText(); } } /* * 自己定义类MyEditButtonEditor 用来放在JTable中 */ public class MyEditButtonEditor extends DefaultCellEditor { private static final long serialVersionUID = -6546334664166791132L; private JPanel panel; private JButton button; public MyEditButtonEditor(JTable table, MainFrame mf) { // TODO Auto-generated constructor stub // DefautlCellEditor有此构造器，须要传入一个，但这个不会使用到。直接new一个就可以。 super(new JTextField()); // 设置点击几次激活编辑。 this.setClickCountToStart(1); this.initButton(table, mf); this.initPanel(); // 加入按钮。 this.panel.add(this.button); } private void initButton(final JTable table, final MainFrame mf) { this.button = new JButton(); // 设置按钮的大小及位置。 this.button.setBounds(0, 0, 50, 15); // 为按钮加入事件。

这里仅仅能加入ActionListner事件。Mouse事件无效。

this.button.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { EditDialog ed = new EditDialog(mf); // 触发取消编辑的事件，不会调用tableModel的setValue方法。 MyEditButtonEditor.this.fireEditingCanceled(); // 这里能够做其他操作。

// 能够将table传入，通过getSelectedRow,getSelectColumn方法获取到当前选择的行和列及其他操作等。 } }); } private void initPanel() { this.panel = new JPanel(); // panel使用绝对定位，这样button就不会充满整个单元格。 this.panel.setLayout(null); } /** * 这里重写父类的编辑方法。返回一个JPanel对象就可以（也能够直接返回一个Button对象，可是那样会填充满整个单元格） */ @Override public Component getTableCellEditorComponent(JTable table, Object value, boolean isSelected, int row, int column) { // 仅仅为按钮赋值就可以。也能够作其他操作。

this.button.setText(value == null ?

"DEL" : String.valueOf(value)); return this.panel; } /** * 重写编辑单元格时获取的值。

假设不重写。这里可能会为按钮设置错误的值。 */ @Override public Object getCellEditorValue() { return this.button.getText(); } } /* * 自己定义类EditDialog 用来放在改动书本信息 */ class EditDialog { private JTextField book_id_TF; private JTextField book_name_TF; private JTextField book_author_TF; private JTextField book_publish_TF; private JTextField book_date_TF; private JPanel panel; private JButton saveBtn; private String orgBookID; public EditDialog(JFrame father) { final JDialog jd = new JDialog(father, "编辑书本信息", true); panel = new JPanel(); Container jd_contentPane = jd.getContentPane(); jd_contentPane.setLayout(bag); TableModel tm = table.getModel(); int row = table.getSelectedRow(); orgBookID = tm.getValueAt(row, 0).toString(); JLabel lb0 = new JLabel("书本编码："); book_id_TF = new JTextField(20); book_id_TF.setText(tm.getValueAt(row, 0).toString()); JLabel lb1 = new JLabel("书名："); book_name_TF = new JTextField(20); book_name_TF.setText(tm.getValueAt(row, 1).toString()); JLabel lb2 = new JLabel("作者："); book_author_TF = new JTextField(20); book_author_TF.setText(tm.getValueAt(row, 2).toString()); JLabel lb3 = new JLabel("出版社："); book_publish_TF = new JTextField(20); book_publish_TF.setText(tm.getValueAt(row, 3).toString()); JLabel lb4 = new JLabel("入库日期："); book_date_TF = new JTextField(20); book_date_TF.setText(tm.getValueAt(row, 4).toString()); // panel.setLayout(bag); setCons(0, 0, 1, 1); jd_contentPane.add(lb0, c); setCons(1, 0, 1, 1); jd_contentPane.add(book_id_TF, c); setCons(0, 1, 1, 1); jd_contentPane.add(lb1, c); setCons(1, 1, 1, 1); jd_contentPane.add(book_name_TF, c); setCons(0, 2, 1, 1); jd_contentPane.add(lb2, c); setCons(1, 2, 1, 1); jd_contentPane.add(book_author_TF, c); setCons(0, 3, 1, 1); jd_contentPane.add(lb3, c); setCons(1, 3, 1, 1); jd_contentPane.add(book_publish_TF, c); setCons(0, 4, 1, 1); jd_contentPane.add(lb4, c); setCons(1, 4, 1, 1); jd_contentPane.add(book_date_TF, c); saveBtn = new JButton("改动"); setCons(1, 5, 1, 1); jd_contentPane.add(saveBtn, c); saveBtn.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent arg0) { // TODO Auto-generated method stub String book_id = book_id_TF.getText(); String book_name = book_name_TF.getText(); String book_author = book_author_TF.getText(); String book_publish = book_publish_TF.getText(); String book_date = book_date_TF.getText(); // 请注意。。！

！！！！

。！

！

！。！ // 这边逻辑太多了。就偷懒，默认四个都不为空都会改动吧 String sql = "update aa_book set book_id = ?, book_name = ?

, book_author = ? , book_publish = ?

, create_time = ?

where book_id = ?

"; String[] pras = { book_id, book_name, book_author, book_publish, book_date, orgBookID }; if (DBHelper.update(sql, pras) > 0) { JOptionPane.showMessageDialog(null, "改动成功！"); reflashTableData(SELECT_ALL_SQL, null); jd.dispose(); } else { JOptionPane.showMessageDialog(null, "书本编号冲突！

", "ERROR! 改动不成功!", JOptionPane.ERROR_MESSAGE); } } }); jd.setSize(400, 300); Toolkit tk = Toolkit.getDefaultToolkit(); Dimension screenSize = tk.getScreenSize(); height = screenSize.height * 1 / 3; width = screenSize.width * 1 / 4; int xPos = (screenSize.width - width) / 2; int yPos = (screenSize.height - height) / 2; jd.setLocation(xPos, yPos); jd.setVisible(true); } } private JPanel panel; private Container contentPane; private JPanel searchPanel; private JPanel inputPanel; private int height, width, xPos, yPos; private JMenuBar menuBar; private JMenu menu; private JMenuItem addBookItem; private JMenuItem exitItem; private JTable table; private Object[][] cellData; private JScrollPane scrollPane; private int columnNumber; private int defaultRowsNum; GridBagLayout bag = new GridBagLayout(); GridBagConstraints c = new GridBagConstraints(); private JButton goBtn; private JTextField text; private myTablemodel dtm = null; private JTextField book_idTF; private JTextField book_nameTF; private JTextField book_authorTF; private JComboBox book_publishCB; private JTextField book_dateTF; private JButton inputBtn; final DateChooser dc = new DateChooser(this, true); private static final SimpleDateFormat FORMATTER = new SimpleDateFormat( "yyyy-MM-dd"); private int delColumnIndex = 5; private int editColumnIndex = 6; private String SELECT_ALL_SQL = "select * from aa_book"; private ButtonGroup BG; private JRadioButton idRB; private JRadioButton authorRB; private JRadioButton publishRB; }

实现一个书本入库管理系统，可以：增删改查！

辅助类，用来调整JTable中的JButton属性。

package com.gtsx;
import java.awt.Component;import javax.swing.JButton;
import javax.swing.JPanel;
import javax.swing.JTable;
import javax.swing.table.TableCellRenderer;public class MyButtonRender implements TableCellRenderer  
{  private JPanel panel;  private JButton button;  private String nameOfBtn;public MyButtonRender(String btnName)  {  nameOfBtn = btnName;this.initButton();  this.initPanel();  // 加入按钮。

this.panel.add(this.button); } private void initButton() { this.button = new JButton(); // 设置按钮的大小及位置。 this.button.setBounds(5, 2, 60, 20); // 在渲染器里边加入按钮的事件是不会触发的 // this.button.addActionListener(new ActionListener() // { // // public void actionPerformed(ActionEvent e) // { // // TODO Auto-generated method stub // } // }); } private void initPanel() { this.panel = new JPanel(); // panel使用绝对定位。这样button就不会充满整个单元格。 this.panel.setLayout(null); } public Component getTableCellRendererComponent(JTable table, Object value, boolean isSelected, boolean hasFocus, int row, int column) { // 仅仅为按钮赋值就可以。也能够作其他操作。如绘背景等。 //this.button.setText(value == null ? "DEL" : String.valueOf(value)); this.button.setText(nameOfBtn); return this.panel; } }

emaster  关注信息安全的胖子
欢迎转载，但转载请注明地址：http://blog.csdn.net/emaste_r/article/details/25384691

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！