📄 gchaxunxinxi.java
字号:
package don;
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import javax.swing.ButtonGroup;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
//数据库引入
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class gchaxunxinxi extends JFrame implements ActionListener
{
//JFrame jf;
JLabel l0,l1,l2,l3,l4;
JButton b1,b2;
ButtonGroup bg;
JRadioButton jrb1,jrb2,jrb3,jrb4;
JPanel jp1; //创建面板
JLabel l5,l6,l7,l8; //输入和选择框提示
JTextField t1,t2;
JComboBox jcb;
JLabel l9; //显示图片
JTable jt;
Font f1;
DefaultTableModel md ;
gchaxunxinxi()
{
super("学生信息管理系统");
f1=new Font("Helvetica",Font.PLAIN,20);//设置字体大小式样
l0=new JLabel("－－－－－－－－－－－－学生信息查询－－－－－－－－－－－－－");
l0.setFont(f1);
l0.setForeground(Color.blue);
b1=new JButton("确定");
b2=new JButton("退出");
bg=new ButtonGroup();
jrb1=new JRadioButton();
jrb2=new JRadioButton();
jrb3=new JRadioButton();
jrb4=new JRadioButton();
l1=new JLabel("按学号查询");
l2=new JLabel("按姓名查询");
l3=new JLabel("按专业查询");
l4=new JLabel("查询全部");
l5=new JLabel("请输入学号");
l6=new JLabel("请输入姓名");
l7=new JLabel("请选择专业");
l8=new JLabel("显示查询信息");
t1=new JTextField("",10);
t2=new JTextField("",10);
md = new DefaultTableModel();
String[] columnName={"学号","姓名","性别","班级","年级","政治面貌","出生日期","籍贯","密码","专业"};
//String[] col={"学号","姓名"};
//String[][] row=null;//={{"2","2"},{"2","2"}};
jp1=new JPanel();
//jp1.setBackground(Color.blue);//测试时加的颜色
jt=new JTable(md);//显示窗体
//jt=new JTable(row,columnName);//显示窗体
//jt.setBackground(Color.white);//测试时加的颜色
JScrollPane jsp=new JScrollPane(jt,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);
//jp1.add(jsp);
Dimension dim=new Dimension(580,150);
jt.setPreferredScrollableViewportSize(dim);
for(int i=0;i<columnName.length;i++)
{
md.addColumn(columnName[i]);
}
jp1.add(jsp);
// JScrollPane jsp=new JScrollPane(jt,JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
ImageIcon ii=new ImageIcon("ligong.jpg");
l9=new JLabel(ii);
jcb=new JComboBox();
jcb.addItem("计算机");
jcb.addItem("软件");
jcb.addItem("英语");
jcb.addItem("自动化");
jcb.addItem("数学");
jcb.addItem("化学");
jcb.setBackground(Color.white);
jcb.setSelectedIndex(0);
setBounds(100,100,650,600);
setLayout(null);
setResizable(false);//设置窗体大小是否可变
jrb1.setSelected(false);//单选按钮初始化为未被选中
add(l0);
bg.add(jrb1);
bg.add(jrb2);
bg.add(jrb3);
bg.add(jrb4);
add(jrb1);
add(jrb2);
add(jrb3);
add(jrb4);
add(jcb);
add(b1);
add(b2);
add(l1);
add(l2);
add(l3);
add(l4);
add(l5);
add(l6);
add(l7);
add(t1);
add(t2);
add(l8);
add(l9);
add(jp1);
l0.setBounds(10,60,700,25);
jrb1.setBounds(108,100,16,16);
l1.setBounds(126,100,80,20);
jrb2.setBounds(210,100,16,16);
l2.setBounds(228,100,80,20);
jrb3.setBounds(312,100,16,16);
l3.setBounds(330,100,80,20);
jrb4.setBounds(414,100,16,16);
l4.setBounds(432,100,80,20);
b1.setBounds(220,500,60,30);
b2.setBounds(360,500,60,30);
l5.setBounds(100,150,70,25);
t1.setBounds(172,150,70,25);
l6.setBounds(350,150,70, 25);
t2.setBounds(422,150,70, 25);
l7.setBounds(100,200,70,25);
jcb.setBounds(172,200,80,30);
l8.setBounds(80,280,120,25);
l9.setBounds(0,0,650,60);
//jt.setBounds(90,330,500,200);
//jsp.setBounds(590,320,100,80);
//informationTable.setBounds(200,500,500,200);
jp1.setBounds(20,300,600,200);
jrb1.addActionListener(this);
jrb2.addActionListener(this);
jrb3.addActionListener(this);
jrb4.addActionListener(this);
b1.addActionListener(new button1());
b2.addActionListener
(
new ActionListener()
{
public void actionPerformed(ActionEvent e)
{
// System.exit(0);
setVisible(false);
}
}
);
}
public void actionPerformed(final ActionEvent e)
{
if(e.getSource()==jrb1)
{
t1.setEditable(true);
t2.setEditable(false);
jcb.setEnabled(false);
}
else if(e.getSource()==jrb2)
{
t1.setEditable(false);
t2.setEditable(true);
jcb.setEnabled(false);
}
else if(e.getSource()==jrb3)
{
t1.setEditable(false);
t2.setEditable(false);
jcb.setEnabled(true);
}
else if(e.getSource()==jrb4)
{
t1.setEditable(false);
t2.setEditable(false);
jcb.setEnabled(false);
}
}
public class button1 implements ActionListener
{
String[][] row=null;
public void actionPerformed(ActionEvent e1)
{
final String a;
final String b;
final String c;
a=t1.getText();
b=t2.getText();
c=(String) jcb.getSelectedItem();
DBSource db=new DBSource();
String sno=null;
String sname=null;
String ssex=null;
String sclass=null;
String sgrade=null;
String szhenzhimianmao=null;
String sbirthday=null;
String shometown=null;
String smima=null;
String szhuanye=null;
int count=md.getRowCount();////////////////////
for(int i=0;i<count;i++)
{
md.removeRow(0);
} ////
if(e1.getSource()==b1)
{
if(jrb1.isSelected()||jrb2.isSelected()||jrb3.isSelected()||jrb4.isSelected())
{
if(jrb1.isSelected())
{
if((t1==null||t1.getText().equals("")))
{
JOptionPane.showMessageDialog(null,"对不起，您没有没有输入学号，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);
}
else
{
String sql1="select * from geren where sno='" + a + "'";
ResultSet rs1=db.executeQuery(sql1);
try {
while(rs1.next())
{
sno=rs1.getString(1);
sname=rs1.getString(2);
ssex=rs1.getString(3);
sclass=rs1.getString(4);
sgrade=rs1.getString(5);
szhenzhimianmao=rs1.getString(6);
sbirthday=rs1.getString(7);
shometown=rs1.getString(8);
smima=rs1.getString(9);
szhuanye=rs1.getString(10);
String[] row={sno,sname,ssex,sclass,sgrade,szhenzhimianmao,sbirthday,shometown,smima,szhuanye};
md.addRow(row);
return;
}
if(!rs1.next())
{
JOptionPane.showMessageDialog(null,"对不起，您输入的学号没有记录，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);
}
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
else if(jrb2.isSelected())
{
if((t2==null||t2.getText().equals("")))
{
JOptionPane.showMessageDialog(null,"对不起，您没有输入姓名，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);
}
else
{
String sql2="select * from geren where sname='"+ b +"'";
ResultSet rs2=db.executeQuery(sql2);
try {
while(rs2.next())
{
sno=rs2.getString(1);
sname=rs2.getString(2);
ssex=rs2.getString(3);
sclass=rs2.getString(4);
sgrade=rs2.getString(5);
szhenzhimianmao=rs2.getString(6);
sbirthday=rs2.getString(7);
shometown=rs2.getString(8);
smima=rs2.getString(9);
szhuanye=rs2.getString(10);
String[] row={sno,sname,ssex,sclass,sgrade,szhenzhimianmao,sbirthday,shometown,smima,szhuanye};
md.addRow(row);
return;
}
if(!rs2.next())
{
JOptionPane.showMessageDialog(null,"对不起，您输入的姓名没有记录，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);
}
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
else if(jrb3.isSelected()) //下拉列表项的选择，置第一项为已选
{
try {
String sql3="select * from geren where szhuanye='" + c + "'";
ResultSet rs3=db.executeQuery(sql3);
while(rs3.next())
{
sno=rs3.getString(1);
sname=rs3.getString(2);
ssex=rs3.getString(3);
sclass=rs3.getString(4);
sgrade=rs3.getString(5);
szhenzhimianmao=rs3.getString(6);
sbirthday=rs3.getString(7);
shometown=rs3.getString(8);
smima=rs3.getString(9);
szhuanye=rs3.getString(10);
String[] row={sno,sname,ssex,sclass,sgrade,szhenzhimianmao,sbirthday,shometown,smima,szhuanye};
md.addRow(row);
}
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
else if(jrb4.isSelected()) //下拉列表项的选择，置第一项为已选
{
String sql4="select * from geren";
ResultSet rs4=db.executeQuery(sql4);
try {
while(rs4.next())
{
sno=rs4.getString(1);
sname=rs4.getString(2);
ssex=rs4.getString(3);
sclass=rs4.getString(4);
sgrade=rs4.getString(5);
szhenzhimianmao=rs4.getString(6);
sbirthday=rs4.getString(7);
shometown=rs4.getString(8);
smima=rs4.getString(9);
szhuanye=rs4.getString(10);
String[] row={sno,sname,ssex,sclass,sgrade,szhenzhimianmao,sbirthday,shometown,smima,szhuanye};
md.addRow(row);
}
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
else
{
JOptionPane.showMessageDialog(null,"对不起，您没有选择查询方式，无法完成查询！","不合法",JOptionPane.ERROR_MESSAGE);
}
}
}
}
public static void main(final String[] args)
{
new gchaxunxinxi().setVisible(true);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -