📄 wangui.java
字号:
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
class Find5 extends JFrame implements ActionListener
{ JLabel l2;
JTextField tf1;
JButton bt5,bt6,bt7;
JPanel p3,p4;
Container c2=null;
String sno,r1,r2,r3,r4,r5,r6,r7,r8;
Find5()
{ super("查询模块");
c2=getContentPane();
p3=new JPanel();
l2=new JLabel("请输入你要查询的学生学号:");
l2.setForeground(Color.BLUE);
l2.setFont(new Font("BOLD",Font.BOLD,28));
p3.add(l2);
tf1=new JTextField(10);
p3.add(tf1);
c2.add(p3,BorderLayout.CENTER);
p4=new JPanel();
p4.setLayout(new FlowLayout());
bt5=new JButton("确定");
bt6=new JButton("清除");
bt7=new JButton("退出");
p4.add(bt5);
p4.add(bt6);
p4.add(bt7);
c2.add(p4,BorderLayout.SOUTH);
bt5.addActionListener(this);
bt6.addActionListener(this);
bt7.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{ try{ if(e.getSource()==bt5)
{ try{ sno=tf1.getText();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=DriverManager.getConnection("jdbc:odbc:宿舍管理","df","1234");
String str="select * from late where sno='"+sno+"'";
PreparedStatement ps=cn.prepareStatement(str);
ResultSet rs=ps.executeQuery();
System.out.println("sno="+sno);
if(rs.next()) { r1=rs.getString("sno");
r2=rs.getString("sname");
r3=rs.getString("ssex");
r4=rs.getString("sdept");
r5=rs.getString("dno");
r6=rs.getString("dnum");
r7=rs.getString("lreason");
r8=rs.getString("ltime");
findt ud=new findt(this);
ud.setVisible(true);
}
else { JOptionPane.showMessageDialog(null,"您输入的学号有误，请重新输入","输入错误",JOptionPane.YES_NO_OPTION);
}
cn.close();
}
catch(SQLException g)
{ System.out.println("Error Code:"+g.getErrorCode());
System.out.println("Message="+g.getMessage());
}
catch(Exception f)
{ f.printStackTrace();
}
}
if(e.getSource()==bt6)
{ tf1.setText("");
tf1.repaint();
}
if(e.getSource()==bt7)
{ System.exit(0);
}
}
catch(NumberFormatException ex)
{ JOptionPane.showMessageDialog(null,"数据转换错误!"); }
}
class findt extends JFrame implements ActionListener
{ JTextField tt1,tt2,tt3,tt4,tt5,tt6,tt7,tt8;
JButton b1;
Find5 parent2;
findt(Find5 f2)
{ super("学生信息");
parent2=f2;
Container cc=getContentPane();
setBackground(new Color(215,215,215));
cc.setLayout(new GridLayout(3,1));
tt1=new JTextField(r1);
tt2=new JTextField(r2);
tt3=new JTextField(r3);
tt4=new JTextField(r4);
tt5=new JTextField(r5);
tt6=new JTextField(r6);
tt7=new JTextField(r7);
tt8=new JTextField(r8);
tt1.setEditable(false);
tt2.setEditable(false);
tt3.setEditable(false);
tt4.setEditable(false);
tt5.setEditable(false);
tt6.setEditable(false);
tt7.setEditable(false);
tt8.setEditable(false);
JPanel pp1=new JPanel();
pp1.add(new JLabel("学号为"+sno+"学生的学生信息"));
cc.add(pp1);
JPanel pp2=new JPanel();
pp2.add(new JLabel("学号",SwingConstants.CENTER));
tt1.setText(sno);
pp2.add(tt1);
pp2.add(new JLabel("姓名",SwingConstants.CENTER));
pp2.add(tt2);
pp2.add(new JLabel("性别",SwingConstants.CENTER));
pp2.add(tt3);
pp2.add(new JLabel("院系",SwingConstants.CENTER));
pp2.add(tt4);
pp2.add(new JLabel("宿舍号",SwingConstants.CENTER));
pp2.add(tt5);
pp2.add(new JLabel("宿舍电话",SwingConstants.CENTER));
pp2.add(tt6);
pp2.add(new JLabel("晚归原因",SwingConstants.CENTER));
pp2.add(tt7);
pp2.add(new JLabel("晚归时间",SwingConstants.CENTER));
pp2.add(tt8);
cc.add(pp2);
JPanel pp3=new JPanel(new FlowLayout());
b1=new JButton("返回");
b1.addActionListener(this);
pp3.add(b1);
cc.add(pp3);
this.setSize(400,300);
}
public void actionPerformed(ActionEvent f)
{if(f.getSource()==b1)
{ shutdown2();}
}
public void shutdown2()
{ parent2.setVisible(true);
this.dispose();
}
}
}
class Insert5 extends JFrame implements ActionListener
{ JLabel l3;
JTextField tf2,tf3,tf4,tf5,tf6,tf7,tf8,tf9;
JButton bt8,bt9,bt10;
JPanel p5,p6;
String sno,sname,ssex,sdept,dno,dnum,lreason,ltime;
Container c3=null;
public Insert5()
{ super("添加模块");
c3=getContentPane();
c3.setLayout(new GridLayout(3,1));
p5=new JPanel(new GridLayout(8,2));
p6=new JPanel(new FlowLayout());
l3=new JLabel("学生信息",SwingConstants.CENTER);
l3.setForeground(Color.BLUE);
l3.setFont(new Font("BOLD",Font.BOLD,28));
c3.add(l3);
tf2=new JTextField();
tf3=new JTextField();
tf4=new JTextField();
tf5=new JTextField();
tf6=new JTextField();
tf7=new JTextField();
tf8=new JTextField();
tf9=new JTextField();
p5.add(new JLabel("学号",SwingConstants.CENTER));
p5.add(tf2);
p5.add(new JLabel("姓名",SwingConstants.CENTER));
p5.add(tf3);
p5.add(new JLabel("性别",SwingConstants.CENTER));
p5.add(tf4);
p5.add(new JLabel("院系",SwingConstants.CENTER));
p5.add(tf5);
p5.add(new JLabel("宿舍号",SwingConstants.CENTER));
p5.add(tf6);
p5.add(new JLabel("宿舍电话",SwingConstants.CENTER));
p5.add(tf7);
p5.add(new JLabel("晚归原因",SwingConstants.CENTER));
p5.add(tf8);
p5.add(new JLabel("晚归时间",SwingConstants.CENTER));
p5.add(tf9);
c3.add(p5);
bt8=new JButton("添加");
bt9=new JButton("清除");
bt10=new JButton("退出");
p6.add(bt8);
p6.add(bt9);
p6.add(bt10);
c3.add(p6);
bt8.addActionListener(this);
bt9.addActionListener(this);
bt10.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{ if(e.getSource()==bt8)
{ addfi();}
if(e.getSource()==bt9)
{ clearform(); }
if(e.getSource()==bt10)
{ shutdown4(); }
}
private void addfi()
{ sno=tf2.getText();
sname=tf3.getText();
ssex=tf4.getText();
sdept=tf5.getText();
dno=tf6.getText();
dnum=tf7.getText();
lreason=tf8.getText();
ltime=tf9.getText();
if(sno.length()==0||sname.length()==0||ssex.length()==0||
sdept.length()==0||dno.length()==0||dnum.length()==0||
lreason.length()==0||ltime.length()==0)
JOptionPane.showMessageDialog(this,"请添加完全信息");
else
{ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=DriverManager.getConnection("jdbc:odbc:宿舍管理","df","1234");
String sqm="insert into late values(?,?,?,?,?,?,?,?)";
PreparedStatement ps=cn.prepareStatement(sqm);
ps.setString(1,sno);
ps.setString(2,sname);
ps.setString(3,ssex);
ps.setString(4,sdept);
ps.setString(5,dno);
ps.setString(6,dnum);
ps.setString(7,lreason);
ps.setString(8,ltime);
ps.executeUpdate();
cn.close();
JOptionPane.showMessageDialog(this,"添加成功!");
clearform();
}
catch(SQLException e)
{ System.out.println("E Code:"+e.getErrorCode());
System.out.println("E Message="+e.getMessage());
}
catch(Exception e)
{ e.printStackTrace();}
}
}
private void clearform()
{ tf2.setText("");
tf3.setText("");
tf4.setText("");
tf5.setText("");
tf6.setText("");
tf7.setText("");
tf8.setText("");
tf9.setText("");
}
private void shutdown4()
{ System.exit(0);
}
}
class Delete5 extends JFrame implements ActionListener
{ String sno;
JPanel p7,p8;
JLabel l4,l5;
JTextField tf10;
JButton bt11,bt12;
Container c4=null;
public Delete5()
{ super("删除模块");
c4=getContentPane();
c4.setLayout(new GridLayout(3,1));
c4.setFont(new Font("true",Font.TRUETYPE_FONT,13));
p7=new JPanel();
p8=new JPanel();
l4=new JLabel("删除学生信息",SwingConstants.CENTER);
l4.setFont(new Font("true",Font.TRUETYPE_FONT,20));
l4.setForeground(Color.BLUE);
c4.add(l4);
l5=new JLabel("请输入学号");
tf10=new JTextField(10);
p7.add(l5);
p7.add(tf10);
c4.add(p7);
bt11=new JButton("确定");
bt12=new JButton("退出");
p8.add(bt11);
p8.add(bt12);
c4.add(p8);
bt11.addActionListener(this);
bt12.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{ if(e.getSource()==bt11)
{ del(); }
if(e.getSource()==bt12)
{ shutdown3(); }
}
private void del()
{ sno=tf10.getText();
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection cn=DriverManager.getConnection("jdbc:odbc:宿舍管理","df","1234");
Statement stmt=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sqm="delete from late where sno='"+sno+"'";
stmt.executeUpdate(sqm);
stmt.close();
cn.close();
JOptionPane.showMessageDialog(this,"删除成功");
}
catch(SQLException e)
{ System.out.println("Error Code:"+e.getErrorCode());
System.out.println("Message="+e.getMessage());
}
catch(Exception e)
{ e.printStackTrace(); }
}
private void shutdown3()
{ System.exit(0);
}
}
public class wangui extends JFrame implements ActionListener
{ Container c1=null;
JLabel l1;
JButton bt1,bt2,bt3,bt4;
JPanel p1,p2;
Insert5 insert5=new Insert5();
Delete5 delete5=new Delete5();
Find5 find5=new Find5();
//findt ud=new findt(find5);
public wangui()
{ super("夜归");
c1=getContentPane();
l1=new JLabel("欢迎进入学生夜归系统!",SwingConstants.CENTER);
l1.setForeground(Color.BLUE);
l1.setFont(new Font("BOLD",Font.BOLD,28));
p1=new JPanel();
p1.add(l1);
c1.add(p1,BorderLayout.CENTER);
bt1=new JButton("查询");
bt2=new JButton("添加");
bt3=new JButton("删除");
bt4=new JButton("退出");
p2=new JPanel();
p2.setLayout(new FlowLayout());
p2.add(bt1);
p2.add(bt2);
p2.add(bt3);
p2.add(bt4);
c1.add(p2,BorderLayout.SOUTH);
find5.setSize(400,200);
find5.setVisible(false);
insert5.setSize(400,500);
insert5.setVisible(false);
delete5.setSize(400,200);
delete5.setVisible(false);
bt1.addActionListener(this);
bt2.addActionListener(this);
bt3.addActionListener(this);
bt4.addActionListener(this);
}
public void actionPerformed(ActionEvent e)
{ if((JButton)e.getSource()==bt1)
find5.setVisible(true);
if((JButton)e.getSource()==bt2)
insert5.setVisible(true);
if((JButton)e.getSource()==bt3)
delete5.setVisible(true);
if((JButton)e.getSource()==bt4)
System.exit(0);
}
public static void main(String[] args)
{
wangui frame5=new wangui();
frame5.setSize(400,200);
frame5.setVisible(true);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -