📄 paper.java
字号:
p1.setBorder(BorderFactory.createTitledBorder("在你想查询的相应模块输入信息"));
JLabel l1=new JLabel("输入姓名");
final JTextField t1=new JTextField();
JButton b1= new JButton("姓名查询") ;
JLabel l2=new JLabel("输入订单号");
final JTextField t2=new JTextField();
JButton b2= new JButton("订单号查询") ;
b1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("姓名查询"))
{//响应事件
String str=t1.getText();
dataBase();
try { //执行SQL语句
String query ="SELECT* FROM person where pname"+"='"+str+"';"; //接受输入的sql语句
statement = connection.createStatement();
resultSet = statement.executeQuery( query );
displayResultSet( resultSet);
}catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
}
}
});
b2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("订单号查询"))
{//响应事件
int str=Integer.parseInt(t2.getText());
dataBase();
try { //执行SQL语句
String query ="SELECT* FROM person where userNum"+"="+str+";"; //接受输入的sql语句
statement = connection.createStatement();
resultSet = statement.executeQuery( query );
displayResultSet( resultSet);
}catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
}
}
});
JButton cal=new JButton("取消");
cal.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("取消"))
{ f.dispose();
}
}
});
p1.add(l1);//
p1.add(t1);//文本
p1.add(b1);
p1.add(l2);//
p1.add(t2);
p1.add(b2);
p1.add(cal);
contentPane.add(p1);
f.setLocation(400,300);
f.setSize(300,150);
//f.pack();
f.show();
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
f.dispose();
}
});
}
////////////////////////////////////////////////////////报刊刊名查询
public void finding()
{
final JFrame f=new JFrame("按报刊名查询");
Container contentPane=f.getContentPane();
contentPane.setLayout(new BorderLayout());
JPanel p1=new JPanel();
p1.setLayout(new GridLayout(2,3));
p1.setBorder(BorderFactory.createTitledBorder("输入报刊名"));
JLabel l1=new JLabel("报刊名");
final JTextField t1=new JTextField();
JButton que=new JButton("确定");
que.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("确定"))
{//响应事件
String str=t1.getText();
dataBase();
try { //执行SQL语句
String query ="SELECT* FROM paper where pname"+"='"+str+"';"; //接受输入的sql语句
statement = connection.createStatement();
resultSet = statement.executeQuery( query );
displayResultSet( resultSet);
}catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
}
}
});
JButton cal=new JButton("取消");
cal.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("取消"))
{ f.dispose();
}
}
});
p1.add(l1);//
p1.add(t1);//文本
p1.add(que);
p1.add(cal);
contentPane.add(p1);
f.setLocation(400,300);
f.setSize(200,130);
//f.pack();
f.show();
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
f.dispose();
}
});
}
/////////////////////////////////////////////////////////////////////////////部门查询
public void departmentFind()
{
final JFrame f=new JFrame("按部门信息查询");
Container contentPane=f.getContentPane();
contentPane.setLayout(new BorderLayout());
JPanel p1=new JPanel();
p1.setLayout(new GridLayout(4,3));
p1.setBorder(BorderFactory.createTitledBorder("在你想查询的相应模块输入信息"));
JLabel l1=new JLabel("输入公司编号");
final JTextField t1=new JTextField();
JButton b1= new JButton("公司编号查询");
JLabel l2=new JLabel("输入订单号");
final JTextField t2=new JTextField();
JButton b2= new JButton("订单号查询") ;
JLabel l3=new JLabel("输入部门名");
final JTextField t3=new JTextField();
JButton b3= new JButton("部门查询");
b1.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("公司编号查询"))
{//响应事件
String str=t1.getText();
dataBase();
try { //执行SQL语句
String query ="SELECT* FROM department where companyNum"+"="+str+";"; //接受输入的sql语句
statement = connection.createStatement();
resultSet = statement.executeQuery( query );
displayResultSet( resultSet);
}catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
}
}
});
b2.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("订单号查询"))
{//响应事件
int str=Integer.parseInt(t2.getText());
dataBase();
try { //执行SQL语句
String query ="SELECT* FROM department where bookNum"+"="+str+";"; //接受输入的sql语句
statement = connection.createStatement();
resultSet = statement.executeQuery( query );
displayResultSet( resultSet);
}catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
}
}
});
b3.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("部门查询"))
{//响应事件
String str=t3.getText();
dataBase();
try { //执行SQL语句
String query ="SELECT* FROM departmentnew where 部门名"+"='"+str+"';"; //接受输入的sql语句
statement = connection.createStatement();
resultSet = statement.executeQuery( query );
displayResultSet( resultSet);
}catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
}
}
});
JButton cal=new JButton("取消");
cal.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("取消"))
{ f.dispose();
}
}
});
p1.add(l1);//
p1.add(t1);//文本
p1.add(b1);
p1.add(l2);//
p1.add(t2);
p1.add(b2);
p1.add(l3);//
p1.add(t3);
p1.add(b3);
p1.add(cal);
contentPane.add(p1);
f.setLocation(400,300);
f.setSize(350,200);
f.show();
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
f.dispose();
}
});
}
/////////////////////////////////////////////////////////////////////////////////个人定阅
public void pbook()
{
final JFrame f=new JFrame("报刊订阅");
Container contentPane=f.getContentPane();
contentPane.setLayout(new BorderLayout());
JPanel p1=new JPanel();
p1.setLayout(new GridLayout(6,2));
p1.setBorder(BorderFactory.createTitledBorder("输入下列信息"));
JLabel l1=new JLabel("用户号");
final JTextField t1=new JTextField();
JLabel l2=new JLabel("报刊号");
final JTextField t2=new JTextField();
JLabel l3=new JLabel("定购数量");
final JTextField t3=new JTextField();
JLabel l4=new JLabel("订阅期限");
final JTextField t4=new JTextField();
JLabel l5=new JLabel("订阅日期");
final JTextField t5=new JTextField();
JButton que=new JButton("确定");
que.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("确定"))
{//响应事件
int userNum=0,amount=0,btime=0,s=0,pf=0;
String Pnumber,atime,p="",ppp="";
userNum=Integer.parseInt(t1.getText());//
Pnumber=t2.getText();
amount =Integer.parseInt(t3.getText());
btime=Integer.parseInt(t4.getText());
String ff=t5.getText();
dataBase();
try { //执行SQL语句
String query ="SELECT userNum ,Pnumber FROM pbook"; //接受输入的sql语句
statement = connection.createStatement();
resultSet = statement.executeQuery( query );
while(resultSet.next())
{
s=resultSet.getInt("userNum");
p=resultSet.getString("Pnumber");
if(userNum==s&&(Pnumber.equals(p)))//当输入的订单号与数据库中的相同
{
JFrame pp=new JFrame("");
String title="错误提示信息";
int type=JOptionPane.PLAIN_MESSAGE;
type=JOptionPane.INFORMATION_MESSAGE;
String message="你已经订阅过了该报";
JOptionPane.showMessageDialog(f,message,title,type);
pp.setLocation(400,400);
}
else{
String cha ="SELECT total FROM paper";//找报纸数量
resultSet = statement.executeQuery(cha );
while(resultSet.next())
{
pf=resultSet.getInt("total");
}
if(pf>amount)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -