📄 frame1.java~68~
字号:
}
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 '总数'=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("总数");
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'+
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -