📄 1.txt
字号:
import java.awt.*;
import java.sql.*;
import javax.swing.*;
import javax.swing.JOptionPane;
import java.awt.event.*;
import javax.swing.border.*;
public class students extends JFrame implements ActionListener
{
private JPanel left;
private JPanel right;
private JPanel down;
JTextField number;
JTextField name;
JTextField age;
JTextArea score;
static int count=0;
students(String title)
{
super(title);
setSize(200,300);
setLocation(200,250);
setPanelleft();
setPanelright();
setPaneldown();
setLayout(new BorderLayout());
add(left,BorderLayout.WEST);
add(right,BorderLayout.EAST);
add(down,BorderLayout.SOUTH);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
public void setPanelleft()
{
left=new JPanel();
left.setLayout(new GridLayout(3,2));
left.setBackground(Color.yellow);
JLabel lab1=new JLabel("<html><font color = green>学号",JLabel.CENTER);
JLabel lab2=new JLabel("<html><font color = green>姓名",JLabel.CENTER);
JLabel lab3=new JLabel("<html><font color = green>年龄",JLabel.CENTER);
number = new JTextField(12);
name = new JTextField(12);
age = new JTextField(12);
left.add(lab1);
left.add(number);
left.add(lab2);
left.add(name);
left.add(lab3);
left.add(age);
}
public void setPanelright()
{
right=new JPanel();
right.setLayout(new BorderLayout());
JLabel lab4 = new JLabel("<html><font color = red>各科成绩,形如[语文,数学,英语]");
score=new JTextArea(5, 19);
right.add(lab4,BorderLayout.NORTH);
right.add(score,BorderLayout.CENTER);
}
public void setPaneldown()
{
down =new JPanel();
down.setLayout(new FlowLayout(FlowLayout.LEFT,80,20));
JButton display=new JButton("<html><font color = red>显示内容");
JButton delete=new JButton("<html><font color = blue>删除内容");
JButton add=new JButton("<html><font color = blue>增加内容");
display.setActionCommand("dis");
display.addActionListener(this);
delete.setActionCommand("del");
delete.addActionListener(this);
add.setActionCommand("ad");
add.addActionListener(this);
down.add(display);
down.add(delete);
down.add(add);
}
public void actionPerformed(ActionEvent e)
{
Connection con;
Statement st;
ResultSet rs;
String user="Test",pass="1234";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException en)
{
System.out.println("SQL错误！" + en);
}
try
{
con=DriverManager.getConnection("jdbc:odbc:LIN",user,pass);
st=con.createStatement();
if(e.getActionCommand().equals("ad"))
{
String num="";
String na="";
String sc="";
int ag=0;
num=number.getText();
na=name.getText();
ag=Integer.parseInt(age.getText());
sc=score.getText();
if(count==0)
{
String query = "create table 学生学籍("+"学号 char(10),姓名 char(100),年龄 integer,语文 integer,数学 integer,英语 integer"+")";
st.executeUpdate(query);
count=count+1;
}
if((num!=null)&&(na!=null)&&(ag!=0))
{
String s[]=sc.split("#");
String s1="insert into 学生学籍 values("+"'"+num+"'"+","+"'"+na+"'"+","+ag+","+s[0]+","+s[1]+","+s[2]+")";
st.executeUpdate(s1);
}
else
{
JOptionPane.showMessageDialog(this, "请在各输入框中输入数据!", "出错了", JOptionPane.ERROR_MESSAGE);
}
}
else if(e.getActionCommand().equals("dis"))
{
String nu=number.getText().toString();
rs=st.executeQuery("select * from 学生学籍");
while(rs.next())
{
String k=rs.getString(1).trim();
if(k.equals(nu))
{
name.setText(rs.getString(2).trim());
age.setText(rs.getString(3));
score.setText("语文:"+rs.getString(4)+"\n"+"数学:"+rs.getString(5)+"\n"+"英语:"+rs.getString(6));
}
}
}
else
{
String n=number.getText();
System.out.print(n);
if(n!=null)
{
PreparedStatement ps = con.prepareStatement("delete from 学生学籍 where 学号="+"'"+n+"'");
ps.executeUpdate();
number.setText("");
}
}
st.close();
con.close();
}catch(java.sql.SQLException es){
System.out.println("SQL错误！" + es);
}
}
public static void main(String[] args)
{
students stu=new students("学生管理系统");
stu.pack();
stu.setVisible(true);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -