📄 3.查询.txt
字号:
package library;
import java.awt.BorderLayout;
import java.awt.Dimension;
import java.util.Vector;
import java.lang.String;
import javax.swing.JFrame;
import javax.swing.JPanel;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.JLabel;
import java.awt.Font;
import javax.swing.JButton;
import javax.swing.JTextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import java.lang.*;
import javax.swing.JTextArea;
import javax.swing.JOptionPane;
import javax.swing.JPasswordField;
import javax.swing.JEditorPane;
import javax.swing.JCheckBox;
import javax.swing.*;
import javax.swing.DebugGraphics;
import java.awt.Color;
public class Frame3 extends JFrame
{
JPanel contentPane;
XYLayout xYLayout1 = new XYLayout();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JButton jButton1 = new JButton();
JTextField jTextField2 = new JTextField();
JTextField jTextField3 = new JTextField();
Connection conn;
JTextArea jTextArea1 = new JTextArea();
JButton jButton3 = new JButton();
JButton jButton4 = new JButton();
JTextField jTextField4 = new JTextField();
JLabel jLabel4 = new JLabel();
JLabel jLabel5 = new JLabel();
JPasswordField jPasswordField1 = new JPasswordField();
JButton jButton5 = new JButton();
JScrollPane jScrollPane1 = new JScrollPane();//为jTextArea1增加滚动条
JButton jButton6 = new JButton();
JLabel jLabel1 = new JLabel();
JTextField jTextField1 = new JTextField();
JButton jButton2 = new JButton();
public Frame3()
{
try {
setDefaultCloseOperation(DISPOSE_ON_CLOSE);
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String connURL ="jdbc:odbc:library";
String user = "sa";
String pw = "123";
conn=DriverManager.getConnection(connURL,user,pw);
}
catch(Exception e)
{
System.out.println("class no found can not connect to sql server"+e);
}
contentPane = (JPanel) getContentPane();
contentPane.setLayout(xYLayout1);
setSize(new Dimension(380, 400));
setTitle("查询界面");
jLabel2.setFont(new java.awt.Font("Dialog", Font.BOLD, 12));
jLabel2.setText("作者");
jLabel3.setFont(new java.awt.Font("Dialog", Font.BOLD, 12));
jLabel3.setText("出版社");
jButton1.setText("查询");
jButton1.addActionListener(new Frame3_jButton1_actionAdapter(this));
jTextArea1.setDebugGraphicsOptions(DebugGraphics.LOG_OPTION);
jTextArea1.setWrapStyleWord(true);
jButton3.setText("查询");
jButton3.addActionListener(new Frame3_jButton3_actionAdapter(this));
jButton4.setText("查询");
jButton4.addActionListener(new Frame3_jButton4_actionAdapter(this));
jLabel4.setText("ID");
jTextField3.addActionListener(new Frame3_jTextField3_actionAdapter(this));
jTextField4.setToolTipText("");
jLabel5.setText("密码");
jButton5.setText("书籍信息综合查询");
jButton5.addActionListener(new Frame3_jButton5_actionAdapter(this));
jButton6.setText("清空");
jButton6.addActionListener(new Frame3_jButton6_actionAdapter(this));
jLabel1.setFont(new java.awt.Font("Dialog", Font.BOLD, 12));
jLabel1.setText("书名");
jButton2.setText("查询");
jButton2.addActionListener(new Frame3_jButton2_actionAdapter(this));
contentPane.setNextFocusableComponent(null);
jScrollPane1.getViewport().setBackground(Color.white);
contentPane.add(jLabel2, new XYConstraints(13, 46, -1, -1));
contentPane.add(jLabel3, new XYConstraints(5, 79, -1, -1));
contentPane.add(jTextField2, new XYConstraints(53, 42, 162, 28));
contentPane.add(jTextField3, new XYConstraints(53, 73, 162, 28));
contentPane.add(jTextField4, new XYConstraints(53, 130, 162, 28));
contentPane.add(jLabel4, new XYConstraints(16, 131, 29, 22));
contentPane.add(jLabel5, new XYConstraints(16, 164, -1, -1));
contentPane.add(jPasswordField1, new XYConstraints(53, 161, 162, 30));
contentPane.add(jLabel1, new XYConstraints(12, 14, -1, -1));
contentPane.add(jTextField1, new XYConstraints(53, 8, 161, 27));
contentPane.add(jButton5, new XYConstraints(67, 103, 136, -1));
contentPane.add(jButton1, new XYConstraints(237, 147, 56, 30));
contentPane.add(jButton3, new XYConstraints(245, 45, 60, 24));
contentPane.add(jButton4, new XYConstraints(245, 78, 60, 24));
contentPane.add(jButton2, new XYConstraints(245, 10, 61, 24));
contentPane.add(jButton6, new XYConstraints(304, 148, 56, 29));
contentPane.add(jTextArea1, new XYConstraints(27, 216, -1, -1));
contentPane.add(jScrollPane1, new XYConstraints(17, 204, 315, 172));
}
public void jButton1_actionPerformed(ActionEvent e)
{
F3_5();
}
void F3_5()
{
try
{
String str3_5_1,str3_5_2;
str3_5_1= jTextField4.getText();
str3_5_2=new String(jPasswordField1.getPassword());
Statement stmt3_5_1 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq3_5_1= "select * from reader where ID='"+str3_5_1+"' AND 密码 = '"+str3_5_2+"'";
ResultSet rs3_5_1 = stmt3_5_1.executeQuery(sq3_5_1);
if (!rs3_5_1.next())
{
JOptionPane.showMessageDialog(this,"帐户或者密码错误","错误",JOptionPane.ERROR_MESSAGE);
}
else{
try{
Statement stmt3_5_2 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq3_5_2 ="select * from reader where ID = '"+str3_5_1+"'";
ResultSet rs3_5_2 = stmt3_5_2.executeQuery(sq3_5_2);
if(rs3_5_2.next())
{
String rs1item3_5_2_1 = rs3_5_2.getString("ID");
String rs1item3_5_2_2 = rs3_5_2.getString("姓名");
String rs1item3_5_2_3 = rs3_5_2.getString("宿舍");
String rs1item3_5_2_4 = rs3_5_2.getString("已借书籍");
String rs1item3_5_2_5 = rs3_5_2.getString("已借书籍2");
String rs1item3_5_2_6 = rs3_5_2.getString("已借书籍3");
String rs1item3_5_2_7 = rs3_5_2.getString("已借书籍4");
String rs1item3_5_2_8 = rs3_5_2.getString("已借书籍5");
jTextArea1.append("ID： "+rs1item3_5_2_1+'\n'+
"姓名： "+rs1item3_5_2_2+'\n'+
"宿舍： "+rs1item3_5_2_3+'\n'+
"已借书籍(1)： "+rs1item3_5_2_4+'\n'+
"已借书籍(2)： "+rs1item3_5_2_5+'\n'+
"已借书籍(3)： "+rs1item3_5_2_6+'\n'+
"已借书籍(4)： "+rs1item3_5_2_7+'\n'+
"已借书籍(5)： "+rs1item3_5_2_8+'\n');
}
}
catch(Exception e)
{
System.err.println(e);
}
} ///else
}
catch(Exception e)
{
System.err.println(e);
}
}
public void jButton3_actionPerformed(ActionEvent e)
{
F3_2();
}
void F3_2()
{
try
{
String str3_2;
str3_2=jTextField2.getText();
Statement stmt3_2 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq3_2 = "select * from book where 作者 = '"+str3_2+"'";
ResultSet rs3_2 = stmt3_2.executeQuery(sq3_2);
if(rs3_2.next())
{
//JOptionPane.showMessageDialog(this,"找到相关书籍","错误",JOptionPane.ERROR_MESSAGE);
String rs1item3_2_1 = rs3_2.getString("编号");
String rs1item3_2_2 = rs3_2.getString("书名");
String rs1item3_2_3 = rs3_2.getString("作者");
String rs1item3_2_4 = rs3_2.getString("出版社");
String rs1item3_2_5 = rs3_2.getString("借阅情况");
jTextArea1.append("编号： "+rs1item3_2_1+'\n'+
"书名： "+rs1item3_2_2+'\n'+
"作者： "+rs1item3_2_3+'\n'+
"出版社： "+rs1item3_2_4+'\n'+
"借阅情况： "+rs1item3_2_5+'\n'+
"未借：您可以借书"+'\n'+
"送书：书籍已经被其他读者所借"+'\n'+
"收书：管理员还没有从读者收回书籍"+'\n'+
"------------------------------------------------------"+'\n');
while(rs3_2.next())
{
jTextArea1.append("编号： "+rs1item3_2_1+'\n'+
"书名： "+rs1item3_2_2+'\n'+
"作者： "+rs1item3_2_3+'\n'+
"出版社： "+rs1item3_2_4+'\n'+
"借阅情况： "+rs1item3_2_5+'\n'+
"未借：您可以借书"+'\n'+
"送书：书籍已经被其他读者所借"+'\n'+
"收书：管理员还没有从读者收回书籍"+'\n'+
"------------------------------------------------------"+'\n');
}
}
else
{
JOptionPane.showMessageDialog(this,"没有找到相关书籍","错误",JOptionPane.ERROR_MESSAGE);
}
}
catch(Exception e)
{
System.err.println(e);
}
} //F3_2()
public void jButton4_actionPerformed(ActionEvent e)
{
F3_3();
}
void F3_3(){
try
{
String str3_3;
str3_3 = jTextField3.getText();
Statement stmt3_3 = conn.createStatement(ResultSet.
TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sq3_3 = "select * from book where 出版社 like '%"+str3_3+"%'";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -