?? frame1.java~67~
字號:
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"操作失敗","失敗",JOptionPane.ERROR_MESSAGE);
}
}//F5_2()
public void jButton9_actionPerformed(ActionEvent e) {
F5_3();
}
void F5_3()
{
try
{
Statement stmt5_3 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq5_3 = "update book set 借閱情況='未借',借書ID='' where 編號 like 'R%' or 編號 like 'S%' or 編號 like 'T%' or 編號 like 'U%' or 編號 like 'V%' or 編號 like 'W%' or 編號 like 'X%' or 編號 like 'Y%' or 編號 like 'Z%'";
stmt5_3.executeUpdate(sq5_3);
JOptionPane.showMessageDialog(this,"操作成功","成功",JOptionPane.YES_NO_CANCEL_OPTION);
stmt5_3.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"操作失敗","失敗",JOptionPane.ERROR_MESSAGE);
}
}//F5_3()
public void jButton10_actionPerformed(ActionEvent e) {
F6_1();
}
void F6_1()
{
try
{
Statement stmt6_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq6_1 = "update book set 借書ID='' where 編號 like 'A%' or 編號 like 'B%' or 編號 like 'C%' or 編號 like 'D%' or 編號 like 'E%' or 編號 like 'F%' or 編號 like 'G%' or 編號 like 'H%'";
stmt6_1.executeUpdate(sq6_1);
JOptionPane.showMessageDialog(this,"操作成功","成功",JOptionPane.YES_NO_CANCEL_OPTION);
stmt6_1.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"操作失敗","失敗",JOptionPane.ERROR_MESSAGE);
}
}//F6_1()
public void jButton11_actionPerformed(ActionEvent e) {
F6_2();
}
void F6_2()
{
try
{
Statement stmt6_2 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq6_2 = "update book set 借書ID='' where 編號 like 'I%' or 編號 like 'J%' or 編號 like 'K%' or 編號 like 'L%' or 編號 like 'M%' or 編號 like 'N%' or 編號 like 'O%' or 編號 like 'P%' or 編號 like 'Q%'";
stmt6_2.executeUpdate(sq6_2);
JOptionPane.showMessageDialog(this,"操作成功","成功",JOptionPane.YES_NO_CANCEL_OPTION);
stmt6_2.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"操作失敗","失敗",JOptionPane.ERROR_MESSAGE);
}
}//F6_2()
public void jButton12_actionPerformed(ActionEvent e) {
F6_3();
}
void F6_3()
{
try
{
Statement stmt6_3 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq6_3 = "update book set 借書ID='' where 編號 like 'R%' or 編號 like 'S%' or 編號 like 'T%' or 編號 like 'U%' or 編號 like 'V%' or 編號 like 'W%' or 編號 like 'X%' or 編號 like 'Y%' or 編號 like 'Z%'";
stmt6_3.executeUpdate(sq6_3);
JOptionPane.showMessageDialog(this,"操作成功","成功",JOptionPane.YES_NO_CANCEL_OPTION);
stmt6_3.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"操作失敗","失敗",JOptionPane.ERROR_MESSAGE);
}
}//F6_3()
public void jRadioButton1_actionPerformed(ActionEvent e) {
}
public void jButton13_actionPerformed(ActionEvent e) {
F7();
}
void F7()
{
if(jRadioButton1.isSelected()){
try
{
Statement stmt7_2_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq7_2_1 = "select * from book order by 書名";
ResultSet rs7_2_1 = stmt7_2_1.executeQuery(sq7_2_1);
while(rs7_2_1.next())
{
String rs1item7_2_1_1 = rs7_2_1.getString("編號");
String rs1item7_2_1_2 = rs7_2_1.getString("書名");
String rs1item7_2_1_3 = rs7_2_1.getString("作者");
String rs1item7_2_1_4 = rs7_2_1.getString("出版社");
String rs1item7_2_1_5 = rs7_2_1.getString("借閱情況");
jTextArea3.append("編號： "+rs1item7_2_1_1+'\n'+
"書名： "+rs1item7_2_1_2+'\n'+
"作者： "+rs1item7_2_1_3+'\n'+
"出版社： "+rs1item7_2_1_4+'\n'+
"借閱情況： "+rs1item7_2_1_5+'\n'+
"------------------------------------------------------"+'\n');
}
}
catch(Exception e)
{
System.err.println(e);
}
}// if 1
else if(jRadioButton2.isSelected())
{
try
{
Statement stmt7_2_2 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq7_2_2 = "select * from book order by 作者";
ResultSet rs7_2_2 = stmt7_2_2.executeQuery(sq7_2_2);
while(rs7_2_2.next())
{
String rs1item7_2_2_1 = rs7_2_2.getString("編號");
String rs1item7_2_2_2 = rs7_2_2.getString("書名");
String rs1item7_2_2_3 = rs7_2_2.getString("作者");
String rs1item7_2_2_4 = rs7_2_2.getString("出版社");
String rs1item7_2_2_5 = rs7_2_2.getString("借閱情況");
jTextArea3.append("編號： "+rs1item7_2_2_1+'\n'+
"書名： "+rs1item7_2_2_2+'\n'+
"作者： "+rs1item7_2_2_3+'\n'+
"出版社： "+rs1item7_2_2_4+'\n'+
"借閱情況： "+rs1item7_2_2_5+'\n'+
"------------------------------------------------------"+'\n');
}
}
catch(Exception e)
{
System.err.println(e);
}
}//if 2
else if(jRadioButton3.isSelected())
{
try
{
Statement stmt7_2_3 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq7_2_3 = "select * from book order by 出版社";
ResultSet rs7_2_3 = stmt7_2_3.executeQuery(sq7_2_3);
while(rs7_2_3.next())
{
String rs1item7_2_3_1 = rs7_2_3.getString("編號");
String rs1item7_2_3_2 = rs7_2_3.getString("書名");
String rs1item7_2_3_3 = rs7_2_3.getString("作者");
String rs1item7_2_3_4 = rs7_2_3.getString("出版社");
String rs1item7_2_3_5 = rs7_2_3.getString("借閱情況");
jTextArea3.append("編號： "+rs1item7_2_3_1+'\n'+
"書名： "+rs1item7_2_3_2+'\n'+
"作者： "+rs1item7_2_3_3+'\n'+
"出版社： "+rs1item7_2_3_4+'\n'+
"借閱情況： "+rs1item7_2_3_5+'\n'+
"------------------------------------------------------"+'\n');
}
}
catch(Exception e)
{
System.err.println(e);
}
}//if 3
else if(jRadioButton4.isSelected())
{
try
{
Statement stmt7_4_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq7_4_1 = "select '總數(shù)'=count(編號) from book";
ResultSet rs7_4_1 = stmt7_4_1.executeQuery(sq7_4_1);
while(rs7_4_1.next())
{
String rs1item8_4_1 = rs7_4_1.getString("總數(shù)");
jTextArea3.setText("總共有書籍： "+rs1item8_4_1);
}
}
catch(Exception e)
{
System.err.println(e);
}
}//if 4
else
{
JOptionPane.showMessageDialog(this,"請選擇其中一個","錯誤",JOptionPane.ERROR_MESSAGE);
}
}//F7()
public void jButton15_actionPerformed(ActionEvent e) {
jTextArea3.setText("");
}
public void jButton14_actionPerformed(ActionEvent e) {
F8();
}
void F8()
{
if(jRadioButton5.isSelected())
{
try
{
Statement stmt8_1_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq8_1_1 = "select * from reader order by ID";
ResultSet rs8_1_1 = stmt8_1_1.executeQuery(sq8_1_1);
while(rs8_1_1.next())
{
String rs1item8_1_1 = rs8_1_1.getString("ID");
String rs1item8_1_2 = rs8_1_1.getString("姓名");
String rs1item8_1_3 = rs8_1_1.getString("宿舍");
String rs1item8_1_4 = rs8_1_1.getString("已借書籍");
String rs1item8_1_5 = rs8_1_1.getString("已借書籍2");
String rs1item8_1_6 = rs8_1_1.getString("已借書籍3");
String rs1item8_1_7 = rs8_1_1.getString("已借書籍4");
String rs1item8_1_8 = rs8_1_1.getString("已借書籍5");
jTextArea4.append("ID： "+rs1item8_1_1+'\n'+
"姓名： "+rs1item8_1_2+'\n'+
"宿舍： "+rs1item8_1_3+'\n'+
"已借書籍(1)： "+rs1item8_1_4+'\n'+
"已借書籍(2)： "+rs1item8_1_5+'\n'+
"已借書籍(3)： "+rs1item8_1_6+'\n'+
"已借書籍(4)： "+rs1item8_1_7+'\n'+
"已借書籍(5)： "+rs1item8_1_8+'\n' );
}
}
catch(Exception e)
{
System.err.println(e);
}
}// if 1
else if(jRadioButton6.isSelected())
{
try
{
Statement stmt8_2_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq8_2_1 = "select * from reader order by 姓名";
ResultSet rs8_2_1 = stmt8_2_1.executeQuery(sq8_2_1);
while(rs8_2_1.next())
{
String rs1item8_2_1 = rs8_2_1.getString("ID");
String rs1item8_2_2 = rs8_2_1.getString("姓名");
String rs1item8_2_3 = rs8_2_1.getString("宿舍");
String rs1item8_2_4 = rs8_2_1.getString("已借書籍");
String rs1item8_2_5 = rs8_2_1.getString("已借書籍2");
String rs1item8_2_6 = rs8_2_1.getString("已借書籍3");
String rs1item8_2_7 = rs8_2_1.getString("已借書籍4");
String rs1item8_2_8 = rs8_2_1.getString("已借書籍5");
jTextArea4.append("ID： "+rs1item8_2_1+'\n'+
"姓名： "+rs1item8_2_2+'\n'+
"宿舍： "+rs1item8_2_3+'\n'+
"已借書籍(1)： "+rs1item8_2_4+'\n'+
"已借書籍(2)： "+rs1item8_2_5+'\n'+
"已借書籍(3)： "+rs1item8_2_6+'\n'+
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -