?? frame1.java~67~
字號:
jPanel3.add(jLabel13, new XYConstraints(32, 264, -1, -1));
jPanel4.add(jButton6, new XYConstraints(335, 258, -1, 65));
jPanel4.add(jLabel15, new XYConstraints(16, 77, -1, -1));
jPanel7.add(jScrollPane1, new XYConstraints(19, 139, 410, 184));
jScrollPane1.getViewport().add(jTextArea3);
jPanel8.add(jScrollPane2, new XYConstraints(17, 128, 409, 206));
jPanel1.add(jTextField4, new XYConstraints(95, 268, 220, 40));
jPanel1.add(jButton1, new XYConstraints(332, 262, 91, 60));
jPanel1.add(jTextField3, new XYConstraints(95, 207, 220, 40));
jPanel1.add(jLabel2, new XYConstraints(27, 159, -1, -1));
jPanel1.add(jLabel1, new XYConstraints(32, 104, -1, -1));
jPanel1.add(jLabel3, new XYConstraints(27, 222, -1, -1));
jPanel1.add(jLabel4, new XYConstraints(27, 281, -1, -1));
jPanel1.add(jTextField2, new XYConstraints(95, 146, 220, 40));
jPanel1.add(jTextField1, new XYConstraints(94, 94, 220, 39));
jScrollPane2.getViewport().add(jTextArea4);
jPanel2.add(jTextArea1, new XYConstraints(12, 112, 295, 215));
jPanel2.add(jTextField5, new XYConstraints(69, 57, 238, 32));
jPanel4.add(jTextArea2, new XYConstraints(15, 130, 313, 193));
jPanel4.add(jButton5, new XYConstraints(341, 77, -1, 32));
jPanel4.add(jTextField10, new XYConstraints(105, 75, 223, 34));
jTabbedPane1.add(jPanel5, "收書服務");
jTabbedPane1.add(jPanel6, "送書服務");
contentPane.add(jTabbedPane1, new XYConstraints(16, 65, 454, 382));
buttonGroup1.add(jRadioButton1);
buttonGroup1.add(jRadioButton2);
buttonGroup1.add(jRadioButton3);
buttonGroup1.add(jRadioButton4);
jPanel7.add(jRadioButton1, new XYConstraints(17, 101, -1, -1));
jPanel7.add(jRadioButton2, new XYConstraints(75, 101, -1, -1));
jPanel7.add(jRadioButton3, new XYConstraints(139, 101, 81, -1));
jPanel7.add(jRadioButton4, new XYConstraints(217, 101, -1, -1));
jPanel7.add(jButton13, new XYConstraints(296, 101, 64, -1));
jPanel7.add(jButton15, new XYConstraints(365, 100, 64, 25));
ButtonGroup buttonGroup2 = new ButtonGroup();
buttonGroup2.add(jRadioButton5);
buttonGroup2.add(jRadioButton6);
buttonGroup2.add(jRadioButton7);
buttonGroup2.add(jRadioButton8);
jPanel8.add(jButton16, new XYConstraints(349, 91, 76, 24));
jPanel8.add(jRadioButton5, new XYConstraints(15, 93, -1, -1));
jPanel8.add(jRadioButton6, new XYConstraints(63, 93, -1, -1));
jPanel8.add(jRadioButton7, new XYConstraints(127, 93, -1, -1));
jPanel8.add(jRadioButton8, new XYConstraints(194, 92, -1, -1));
jPanel8.add(jButton14, new XYConstraints(269, 92, 75, -1));
}
public void jButton1_actionPerformed(ActionEvent e) {
F1();
}
void F1()
{
try{
String str1,str2,str3,str4;
str1=jTextField1.getText();
str2=jTextField2.getText();
str3=jTextField3.getText();
str4=jTextField4.getText();
Statement stmt1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq1 = "INSERT into reader values("+str1+",'"+str2+"','"+str3+"','未借','未借','未借','未借','未借',"+str4+")";
stmt1.executeUpdate(sq1);
JOptionPane.showMessageDialog(this,"增加讀者ID成功","成功",JOptionPane.YES_NO_CANCEL_OPTION);
stmt1.close();
}
catch(Exception e)
{
System.err.println(e);
JOptionPane.showMessageDialog(this,"輸入的信息ID重復，類型不對或者為空","錯誤",JOptionPane.ERROR_MESSAGE);
}
} //F1();
void closeWindow(WindowEvent e)
{
int intok = JOptionPane.showConfirmDialog(this,"確定要退出系統嗎？","提示",JOptionPane.OK_OPTION);
if(intok == 0)
{
try{
}
catch(Exception e1)
{
System.out.println("can't to close"+e1);
}
System.exit(0);
}
else
{return;}
}
public void jButton4_actionPerformed(ActionEvent e) {
F3();
}
void F3()
{
try{
String str1,str2,str3,str4;
str1=jTextField6.getText();
str2=jTextField7.getText();
str3=jTextField8.getText();
str4=jTextField9.getText();
Statement stmt3 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq1 = "INSERT into book values('"+str1+"','"+str2+"','"+str3+"','"+str4+"','未借','')";
stmt3.executeUpdate(sq1);
JOptionPane.showMessageDialog(this,"增加書籍成功","成功",JOptionPane.YES_NO_CANCEL_OPTION);
stmt3.close();
}
catch(Exception e)
{
System.err.println(e);
JOptionPane.showMessageDialog(this,"輸入的信息書籍編號重復，類型不對或者為空","錯誤",JOptionPane.ERROR_MESSAGE);
}
} //F1();
public void jButton2_actionPerformed(ActionEvent e) {
F2_1();
}
void F2_1(){
try{
String str2_1;
str2_1=jTextField5.getText();
Statement stmt2_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq2_1 = "select * from reader where ID='"+str2_1+"'";
ResultSet rs2_1 = stmt2_1.executeQuery(sq2_1);
if(rs2_1.next())
{
String rs1item2_1_1 = rs2_1.getString("ID");
String rs1item2_1_2 = rs2_1.getString("姓名");
String rs1item2_1_3 = rs2_1.getString("宿舍");
String rs1item2_1_4 = rs2_1.getString("已借書籍");
String rs1item2_1_5 = rs2_1.getString("已借書籍2");
String rs1item2_1_6 = rs2_1.getString("已借書籍3");
String rs1item2_1_7 = rs2_1.getString("已借書籍4");
String rs1item2_1_8 = rs2_1.getString("已借書籍5");
jTextArea1.setText("ID： "+rs1item2_1_1+'\n'+
"姓名： "+rs1item2_1_2+'\n'+
"宿舍： "+rs1item2_1_3+'\n'+
"已借書籍： "+rs1item2_1_4+'\n'+
"已借書籍2： "+rs1item2_1_5+'\n'+
"已借書籍3： "+rs1item2_1_6+'\n'+
"已借書籍4： "+rs1item2_1_7+'\n'+
"已借書籍5： "+rs1item2_1_8+'\n');
stmt2_1.close();
}
else
{
JOptionPane.showMessageDialog(this,"輸入的ID不正確","錯誤",JOptionPane.ERROR_MESSAGE);
stmt2_1.close();
}
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"輸入的ID不正確","錯誤",JOptionPane.ERROR_MESSAGE);
}
}//F2_1()
public void jButton3_actionPerformed(ActionEvent e) {
F2_2();
}
void F2_2()
{
try{
String str2_2_1;
str2_2_1=jTextField5.getText();
Statement stmt2_2 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq2_2 = "DELETE FROM reader WHERE ID='"+str2_2_1+"'";
stmt2_2.executeUpdate(sq2_2);
JOptionPane.showMessageDialog(this,"刪除成功","成功",JOptionPane.YES_NO_CANCEL_OPTION);
stmt2_2.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"刪除失敗","失敗",JOptionPane.ERROR_MESSAGE);
}
}//F2_2
public void jButton5_actionPerformed(ActionEvent e) {
F4_1();
}
void F4_1(){
try{
String str4_1;
str4_1=jTextField10.getText();
Statement stmt4_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq4_1 = "select * from book where 編號='"+str4_1+"'";
ResultSet rs4_1 = stmt4_1.executeQuery(sq4_1);
if(rs4_1.next())
{
String rs1item4_1_1 = rs4_1.getString("編號");
String rs1item4_1_2 = rs4_1.getString("書名");
String rs1item4_1_3 = rs4_1.getString("作者");
String rs1item4_1_4 = rs4_1.getString("出版社");
String rs1item4_1_5 = rs4_1.getString("借閱情況");
String rs1item4_1_6 = rs4_1.getString("借書ID");
jTextArea2.setText("編號： "+rs1item4_1_1+'\n'+
"書名： "+rs1item4_1_2+'\n'+
"作者： "+rs1item4_1_3+'\n'+
"出版社： "+rs1item4_1_4+'\n'+
"借閱情況： "+rs1item4_1_5+'\n'+
"借書ID： "+rs1item4_1_6+'\n' );
stmt4_1.close();
}
else
{
JOptionPane.showMessageDialog(this,"輸入的書籍編號不正確","錯誤",JOptionPane.ERROR_MESSAGE);
stmt4_1.close();
}
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"輸入的書籍編號不正確","錯誤",JOptionPane.ERROR_MESSAGE);
}
}//F4_1()
public void jButton6_actionPerformed(ActionEvent e) {
F4_2();
}
void F4_2()
{
try{
String str4_2_1;
str4_2_1=jTextField10.getText();
Statement stmt4_2 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq4_2 = "DELETE FROM book WHERE ID='"+str4_2_1+"'";
stmt4_2.executeUpdate(sq4_2);
JOptionPane.showMessageDialog(this,"刪除成功","成功",JOptionPane.YES_NO_CANCEL_OPTION);
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"刪除失敗","失敗",JOptionPane.ERROR_MESSAGE);
}
}
public void jButton7_actionPerformed(ActionEvent e) {
F5_1();
}
void F5_1()
{
try
{
Statement stmt5_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq5_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%'";
stmt5_1.executeUpdate(sq5_1);
JOptionPane.showMessageDialog(this,"操作成功","成功",JOptionPane.YES_NO_CANCEL_OPTION);
stmt5_1.close();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(this,"操作失敗","失敗",JOptionPane.ERROR_MESSAGE);
}
}//F51()
public void jButton8_actionPerformed(ActionEvent e) {
F5_2();
}
void F5_2()
{
try
{
Statement stmt5_2 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq5_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%'";
stmt5_2.executeUpdate(sq5_2);
JOptionPane.showMessageDialog(this,"操作成功","成功",JOptionPane.YES_NO_CANCEL_OPTION);
stmt5_2.close();
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -