?? b--管理員界面.txt
字號:
"已借書籍(4): "+rs1item8_2_7+'\n'+
"已借書籍(5): "+rs1item8_2_8+'\n');
}
}
catch(Exception e)
{
System.err.println(e);
}
}//if 2
else if(jRadioButton7.isSelected())
{
try
{
Statement stmt8_3_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq8_3_1 = "select * from reader order by 宿舍";
ResultSet rs8_3_1 = stmt8_3_1.executeQuery(sq8_3_1);
while(rs8_3_1.next())
{
String rs1item8_3_1 = rs8_3_1.getString("ID");
String rs1item8_3_2 = rs8_3_1.getString("姓名");
String rs1item8_3_3 = rs8_3_1.getString("宿舍");
String rs1item8_3_4 = rs8_3_1.getString("已借書籍");
String rs1item8_3_5 = rs8_3_1.getString("已借書籍2");
String rs1item8_3_6 = rs8_3_1.getString("已借書籍3");
String rs1item8_3_7 = rs8_3_1.getString("已借書籍4");
String rs1item8_3_8 = rs8_3_1.getString("已借書籍5");
jTextArea4.append("ID: "+rs1item8_3_1+'\n'+
"姓名: "+rs1item8_3_2+'\n'+
"宿舍: "+rs1item8_3_3+'\n'+
"已借書籍(1): "+rs1item8_3_4+'\n'+
"已借書籍(2): "+rs1item8_3_5+'\n'+
"已借書籍(3): "+rs1item8_3_6+'\n'+
"已借書籍(4): "+rs1item8_3_7+'\n'+
"已借書籍(5): "+rs1item8_3_8+'\n');
}
}
catch(Exception e)
{
System.err.println(e);
}
}//if 3
else if(jRadioButton8.isSelected())
{
try
{
Statement stmt8_4_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq8_4_1 = "select '總數'=count(ID) from reader";
ResultSet rs8_4_1 = stmt8_4_1.executeQuery(sq8_4_1);
while(rs8_4_1.next())
{
String rs1item8_4_1 = rs8_4_1.getString("總數");
jTextArea4.setText("總共有讀者: "+rs1item8_4_1);
}
}
catch(Exception e)
{
System.err.println(e);
}
}//if 4
else
{
JOptionPane.showMessageDialog(this,"請選擇其中一個","錯誤",JOptionPane.ERROR_MESSAGE);
}
}//F7()
public void jButton16_actionPerformed(ActionEvent e) {
jTextArea4.setText("");
}
}
class Frame1_jButton16_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton16_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton16_actionPerformed(e);
}
}
class Frame1_jButton14_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton14_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton14_actionPerformed(e);
}
}
class Frame1_jButton15_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton15_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton15_actionPerformed(e);
}
}
class Frame1_jButton13_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton13_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton13_actionPerformed(e);
}
}
class Frame1_jRadioButton1_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jRadioButton1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jRadioButton1_actionPerformed(e);
}
}
class Frame1_jButton10_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton10_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton10_actionPerformed(e);
}
}
class Frame1_jButton9_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton9_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton9_actionPerformed(e);
}
}
class Frame1_jButton12_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton12_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton12_actionPerformed(e);
}
}
class Frame1_jButton8_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton8_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton8_actionPerformed(e);
}
}
class Frame1_jButton11_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton11_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton11_actionPerformed(e);
}
}
class Frame1_jButton7_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton7_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton7_actionPerformed(e);
}
}
class Frame1_jButton5_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton5_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton5_actionPerformed(e);
}
}
class Frame1_jButton3_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton3_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton3_actionPerformed(e);
}
}
class Frame1_jButton6_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton6_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton6_actionPerformed(e);
}
}
class Frame1_jButton2_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton2_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton2_actionPerformed(e);
}
}
class Frame1_jButton4_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton4_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton4_actionPerformed(e);
}
}
class Frame1_jButton1_actionAdapter implements ActionListener {
private Frame1 adaptee;
Frame1_jButton1_actionAdapter(Frame1 adaptee) {
this.adaptee = adaptee;
}
public void actionPerformed(ActionEvent e) {
adaptee.jButton1_actionPerformed(e);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -