📄
字号:
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 ruxuenianfen=textfield1.getText().trim();
if(ruxuenianfen.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"+"'"+'%'+ruxuenianfen+'%'+"'");
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,button3,button4;
JLabel label1,label2,label3,label4;
JTextField textfield1,textfield2,textfield3,textfield4,textfield5;
JPanel panel1,panel2,panel3,panel4,panel5;
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("删除");
button2=new JButton("删除");
button3=new JButton("删除");
button4=new JButton("删除");
label1=new JLabel("请输入学号：");
label2=new JLabel("请输入班级：");
label3=new JLabel("请输入专业：");
label4=new JLabel("请输入学年份（格式：2003-09）：");
textfield1=new JTextField(20);textfield2=new JTextField(20);textfield3=new JTextField(20);
textfield4=new JTextField(20);
textfield5=new JTextField(20);
panel1=new JPanel();panel2=new JPanel();panel3=new JPanel();panel4=new JPanel();panel5=new JPanel();
panel1.add(label1);panel1.add(textfield1);panel1.add(button1);
panel2.add(label2);panel2.add(textfield2);panel2.add(button2);
panel3.add(label3);panel3.add(textfield3);panel3.add(button3);
panel4.add(label4);panel4.add(textfield4);panel4.add(button4);
panel5.setLayout(new GridLayout(4,1));
panel5.add(panel1);panel5.add(panel2);panel5.add(panel3);panel5.add(panel4);
table=new JTable(a,columnName);
con=getContentPane();
con.add(panel5,BorderLayout.NORTH);
con.add(new JScrollPane(table),BorderLayout.CENTER);
con.add(textfield5,BorderLayout.SOUTH);
button1.addActionListener(this);
button2.addActionListener(this);
button3.addActionListener(this);
button4.addActionListener(this);
textfield1.addActionListener(this);
textfield2.addActionListener(this);
textfield3.addActionListener(this);
textfield4.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 k,j;
for(k=0;k<80;k++)
{ for(j=0;j<8;j++)
{a[k][j]=null;}
}
table.repaint();
if(evt.getSource()==button1||evt.getSource()==textfield1)
{
int i=0;
String xuehao=textfield1.getText().trim();
if(xuehao.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"+"'"+'%'+xuehao+'%'+"'");
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==0)
{
textfield5.setText("没有该记录");
String warning="该学号不存在!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
else
{
textfield5.setText("共有"+i+"个记录");
String m="确定要删除该学号及全部信息吗?";
int ok=JOptionPane.showConfirmDialog(this,m,"确认",JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
if(ok==JOptionPane.YES_OPTION)
{
sql.executeUpdate("DELETE FROM 表1 WHERE 学号 like"+"'"+'%'+xuehao+'%'+"'");
textfield5.setText(i+"记录已被删除!");
for(k=0;k<i;k++)
{ for(j=0;j<8;j++)
{a[k][j]=null;}
}
table.repaint();
}
}
connect.close();
}
catch(SQLException e1){System.out.println("查询异常");}
}
else
{
String warning="必须要输入学号!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
}
else if(evt.getSource()==button2||evt.getSource()==textfield2)
{
int i=0;
String banji=textfield2.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==0)
{
textfield5.setText("没有该记录");
String warning="该班级不存在!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
else
{
textfield5.setText("共有"+i+"个记录");
String m="确定要删除该班级及全部信息吗?";
int ok=JOptionPane.showConfirmDialog(this,m,"确认",JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
if(ok==JOptionPane.YES_OPTION)
{
sql.executeUpdate("DELETE FROM 表1 WHERE 班级 LIKE "+"'"+'%'+banji+'%'+"'");
for(k=0;k<i;k++)
{
for(j=0;j<8;j++)
{a[k][j]=null;}
}
table.repaint();
textfield5.setText(i+"记录已被删除!");
}
}
connect.close();
}
catch(SQLException e1){System.out.println("查询异常");}
}
else
{
String warning="必须要输入班级!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
}
else if(evt.getSource()==button3||evt.getSource()==textfield3)
{
int i=0;
String zhuanye=textfield3.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==0)
{
textfield5.setText("没有该记录");
String warning="该专业不存在!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
else
{
textfield5.setText("共有"+i+"个记录");
String m="确定要删除该专业及全部信息吗?";
int ok=JOptionPane.showConfirmDialog(this,m,"确认",JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
if(ok==JOptionPane.YES_OPTION)
{
sql.executeUpdate("delete*FROM 表1 WHERE 专业 LIKE"+"'"+ '%'+zhuanye+'%'+"'");
for(k=0;k<i;k++)
{
for(j=0;j<8;j++)
{a[k][j]=null;}
}
table.repaint();
textfield5.setText(i+"记录已被删除!");
}
}
connect.close();
}
catch(SQLException e1){System.out.println("查询异常");}
}
else
{
String warning="必须要输入专业!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
}
else if(evt.getSource()==button4||evt.getSource()==textfield4)
{
int i=0;
String ruxuenianfen=textfield4.getText().trim();
if(ruxuenianfen.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"+"'"+'%'+ruxuenianfen+'%'+"'");
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==0)
{
textfield5.setText("没有该记录");
String warning="该入学年份不存在!";
JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
}
else
{
textfield5.setText("共有"+i+"个记录");
String m="确定要删除该入学年份及全部信息吗?";
int ok=JOptionPane.showConfirmDialog(this,m,"确认",JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE);
if(ok==JOptionPane.YES_OPTION)
{
sql.executeUpdate("delete*FROM 表1 where 入学年份 like"+"'"+'%'+ruxuenianfen+'%'+"'");
for(k=0;k<i;k++)
{
for(j=0;j<8;j++)
{a[k][j]=null;}
}
table.repaint();
textfield5.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
{
JTextField textfield1,textfield2,textfield3,textfield4,textfield5,textfield6,textfield7;
JRadioButton 男,女;
ButtonGroup group=null;
JButton 录入,重置;
Connection connect;
Statement sql;
ResultSet rs;
Container con;
public 录入界面(JFrame f,String s)
{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -