📄
字号:
panel1.add(label);panel1.add(textfield1);panel1.add(button1);panel1.add(button2);
con=getContentPane();
con.add(panel1,BorderLayout.NORTH);
con.add(new JScrollPane(table),BorderLayout.CENTER);
con.add(textfield2,BorderLayout.SOUTH);
button1.addActionListener(this);
button2.addActionListener(this);
textfield1.addActionListener(this);
setSize(600,600);setVisible(false);
this.setTitle(s);
validate();
addWindowListener(new WindowAdapter()
{public void WindowClosing(WindowEvent e)
{
setVisible(false);}});
}
public void actionPerformed(ActionEvent evt)
{
int j,k;
for(k=0;k<80;k++)
{ for(j=0;j<8;j++)
{a[k][j]=null;}
}
table.repaint();
if(evt.getSource()==button2)
textfield1.setText(null);
if(evt.getSource()==button1||evt.getSource()==textfield1)
{
int i=0;
String banji=textfield1.getText().trim();
if(banji.length()>0)
{
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){System.out.println("连接异常");}
try
{
connect=DriverManager.getConnection("jdbc:odbc:Source");
sql=connect.createStatement();
rs=sql.executeQuery("SELECT*FROM 表1 WHERE 班级 LIKE "+"'"+'%'+banji+'%'+"'");
while(rs.next())
{
a[i][0]=rs.getString("学号");a[i][1]=rs.getString("姓名");
a[i][2]=rs.getString("性别");a[i][3]=rs.getString("班级");
a[i][4]=rs.getString("出生年月");a[i][5]=rs.getString("入学年份");
a[i][6]=rs.getString("籍贯");a[i][7]=rs.getString("专业");
table.repaint();
i++;
if(i==81)
{break;}
}
if(i==0)
textfield2.setText("没有该记录");
else if(i==81)
textfield2.setText("该查询的结果的记录个数大于80，只能显示80个！");
else
textfield2.setText("共有"+i+"个记录");
connect.close();
}
catch(SQLException e1){System.out.println("查询异常");}
}
else
{
String warning="必须要输入班级!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
}
}
}
class 按籍贯查询界面 extends JDialog implements ActionListener
{
JButton button1,button2;
JTextField textfield1,textfield2;
JLabel label;
JPanel panel1,panel2;
JTable table;
Connection connect;
Statement sql;
ResultSet rs;
Container con;
Object a[][]=new Object [80][8];
Object columnName[]={"学号","姓名","性别","班级","出生年月","入学年份","籍贯","专业"};
按籍贯查询界面(JFrame f,String s)
{
button1=new JButton("ok");
button2=new JButton("clear");
label=new JLabel("请输入要查询的籍贯：");
textfield1=new JTextField(12);
textfield2=new JTextField(12);
table=new JTable(a,columnName);
panel1=new JPanel();
panel1.add(label);panel1.add(textfield1);panel1.add(button1);panel1.add(button2);
con=getContentPane();
con.add(panel1,BorderLayout.NORTH);
con.add(new JScrollPane(table),BorderLayout.CENTER);
con.add(textfield2,BorderLayout.SOUTH);
button1.addActionListener(this);
button2.addActionListener(this);
textfield1.addActionListener(this);
setSize(600,600);setVisible(false);
this.setTitle(s);
validate();
addWindowListener(new WindowAdapter()
{public void WindowClosing(WindowEvent e)
{
setVisible(false);}});
}
public void actionPerformed(ActionEvent evt)
{
int j,k;
for(k=0;k<80;k++)
{ for(j=0;j<8;j++)
{a[k][j]=null;}
}
table.repaint();
if(evt.getSource()==button2)
textfield1.setText(null);
if(evt.getSource()==button1||evt.getSource()==textfield1)
{
int i=0;
String jiguan=textfield1.getText().trim();
if(jiguan.length()>0)
{
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){System.out.println("连接异常");}
try
{
connect=DriverManager.getConnection("jdbc:odbc:Source");
sql=connect.createStatement();
rs=sql.executeQuery("SELECT*FROM 表1 WHERE 籍贯 LIKE"+"'"+ '%'+jiguan+'%'+"'");
while(rs.next())
{
a[i][0]=rs.getString("学号");a[i][1]=rs.getString("姓名");
a[i][2]=rs.getString("性别");a[i][3]=rs.getString("班级");
a[i][4]=rs.getString("出生年月");a[i][5]=rs.getString("入学年份");
a[i][6]=rs.getString("籍贯");a[i][7]=rs.getString("专业");
table.repaint();
i++;
if(i==81)
{break;}
}
if(i==0)
textfield2.setText("没有该记录");
else if(i==81)
textfield2.setText("该查询的结果的记录个数大于80，只能显示80个！");
else
textfield2.setText("共有"+i+"个记录");
connect.close();
}
catch(SQLException e1){System.out.println("查询异常");}
}
else
{
String warning="必须要输入籍贯!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
}
}
}
class 按专业查询界面 extends JDialog implements ActionListener
{
JButton button1,button2;
JTextField textfield1,textfield2;
JLabel label;
JPanel panel1,panel2;
JTable table;
Connection connect;
Statement sql;
ResultSet rs;
Container con;
Object a[][]=new Object [80][8];
Object columnName[]={"学号","姓名","性别","班级","出生年月","入学年份","籍贯","专业"};
按专业查询界面(JFrame f,String s)
{
button1=new JButton("ok");
button2=new JButton("clear");
label=new JLabel("请输入要查询的专业：");
textfield1=new JTextField(20);
textfield2=new JTextField(12);
table=new JTable(a,columnName);
panel1=new JPanel();
panel1.add(label);panel1.add(textfield1);panel1.add(button1);panel1.add(button2);
con=getContentPane();
con.add(panel1,BorderLayout.NORTH);
con.add(new JScrollPane(table),BorderLayout.CENTER);
con.add(textfield2,BorderLayout.SOUTH);
button1.addActionListener(this);
button2.addActionListener(this);
textfield1.addActionListener(this);
setSize(600,600);setVisible(false);
this.setTitle(s);
validate();
addWindowListener(new WindowAdapter()
{public void WindowClosing(WindowEvent e)
{
setVisible(false);}});
}
public void actionPerformed(ActionEvent evt)
{
int j,k;
for(k=0;k<80;k++)
{ for(j=0;j<8;j++)
{a[k][j]=null;}
}
table.repaint();
if(evt.getSource()==button2)
textfield1.setText(null);
if(evt.getSource()==button1||evt.getSource()==textfield1)
{
int i=0;
String zhuanye=textfield1.getText().trim();
if(zhuanye.length()>0)
{
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){System.out.println("连接异常");}
try
{
connect=DriverManager.getConnection("jdbc:odbc:Source");
sql=connect.createStatement();
rs=sql.executeQuery("SELECT*FROM 表1 WHERE 专业 LIKE"+"'"+ '%'+zhuanye+'%'+"'");
while(rs.next())
{
a[i][0]=rs.getString("学号");a[i][1]=rs.getString("姓名");
a[i][2]=rs.getString("性别");a[i][3]=rs.getString("班级");
a[i][4]=rs.getString("出生年月");a[i][5]=rs.getString("入学年份");
a[i][6]=rs.getString("籍贯");a[i][7]=rs.getString("专业");
table.repaint();
i++;
if(i==81)
{break;}
}
if(i==0)
textfield2.setText("没有该记录");
else if(i==81)
textfield2.setText("该查询的结果的记录个数大于80，只能显示80个！");
else
textfield2.setText("共有"+i+"个记录");
connect.close();
}
catch(SQLException e1){System.out.println("查询异常");}
}
else
{
String warning="必须要输入专业!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
}
}
}
class 按出生年月查询界面 extends JDialog implements ActionListener
{
JButton button1,button2;
JTextField textfield1,textfield2;
JLabel label;
JPanel panel1,panel2;
JTable table;
Connection connect;
Statement sql;
ResultSet rs;
Container con;
Object a[][]=new Object [80][8];
Object columnName[]={"学号","姓名","性别","班级","出生年月","入学年份","籍贯","专业"};
按出生年月查询界面(JFrame f,String s)
{
button1=new JButton("ok");
button2=new JButton("clear");
label=new JLabel("请输入要查询的出生年月（格式：1984-01)：");
textfield1=new JTextField(12);
textfield2=new JTextField(12);
table=new JTable(a,columnName);
panel1=new JPanel();
panel1.add(label);panel1.add(textfield1);panel1.add(button1);panel1.add(button2);
con=getContentPane();
con.add(panel1,BorderLayout.NORTH);
con.add(new JScrollPane(table),BorderLayout.CENTER);
con.add(textfield2,BorderLayout.SOUTH);
button1.addActionListener(this);
button2.addActionListener(this);
textfield1.addActionListener(this);
setSize(600,600);setVisible(false);
this.setTitle(s);
validate();
addWindowListener(new WindowAdapter()
{public void WindowClosing(WindowEvent e)
{
setVisible(false);}});
}
public void actionPerformed(ActionEvent evt)
{
int j,k;
for(k=0;k<80;k++)
{ for(j=0;j<8;j++)
{a[k][j]=null;}
}
table.repaint();
if(evt.getSource()==button2)
textfield1.setText(null);
if(evt.getSource()==button1||evt.getSource()==textfield1)
{
int i=0;
String chushengnianyue=textfield1.getText().trim();
if(chushengnianyue.length()>0)
{
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){System.out.println("连接异常");}
try
{
connect=DriverManager.getConnection("jdbc:odbc:Source");
sql=connect.createStatement();
rs=sql.executeQuery("SELECT*FROM 表1 where 出生年月 like"+"'"+'%'+chushengnianyue+'%'+"'");
while(rs.next())
{
a[i][0]=rs.getString("学号");a[i][1]=rs.getString("姓名");
a[i][2]=rs.getString("性别");a[i][3]=rs.getString("班级");
a[i][4]=rs.getString("出生年月");a[i][5]=rs.getString("入学年份");
a[i][6]=rs.getString("籍贯");a[i][7]=rs.getString("专业");
table.repaint();
i++;
if(i==81)
{break;}
}
if(i==0)
textfield2.setText("没有该记录");
else if(i==81)
textfield2.setText("该查询的结果的记录个数大于80，只能显示80个！");
else
textfield2.setText("共有"+i+"个记录");
connect.close();
}
catch(SQLException e1){System.out.println("查询异常");}
}
else
{
String warning="必须要输入出生年月!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
}
}
}
class 按入学年份查询界面 extends JDialog implements ActionListener
{
JButton button1,button2;
JTextField textfield1,textfield2;
JLabel label;
JPanel panel1,panel2;
JTable table;
Connection connect;
Statement sql;
ResultSet rs;
Container con;
Object a[][]=new Object [80][8];
Object columnName[]={"学号","姓名","性别","班级","出生年月","入学年份","籍贯","专业"};
按入学年份查询界面(JFrame f,String s)
{
button1=new JButton("ok");
button2=new JButton("clear");
label=new JLabel("请输入要查询的入学年份（格式：2003-09)：");
textfield1=new JTextField(12);
textfield2=new JTextField(12);
table=new JTable(a,columnName);
panel1=new JPanel();
panel1.add(label);panel1.add(textfield1);panel1.add(button1);panel1.add(button2);
con=getContentPane();
con.add(panel1,BorderLayout.NORTH);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -