?? selectreader.java
字號:
package client;
import java.awt.Color;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.ScrollPaneConstants;
import javax.swing.WindowConstants;
import com.swtdesigner.SwingResourceManager;
import sever.business.iface.ILibrarianInfoIface;
import sever.business.iface.IReaderIface;
import sever.business.impl.IlibrarianInfoImpl;
import sever.business.impl.ReaderImpl;
import sever.dao.BorrowInfoDAO;
import sever.dao.ReaderInfoDAO;
import sever.entity.BookInfo;
import sever.entity.ReaderInfo;
public class SelectReader extends JFrame {
/**
* Launch the application
* @param args
*/
ImageIcon img=new ImageIcon("E:\\image\\1.JPG");
ImageIcon img1=new ImageIcon("E:\\image\\2.JPG");
ImageIcon img2=new ImageIcon("E:\\image\\4.JPG");
ImageIcon img3=new ImageIcon("E:\\image\\1.JPG");
// public static void main(String args[]) {
// try {
// SelectReader frame = new SelectReader();
// frame.setVisible(true);
// } catch (Exception e) {
// e.printStackTrace();
// }
// }
/**
* Create the frame
*/
public SelectReader() {
super();
setIconImage(SwingResourceManager.getImage(SelectReader.class, "/LOGO.jpg"));
getContentPane().setBackground(new Color(224, 235, 237));
getContentPane().setLayout(null);
setBounds(190, 135, 426,325);
setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);
setTitle("讀者查詢");
final JLabel label = new JLabel();
label.setFont(new Font("@黑體", Font.PLAIN, 14));
label.setText("按姓名：");
label.setBounds(24, 31, 56, 28);
getContentPane().add(label);
final JTextField textField = new JTextField();
textField.setBounds(86, 35, 147, 21);
getContentPane().add(textField);
final JLabel label_1 = new JLabel();
label_1.setFont(new Font("@黑體", Font.PLAIN, 14));
label_1.setText("按編號：");
label_1.setBounds(24, 76, 56, 21);
getContentPane().add(label_1);
final JTextField textField_1 = new JTextField();
textField_1.setBounds(86, 76, 147, 21);
getContentPane().add(textField_1);
final JScrollPane scrollPane1 = new JScrollPane();
scrollPane1.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
scrollPane1.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
scrollPane1.setBounds(32, 156, 364, 79);
getContentPane().add(scrollPane1);
final JButton button = new JButton();
button.setFont(new Font("@黑體", Font.PLAIN, 14));
button.setText("確認");
button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if(textField.getText().length()==0){
JOptionPane.showMessageDialog(null,"請輸入編號");
}
else{
try {
ReaderInfo reader=new ReaderInfo();
reader.setReaderName(textField.getText().trim());
ReaderInfoDAO bif = new ReaderInfoDAO();
IReaderIface face=new ReaderImpl();
ResultSet rs=face.ReaderName(reader);
ResultSetMetaData rsm=rs.getMetaData();
int count=rsm.getColumnCount();
Vector row=new Vector();
while(rs.next()){
Vector cell=new Vector();
cell.addElement(rs.getString(1));
cell.addElement(rs.getInt(2));
cell.addElement(rs.getInt(3));
cell.addElement(rs.getString(4));
cell.addElement(rs.getString(5));
cell.addElement(rs.getString(6));
cell.addElement(rs.getString(7));
cell.addElement(rs.getString(8));
cell.addElement(rs.getInt(9));
row.addElement(cell);
String []h={"姓名","編號","年齡","職業","性別","地址","電話","Email/QQ","余額"};
Vector hh=new Vector();
hh.addElement("姓名");
hh.addElement("編號");
hh.addElement("年齡");
hh.addElement("職業");
hh.addElement("性別");
hh.addElement("地址");
hh.addElement("電話");
hh.addElement("Email/QQ");
hh.addElement("余額");
final JTable table = new JTable(row,hh);
scrollPane1.setViewportView(table);
table.setEnabled(false);
}
} catch (SQLException e1) {
e1.printStackTrace();
}
}
}
});
button.setBounds(273, 33, 73, 25);
getContentPane().add(button);
final JScrollPane scrollPane = new JScrollPane();
scrollPane.setVerticalScrollBarPolicy(ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS);
scrollPane.setHorizontalScrollBarPolicy(ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);
scrollPane.setBounds(32, 156, 364, 79);
getContentPane().add(scrollPane);
final JButton button_1 = new JButton();
button_1.setFont(new Font("@黑體", Font.PLAIN, 14));
button_1.setText("確認");
button_1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
if(textField_1.getText().length()==0){
JOptionPane.showMessageDialog(null,"請輸入讀者名");
}
else{
try{
ReaderInfo reader=new ReaderInfo();
reader.setReaderId(Integer.parseInt(textField_1.getText().trim()));
ReaderInfoDAO bif = new ReaderInfoDAO();
IReaderIface face=new ReaderImpl();
ResultSet rs=face.ReadNuber(reader);
ResultSetMetaData rsm=rs.getMetaData();
int count=rsm.getColumnCount();
Vector row=new Vector();
while(rs.next()){
Vector cell=new Vector();
cell.addElement(rs.getString(1));
cell.addElement(rs.getInt(2));
cell.addElement(rs.getInt(3));
cell.addElement(rs.getString(4));
cell.addElement(rs.getString(5));
cell.addElement(rs.getString(6));
cell.addElement(rs.getString(7));
cell.addElement(rs.getString(8));
cell.addElement(rs.getInt(9));
row.addElement(cell);
String []h={"姓名","編號","年齡","職業","性別","地址","電話","Email/QQ","余額"};
Vector hh=new Vector();
hh.addElement("姓名");
hh.addElement("編號");
hh.addElement("年齡");
hh.addElement("職業");
hh.addElement("性別");
hh.addElement("地址");
hh.addElement("電話");
hh.addElement("Email/QQ");
hh.addElement("余額");
final JTable table = new JTable(row,hh);
scrollPane.setViewportView(table);
}
} catch (SQLException e1) {
e1.printStackTrace();
}
}
}
});
button_1.setBounds(273, 74, 73, 25);
getContentPane().add(button_1);
final JLabel label_2 = new JLabel();
label_2.setFont(new Font("@黑體", Font.PLAIN, 14));
label_2.setText("查詢結果");
label_2.setBounds(24, 116, 66, 21);
getContentPane().add(label_2);
final JButton button_2 = new JButton();
button_2.setFont(new Font("@黑體", Font.PLAIN, 14));
button_2.setText("重置");
button_2.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
textField_1.setText("");
textField.setText("");
}
});
button_2.setBounds(86, 241, 66, 25);
getContentPane().add(button_2);
final JButton button_3 = new JButton();
button_3.setFont(new Font("@黑體", Font.PLAIN, 14));
button_3.setText("退出");
button_3.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
dispose();
}
});
button_3.setBounds(273, 241, 66, 25);
getContentPane().add(button_3);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -