?? userframe.java~41~
字號:
JTable table,tab; // 聲明一個JTable類對象table
JScrollPane scroll,scr; // 聲明一個滾動杠對象scroll
vector = new Vector(); //for information of books // 創建向量對象
vec=new Vector(); //for informaiton of user borrow book
tm = new AbstractTableModel() { //for information of books // 創建AbstractTableModel類對象tm
public int getColumnCount() { // 取得表格列數
return title.length;
}
public int getRowCount() { // 取得表格行數
return vector.size();
}
public Object getValueAt(int row, int column) { // 取得單元格中的屬性值
if(!vector.isEmpty()) {
return ((Vector)vector.elementAt(row)).elementAt(column);
}
else {
return null;
}
}
public void setValueAt(Object value, int row, int column) { // 數據模型不可編輯，該方法設置為空
}
public String getColumnName(int column) { // 取得表格列名
return title[column];
}
public Class getColumnClass(int c) { // 取得列所屬對象類
return getValueAt(0,c).getClass();
}
public boolean isCellEditable(int row, int column) { // 設置單元格不可編輯，為缺省實現
return false;
}
};
tmm = new AbstractTableModel() { //for informaiton of user borrow book // 創建AbstractTableModel類對象tm
public int getColumnCount() { // 取得表格列數
return titl.length;
}
public int getRowCount() { // 取得表格行數
return vec.size();
}
public Object getValueAt(int row, int column) { // 取得單元格中的屬性值
if(!vec.isEmpty()) {
return ((Vector)vec.elementAt(row)).elementAt(column);
}
else {
return null;
}
}
public void setValueAt(Object value, int row, int column) { // 數據模型不可編輯，該方法設置為空
}
public String getColumnName(int column) { // 取得表格列名
return titl[column];
}
public Class getColumnClass(int c) { // 取得列所屬對象類
return getValueAt(0,c).getClass();
}
public boolean isCellEditable(int row, int column) { // 設置單元格不可編輯，為缺省實現
return false;
}
};
table = new JTable(tm); //for information of books // 生成自己的數據模型
table.setToolTipText("Display Query Result"); // 設置幫助提示
//table.setAutoResizeMode(table.AUTO_RESIZE_OFF); // 設置表格調整尺寸模式
table.setCellSelectionEnabled(false); // 設置單元格選擇方式
table.setShowHorizontalLines(true); // 設置是否顯示單元格之間的分割線
table.setShowVerticalLines(true);
scroll = new JScrollPane(table); // 給表格加上滾動杠
scroll.setBounds(39, 372, 939, 117);
contentPane.add(scroll);////////////////////////////以后恢復
tab = new JTable(tmm); //for informaiton of user borrow book // 生成自己的數據模型
tab.setToolTipText("Display Query Result"); // 設置幫助提示
//tab.setAutoResizeMode(table.AUTO_RESIZE_OFF); // 設置表格調整尺寸模式
tab.setCellSelectionEnabled(false); // 設置單元格選擇方式
tab.setShowHorizontalLines(true); // 設置是否顯示單元格之間的分割線
tab.setShowVerticalLines(true);
scr = new JScrollPane(tab); // 給表格加上滾動杠
scr.setBounds(39, 229, 939, 127);//39, 221, 939, 181
content.add(scr);//////////39, 410, 939, 111//////////////////以后恢復
}
public void jButton1_actionPerformed(ActionEvent e) {
User user=new User();
user.setUserID(jTextField9.getText());
user.setUserPWD(jTextField10.getText());
if(DatabaseQuery.userListQueryForWhetherWright(user))
{
vec.removeAllElements();
DatabaseQuery.userListQueryForInformation(user);
jTextField1.setText(user.getUserName());
jTextField2.setText(user.getUserID());
jTextField3.setText(user.getUserSex());
jTextField4.setText(user.getUserType());
jTextField5.setText(user.getUserDept());
jTextField6.setText(user.getUserEmail());
jTextField7.setText(String.valueOf(user.getSumOfBook()));
jTextField8.setText(String.valueOf(user.getNumOfBook()));
DatabaseQuery.userBorrowViewQueryForInformation(user,vec);
tmm.fireTableStructureChanged();
}
}
public void jButton4_actionPerformed(ActionEvent e) {
UserBook userBook=new UserBook();
try{
userBook.setUserID(jTextField9.getText());
userBook.setUserPWD(jTextField10.getText());
userBook.setBookIndex(Integer.parseInt(jTextField11.getText()));
}
catch(Exception eee)
{
WarningFrame.warningFrame("please input right!");
return;
}
DatabaseProcedure.reborrowBook(userBook);
}
public void jButton3_actionPerformed(ActionEvent e) {
UserBook userBook=new UserBook();
try
{
userBook.setUserID(jTextField9.getText());
userBook.setUserPWD(jTextField10.getText());
userBook.setBookIndex(Integer.parseInt(jTextField11.getText()));
}
catch(Exception eee)
{
WarningFrame.warningFrame("please input right!");
return;
}
DatabaseProcedure.orderBook(userBook);
}
public void jButton2_actionPerformed(ActionEvent e) {
Books book=new Books();
vector.removeAllElements();
if(!jTextField11.getText().equals(""))
{
try{
book.book.setBookIndex(Integer.parseInt(jTextField11.getText()));
}
catch(Exception ee)
{
System.out.println(ee);
}
if(DatabaseQuery.bookInformationQueryForWhetherExistWithIndex(book))
{
DatabaseQuery.bookInformationQueryForInformationWithIndex(book, vector);
//tm.fireTableStructureChanged(); // 更新表格內容
//vector.removeAllElements();
}
}
if(!bookNamejTextField.getText().equals(""))
{
book.setBookName(bookNamejTextField.getText());
if(DatabaseQuery.bookInformationQueryForWhetherExistWithName(book))
{
DatabaseQuery.bookInformationQueryForInformationWithName(book, vector);
}
}
if(!String.valueOf(jComboBox1.getSelectedItem()).equals(""))
{
book.setBookType(String.valueOf(jComboBox1.getSelectedItem()));
System.out.println(book.getBookType());//book.setBookName(jTextField13.getText());
if(DatabaseQuery.bookInformationQueryForWhetherExistWithType(book))
{
DatabaseQuery.bookInformationQueryForInformationWithType(book, vector);
}
}
if(vector.size()==0)
{
WarningFrame.warningFrame("please input one item you want!");
}
else
{
tm.fireTableStructureChanged();
}
}
public void jButton5_actionPerformed(ActionEvent e) {
jTextField1.setText("");
jTextField2.setText("");
jTextField3.setText("");
jTextField4.setText("");
jTextField5.setText("");
jTextField6.setText("");
jTextField7.setText("");
jTextField8.setText("");
jTextField9.setText("");
jTextField10.setText("");
jTextField11.setText("");
bookNamejTextField.setText("");
vec.removeAllElements();
vector.removeAllElements();
tmm.fireTableStructureChanged();
tm.fireTableStructureChanged();
}
public void userBorrowInformationjButton_actionPerformed(ActionEvent e) {
User user=new User();
user.setUserID(jTextField9.getText());
user.setUserPWD(jTextField10.getText());
if(DatabaseQuery.userListQueryForWhetherWright(user))
{
vec.removeAllElements();
DatabaseQuery.userBorrowViewQueryForInformation(user,vec);
tmm.fireTableStructureChanged();
}
}
public void userOrderInformationjButton_actionPerformed(ActionEvent e) {
User user=new User();
user.setUserID(jTextField9.getText());
user.setUserPWD(jTextField10.getText());
if(DatabaseQuery.userListQueryForWhetherWright(user))
{
vec.removeAllElements();
DatabaseQuery.userOrderViewQueryForInformation(user,vec);
tmm.fireTableStructureChanged();
}
}
}
class UserFrame_userOrderInformationjButton_actionAdapter implements
ActionListener {
private UserFrame adaptee;
UserFrame_userOrderInformationjButton_actionAdapter(UserFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.userOrderInformationjButton_actionPerformed(e);
}
}
class UserFrame_userBorrowInformationjButton_actionAdapter implements
ActionListener {
private UserFrame adaptee;
UserFrame_userBorrowInformationjButton_actionAdapter(UserFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.userBorrowInformationjButton_actionPerformed(e);
}
}
class UserFrame_jButton2_actionAdapter implements ActionListener {
private UserFrame adaptee;
UserFrame_jButton2_actionAdapter(UserFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class UserFrame_jButton3_actionAdapter implements ActionListener {
private UserFrame adaptee;
UserFrame_jButton3_actionAdapter(UserFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
class UserFrame_jButton4_actionAdapter implements ActionListener {
private UserFrame adaptee;
UserFrame_jButton4_actionAdapter(UserFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton4_actionPerformed(e);
}
}
class UserFrame_jButton1_actionAdapter implements ActionListener {
private UserFrame adaptee;
UserFrame_jButton1_actionAdapter(UserFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
class UserFrame_jButton5_actionAdapter implements ActionListener {
private UserFrame adaptee;
UserFrame_jButton5_actionAdapter(UserFrame adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton5_actionPerformed(e);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -