📄 manage_teacher.java
字号:
import java.awt.*;
import java.sql.*;
import java.util.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
import java.sql.PreparedStatement;
import javax.swing.*;
public class Manage_teacher extends JFrame implements ActionListener
{
private static final int DEFAULT_WIDTH = 500;
private static final int DEFAULT_HEIFHT = 400;
ResultSet rs;
Connection con;
PreparedStatement ps;
String teacher_no,teacher_name,teacher_sex,teacher_age,teacher_level;
int age;
GridBagLayout gbl=new GridBagLayout();
GridBagConstraints gbc=new GridBagConstraints();
JPanel toppanel;
JTextField shuru;
JLabel xuehaowei;
JButton queding;
JPanel butpanel;
JLabel bianhao,xingming,mima,xingbie,nianling,zhicheng;
JLabel la1,la2,la3,la4,la5,la6,la7,la8,la9,la0;
JTextField tf_bianhao,tf_xingming,tf_xingbie,tf_nianling,tf_zhicheng;
JButton tianjia;
JButton xiugai;
JButton shanchu;
JButton qingkong;
JButton exit;
public Manage_teacher()
{
super.setLocation(300,80);
super.setSize(DEFAULT_WIDTH,DEFAULT_HEIFHT);
super.setTitle("学生基本信息管理！");
toppanel=new JPanel(); //////////////////////////顶面板....
toppanel.setBackground(Color.WHITE);
xuehaowei=new JLabel("教师编号为:");
shuru=new JTextField(11);
queding=new JButton("查询");
queding.addActionListener(this);
butpanel=new JPanel(); ///////////////////////////底面板.........
butpanel.setBackground(Color.WHITE);
bianhao=new JLabel("编号");
xingming=new JLabel("姓名");
xingbie=new JLabel("性别");
nianling=new JLabel("年龄");
zhicheng=new JLabel("职称");
la1=new JLabel(" ");
la2=new JLabel(" ");
la3=new JLabel(" ");
la4=new JLabel(" ");
la5=new JLabel(" ");
la6=new JLabel(" ");
la7=new JLabel(" ");
la8=new JLabel(" ");
la9=new JLabel(" ");
la0=new JLabel(" ");
tf_bianhao=new JTextField(7);
tf_xingming=new JTextField(7);
tf_xingbie=new JTextField(7);
tf_nianling=new JTextField(7);
tf_zhicheng=new JTextField(7);
tianjia=new JButton("添加");
tianjia.addActionListener(this);
xiugai=new JButton("修改");
xiugai.addActionListener(this);
shanchu=new JButton("删除");
shanchu.addActionListener(this);
qingkong=new JButton("清空");
qingkong.addActionListener(this);
exit=new JButton("返回");
exit.addActionListener(this);
set(0,0,1,1,butpanel,bianhao);set(1,0,1,1,butpanel,tf_bianhao);set(2,0,1,1,butpanel,la1);set(3,0,1,1,butpanel,xingming);set(4,0,1,1,butpanel,tf_xingming);
set(2,1,1,1,butpanel,la2);set(0,1,1,1,butpanel,xingbie);set(1,1,1,1,butpanel,tf_xingbie);
set(0,2,1,1,butpanel,nianling);set(1,2,1,1,butpanel,tf_nianling);set(2,2,1,1,butpanel,la3);set(3,1,1,1,butpanel,zhicheng);set(4,1,1,1,butpanel,tf_zhicheng);
set(0,3,1,1,butpanel,la5);set(1,3,1,1,butpanel,la6);set(2,3,1,1,butpanel,la4);set(3,3,1,1,butpanel,la7);set(4,3,1,1,butpanel,la8);
set(0,4,1,1,butpanel,tianjia);set(1,4,1,1,butpanel,xiugai);set(2,4,1,1,butpanel,la0);;set(3,4,1,1,butpanel,shanchu);set(4,4,1,1,butpanel,qingkong);
set(0,0,1,1,toppanel,xuehaowei);
set(1,0,1,1,toppanel,shuru);
set(2,0,1,1,toppanel,queding);
set(3,0,1,1,toppanel,exit);
toppanel.add(butpanel);
add(toppanel,BorderLayout.NORTH);
butpanel.setLayout(gbl);
setLayout(new GridLayout());
String url="jdbc:odbc:StudentScore";
String username="sa";
String password="";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(url,username,password);
}
catch(ClassNotFoundException cnfex)
{
System.err.println( "装载JDBC/ODBC驱动程序失败。");
//cnfex.printStackTrace();
System.exit(1);
}
catch(SQLException sqlex)
{
System.err.println("无法连接数据库");
//sqlex.printStackTrace();
System.exit(1);
}
}
public void set(int x,int y,int w,int h,JPanel panel,Component com)
{
gbc.anchor=GridBagConstraints.NORTH;
gbc.gridx=x;
gbc.gridy=y;
gbc.gridwidth=w;
gbc.gridheight=h;
gbl.setConstraints(com, gbc);
panel.add(com);
}
public void actionPerformed(ActionEvent e)
{
Object obj=e.getSource();
if(obj==queding)
{
try
{
String no=shuru.getText().trim();
if(no.length()==0)
{
JOptionPane.showMessageDialog((Component)null,"请输入教师编号!","提示信息",JOptionPane.INFORMATION_MESSAGE);
}
else
{
ps=con.prepareStatement("select * from teacher where teacher_no=?");
ps.setString(1,no);
rs=ps.executeQuery();
rs.next();
teacher_no=rs.getString(1).trim();
teacher_name=rs.getString(2).trim();
teacher_sex=rs.getString(3).trim();
teacher_age=""+rs.getInt(4);
teacher_level=rs.getString(5).trim();
tf_bianhao.setText(teacher_no);
tf_nianling.setText(teacher_age);
tf_xingming.setText(teacher_name);
tf_xingbie.setText(teacher_sex);
tf_zhicheng.setText(teacher_level);
}
}
catch(SQLException sql)
{
sql.getMessage();
//sql.printStackTrace();
JOptionPane.showMessageDialog((Component)null,"该老师不存在!","提示信息",JOptionPane.QUESTION_MESSAGE);
shuru.requestFocus();
}
}
if(obj==tianjia)
{
teacher_no=tf_bianhao.getText().trim();
teacher_name=tf_xingming.getText().trim();
teacher_sex=tf_xingbie.getText().trim();
age=Integer.parseInt(tf_nianling.getText().trim());
teacher_level=tf_zhicheng.getText().trim();
if(teacher_no.length()==0||teacher_name.length()==0||teacher_sex.length()==0||age==0||teacher_no.length()==0||teacher_level.length()==0)
{
JOptionPane.showMessageDialog((Component)null,"请添加完整信息！","提示信息",JOptionPane.QUESTION_MESSAGE);
}
else
{
try
{
ps=con.prepareStatement("insert into teacher values(?,?,?,?,?)");
ps.setString(1, teacher_no);
ps.setString(2, teacher_name);
ps.setString(3, teacher_sex);
ps.setInt(4, age);
ps.setString(5, teacher_level);
JOptionPane.showMessageDialog((Component)null,"确定添加吗？","提示信息",JOptionPane.QUESTION_MESSAGE);
tf_bianhao.setText("");
tf_xingming.setText("");
tf_xingbie.setText("");
tf_nianling.setText("");
tf_zhicheng.setText("");
rs=ps.executeQuery();
System.out.print("1");
}
catch(SQLException sql)
{
sql.getMessage();
//sql.printStackTrace();
JOptionPane.showMessageDialog((Component)null,"添加成功！","提示信息",JOptionPane.QUESTION_MESSAGE);
}
}
}
if(obj==xiugai)
{
String no=shuru.getText().trim();
teacher_no=tf_bianhao.getText().trim();
teacher_name=tf_xingming.getText().trim();
teacher_sex=tf_xingbie.getText().trim();
age=Integer.parseInt(tf_nianling.getText().trim());
teacher_level=tf_zhicheng.getText().trim();
try
{
ps=con.prepareStatement("update teacher set teacher_no=?,teacher_name=?,teacher_sex=?,teacher_age=?,teacher_level=? where teacher_no=?");
ps.setString(1, teacher_no);
ps.setString(2, teacher_name);
ps.setString(3,teacher_sex);
ps.setInt(4,age);
ps.setString(5,teacher_level);
ps.setString(6,no);
JOptionPane.showMessageDialog((Component)null,"确定修改吗？","提示信息",JOptionPane.QUESTION_MESSAGE);
tf_bianhao.setText("");
tf_xingming.setText("");
tf_xingbie.setText("");
tf_nianling.setText("");
tf_zhicheng.setText("");
JOptionPane.showMessageDialog((Component)null,"修改成功!","提示信息",JOptionPane.INFORMATION_MESSAGE);
rs=ps.executeQuery();
rs.next();
}
catch(SQLException sql)
{
sql.getMessage();
//sql.printStackTrace();
//JOptionPane.showMessageDialog((Component)null,sql.getMessage(),"提示信息",JOptionPane.QUESTION_MESSAGE);
}
}
if(obj==shanchu)
{
try
{
String no=shuru.getText().trim();
ps=con.prepareStatement("delete from teacher where teacher_no=?");
ps.setString(1,no);
JOptionPane.showMessageDialog((Component)null,"确定删除吗？","提示信息",JOptionPane.QUESTION_MESSAGE);
tf_bianhao.setText("");
tf_nianling.setText("");
tf_xingming.setText("");
tf_xingbie.setText("");
tf_zhicheng.setText("");
rs=ps.executeQuery();
JOptionPane.showMessageDialog((Component)null,"删除成功！","提示信息",JOptionPane.INFORMATION_MESSAGE);
}
catch(SQLException sqlex)
{
sqlex.getMessage();
}
}
if(obj==qingkong)
{
shuru.setText("");
tf_bianhao.setText("");
tf_nianling.setText("");
tf_xingming.setText("");
tf_xingbie.setText("");
tf_zhicheng.setText("");
}
if(obj==exit)
{
this.dispose();
Admin_manage admin=new Admin_manage();
admin.setVisible(true);
}
}
public static void main(String[] args)
{
Manage_teacher teach=new Manage_teacher();
teach.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
teach.setVisible(true);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -