?? bookmodianddeliframe.java
字號:
package com.wsy.iframe;
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.SystemColor;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.sql.Date;
import java.text.NumberFormat;
import java.text.SimpleDateFormat;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.swing.DefaultComboBoxModel;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFormattedTextField;
import javax.swing.JInternalFrame;
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.SwingConstants;
import javax.swing.border.EmptyBorder;
import javax.swing.border.LineBorder;
import javax.swing.table.DefaultTableModel;
import com.wsy.JComPz.Item;
import com.wsy.JComPz.MapPz;
import com.wsy.dao.Dao;
import com.wsy.model.BookInfo;
import com.wsy.model.BookType;
import com.wsy.util.CreatecdIcon;
import com.wsy.util.MyDocument;
/**
* 名稱：圖書修改窗體
*
*/
public class BookModiAndDelIFrame extends JInternalFrame {
private JTable table;
private JFormattedTextField price;
private JFormattedTextField pubDate;
private JTextField translator;
private JTextField publisher;
private JTextField writer;
private JTextField ISBN;
private JTextField bookName;
private JComboBox bookType;
DefaultComboBoxModel bookTypeModel;
private Item item;
Map map=new HashMap();
private String[] columnNames;
private Map m=MapPz.getMap();
//取數據庫中圖書相關信息放入表格中
private Object[][] getFileStates(List list){
String[] columnNames = { "圖書編號", "圖書類別", "圖書名稱", "作者", "譯者", "出版商",
"出版日期", "價格" };
Object[][]results=new Object[list.size()][columnNames.length];
for(int i=0;i<list.size();i++){
BookInfo bookinfo=(BookInfo)list.get(i);
results[i][0]=bookinfo.getISBN();
String booktypename=String.valueOf(MapPz.getMap().get(bookinfo.getTypeid()));
results[i][1]=booktypename;
results[i][2]=bookinfo.getBookname();
results[i][3]=bookinfo.getWriter();
results[i][4]=bookinfo.getTranslator();
results[i][5]=bookinfo.getPublisher();
results[i][6]=bookinfo.getDate();
results[i][7]=bookinfo.getPrice();
}
return results;
}
public BookModiAndDelIFrame() {
super();
final BorderLayout borderLayout = new BorderLayout();
getContentPane().setLayout(borderLayout);
setIconifiable(true);
setClosable(true);
setTitle("圖書信息修改");
setBounds(100, 100, 593, 406);
final JPanel panel_1 = new JPanel();
panel_1.setBorder(new LineBorder(SystemColor.activeCaptionBorder, 1, false));
getContentPane().add(panel_1, BorderLayout.SOUTH);
final FlowLayout flowLayout = new FlowLayout();
flowLayout.setVgap(2);
flowLayout.setHgap(30);
flowLayout.setAlignment(FlowLayout.RIGHT);
panel_1.setLayout(flowLayout);
final JButton button = new JButton();
button.addActionListener(new addBookActionListener());
button.setText("修改");
panel_1.add(button);
// final JButton button_2 = new JButton();
// button_2.addActionListener(new ActionListener(){
// public void actionPerformed(final ActionEvent e) {
// String ISBNs=ISBN.getText().trim();
// int i=Dao.Delbook(ISBNs);
// if(i==1){
// JOptionPane.showMessageDialog(null, "刪除成功");
// Object[][] results=getFileStates(Dao.selectBookInfo());
// //注釋代碼為使用表格模型
// DefaultTableModel model=new DefaultTableModel();
//// DefaultTableModel model = (DefaultTableModel) table.getModel();
// table.setModel(model);
// model.setDataVector(results, columnNames);
// }
// }
// });
// button_2.setText("刪除");
//
// panel_1.add(button_2);
final JButton button_1 = new JButton();
button_1.addActionListener(new ActionListener() {
public void actionPerformed(final ActionEvent e) {
doDefaultCloseAction();
}
});
button_1.setText("關閉");
panel_1.add(button_1);
final JLabel headLogo = new JLabel();
ImageIcon bookModiAndDelIcon=CreatecdIcon.add("bookmodify.jpg");
headLogo.setIcon(bookModiAndDelIcon);
headLogo.setOpaque(true);
headLogo.setBackground(Color.CYAN);
headLogo.setPreferredSize(new Dimension(400, 80));
headLogo.setBorder(new LineBorder(SystemColor.activeCaptionBorder, 1, false));
getContentPane().add(headLogo, BorderLayout.NORTH);
final JPanel panel_2 = new JPanel();
final BorderLayout borderLayout_1 = new BorderLayout();
borderLayout_1.setVgap(5);
panel_2.setLayout(borderLayout_1);
panel_2.setBorder(new EmptyBorder(5, 10, 5, 10));
getContentPane().add(panel_2);
final JScrollPane scrollPane = new JScrollPane();
panel_2.add(scrollPane);
Object[][] results=getFileStates(Dao.selectBookInfo());
columnNames = new String[]{"圖書編號", "圖書類別", "圖書名稱", "作者", "譯者", "出版商", "出版日期",
"價格"};
table = new JTable(results,columnNames);
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
//鼠標單擊表格中的內容產生事件,將表格中的內容放入文本框中
table.addMouseListener(new TableListener());
scrollPane.setViewportView(table);
final JPanel bookPanel = new JPanel();
panel_2.add(bookPanel, BorderLayout.SOUTH);
final GridLayout gridLayout = new GridLayout(0, 6);
gridLayout.setVgap(5);
gridLayout.setHgap(5);
bookPanel.setLayout(gridLayout);
final JLabel label_2 = new JLabel();
label_2.setHorizontalAlignment(SwingConstants.CENTER);
label_2.setText("書 號：");
bookPanel.add(label_2);
ISBN = new JTextField();
ISBN.setDocument(new MyDocument(13));
bookPanel.add(ISBN);
final JLabel label = new JLabel();
label.setHorizontalAlignment(SwingConstants.CENTER);
label.setText("類 別：");
bookPanel.add(label);
bookType = new JComboBox();
bookTypeModel= (DefaultComboBoxModel)bookType.getModel();
List list=Dao.selectBookCategory();
for(int i=0;i<list.size();i++){
BookType booktype=(BookType)list.get(i);
item=new Item();
item.setId((String)booktype.getId());
item.setName((String)booktype.getTypeName());
bookTypeModel.addElement(item);
map.put(item.getId(), item);
}
bookPanel.add(bookType);
final JLabel label_1 = new JLabel();
label_1.setHorizontalAlignment(SwingConstants.CENTER);
label_1.setText("書 名：");
bookPanel.add(label_1);
bookName = new JTextField();
bookPanel.add(bookName);
final JLabel label_3 = new JLabel();
label_3.setHorizontalAlignment(SwingConstants.CENTER);
label_3.setText("作 者：");
bookPanel.add(label_3);
writer = new JTextField();
bookPanel.add(writer);
final JLabel label_2_1 = new JLabel();
label_2_1.setHorizontalAlignment(SwingConstants.CENTER);
label_2_1.setText("出 版 社：");
bookPanel.add(label_2_1);
publisher = new JTextField();
bookPanel.add(publisher);
final JLabel label_4 = new JLabel();
label_4.setHorizontalAlignment(SwingConstants.CENTER);
label_4.setText("譯 者：");
bookPanel.add(label_4);
translator = new JTextField();
bookPanel.add(translator);
final JLabel label_1_1 = new JLabel();
label_1_1.setHorizontalAlignment(SwingConstants.CENTER);
label_1_1.setText("出 版 日 期：");
bookPanel.add(label_1_1);
SimpleDateFormat myfmt=new SimpleDateFormat("yyyy-MM-dd");
pubDate= new JFormattedTextField(myfmt.getDateInstance());
pubDate.setValue(new java.util.Date());
bookPanel.add(pubDate);
final JLabel label_3_1 = new JLabel();
label_3_1.setHorizontalAlignment(SwingConstants.CENTER);
label_3_1.setText("單 價：");
bookPanel.add(label_3_1);
price= new JFormattedTextField();
price.addKeyListener(new NumberListener());
bookPanel.add(price);
setVisible(true);
}
class TableListener extends MouseAdapter {
public void mouseClicked(final MouseEvent e) {
String ISBNs, typeids, bookNames,writers,translators,publishers,dates,prices;
int selRow = table.getSelectedRow();
ISBNs = table.getValueAt(selRow, 0).toString().trim();
typeids = table.getValueAt(selRow, 1).toString().trim();
bookNames = table.getValueAt(selRow, 2).toString().trim();
writers = table.getValueAt(selRow, 3).toString().trim();
translators = table.getValueAt(selRow, 4).toString().trim();
publishers = table.getValueAt(selRow, 5).toString().trim();
dates = table.getValueAt(selRow, 6).toString().trim();
prices = table.getValueAt(selRow, 7).toString().trim();
ISBN.setText(ISBNs);
//bookTypeModel.setSelectedItem(item);
bookTypeModel.setSelectedItem(typeids);
bookName.setText(bookNames);
writer.setText(writers);
translator.setText(translators);
publisher.setText(publishers);
pubDate.setText(dates);
price.setText(prices);
}
}
class addBookActionListener implements ActionListener {
public void actionPerformed(final ActionEvent e) {
// 修改圖書信息表
if(ISBN.getText().length()==0){
JOptionPane.showMessageDialog(null, "書號文本框不可以為空或則輸入數字不可以大于13個");
return;
}
if(ISBN.getText().length()!=13){
JOptionPane.showMessageDialog(null, "書號文本框輸入位數為13位");
return;
}
if(bookName.getText().length()==0){
JOptionPane.showMessageDialog(null, "圖書名稱文本框不可以為空");
return;
}
if(writer.getText().length()==0){
JOptionPane.showMessageDialog(null, "作者文本框不可以為空");
return;
}
if(publisher.getText().length()==0){
JOptionPane.showMessageDialog(null, "出版人文本框不可以為空");
return;
}
//日期與單價進行數字驗證代碼？
if(pubDate.getText().length()==0){
JOptionPane.showMessageDialog(null, "出版日期文本框不可以為空");
return;
}
if(price.getText().length()==0){
JOptionPane.showMessageDialog(null, "單價文本框不可以為空");
return;
}
String ISBNs=ISBN.getText().trim();
//分類
Object selectedItem = bookTypeModel.getSelectedItem();
if (selectedItem == null)
return;
Item item = (Item)selectedItem;
String bookTypes=item.getId();
System.out.println(bookTypes);
String translators=translator.getText().trim();
String bookNames=bookName.getText().trim();
String writers=writer.getText().trim();
String publishers=publisher.getText().trim();
String pubDates=pubDate.getText().trim();
String prices=price.getText().trim();
int i=Dao.Updatebook(ISBNs, bookTypes, bookNames, writers, translators, publishers, Date.valueOf(pubDates), Double.parseDouble(prices));
System.out.println(i);
if(i==1){
JOptionPane.showMessageDialog(null, "修改成功");
Object[][] results=getFileStates(Dao.selectBookInfo());
//注釋代碼為使用表格模型
DefaultTableModel model=new DefaultTableModel();
// DefaultTableModel model = (DefaultTableModel) table.getModel();
table.setModel(model);
model.setDataVector(results, columnNames);
}
}
}
class NumberListener extends KeyAdapter {
public void keyTyped(KeyEvent e) {
String numStr="0123456789."+(char)8;
if(numStr.indexOf(e.getKeyChar())<0){
e.consume();
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -