package jiemian;
import java.awt.Color;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.Font;
import java.awt.GridLayout;
import java.awt.Image;
import java.awt.Toolkit;
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.SQLException;
import java.sql.Statement;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import javax.swing.WindowConstants;
import db.connectDb;
public class Login extends JFrame implements ActionListener {
private JLabel han_biaoti_label;
private JLabel english_biaoti_label;
private JLabel user_label;
private JTextField user_field;
private JLabel user_password_label;
private JPasswordField user_password;
private JButton login_button;
private JButton exit_button;
public Login() {
Font max = new Font("楷体", Font.BOLD, 40);// 定义字体大小
Font min = new Font("TimesRoman", Font.ITALIC, 20);
JPanel jpanel = new JPanel();// 面板
this.setContentPane(jpanel);// 为窗体添加一个面板】
GridLayout gird = new GridLayout(3, 0); // 建立一个表格的版面对象。rows代表有几行,cols代表有几列
jpanel.setLayout(gird);// 将表格面板添加到面板
ImageIcon iconBackground = new ImageIcon("src/background.jpg");// 导入背景图片
JLabel imgLabel = new JLabel(iconBackground);// 将背景添加到一个Label标签中
int width = 500; // 面板宽
int height = 350; // 面板高
iconBackground.setImage(iconBackground.getImage().getScaledInstance(
width, height, Image.SCALE_DEFAULT)); // 设置背景图片大小,且按比例缩小填充
this.getContentPane().add(imgLabel, new Integer(Integer.MIN_VALUE));// 设置imaLabel是面板的最底层
imgLabel.setSize(500, 350);
this.getLayeredPane().setLayout(null);
this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);// 设置退出按钮有效
jpanel.setOpaque(false);// 设置面板不透明
countComponents();// 构造一个新的 Container容器。
this.getLayeredPane().add(imgLabel, new Integer(Integer.MIN_VALUE));
imgLabel.setSize(500, 350);
this.getLayeredPane().setLayout(null);
this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
this.setTitle("学生信息管理系统");
Dimension dimension = Toolkit.getDefaultToolkit().getScreenSize();// 返回当前分辨率
this.setBounds(((int) dimension.getWidth() - 500) / 2,
((int) dimension.getHeight() - 380) / 2, width, height);// 设置窗体在屏幕上的位置,通过dimension获取屏幕,
this.setResizable(false);// 设置窗体不可以调整大小
this.setLayout(null);// 默认布局
this.setDefaultCloseOperation(this.EXIT_ON_CLOSE);
han_biaoti_label = new JLabel("学生信息管理系统");
han_biaoti_label.setBounds(50, 40, 400, 40);
han_biaoti_label.setFont(max);
this.add(han_biaoti_label);
english_biaoti_label = new JLabel("Student information Manager System");
english_biaoti_label.setBounds(110, 80, 400, 40);
english_biaoti_label.setFont(min);
this.add(english_biaoti_label);
user_label = new JLabel("用户名:");
user_label.setBounds(100, 150, 70, 30);
user_label.setFont(min);
this.add(user_label);
user_field = new JTextField();
user_field.setBounds(190, 150, 180, 30);
this.add(user_field);
user_password_label = new JLabel("密 碼:");
user_password_label.setBounds(100, 200, 70, 30);
user_password_label.setFont(min);
this.add(user_password_label);
user_password = new JPasswordField();
user_password.setBounds(190, 200, 180, 30);
this.add(user_password);
login_button = new JButton("登 录");
login_button.setBounds(120, 260, 100, 35);
login_button.setFont(min);
//System.out.println("ssss");
login_button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
//System.out.println("ssss");
String user_name = user_field.getText();
String user_pw = user_password.getText();
try {
//System.out.println("ssss");
Connection con = null; // 定义一个MYSQL链接对象
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager
.getConnection(
"jdbc:mysql://127.0.0.1:3306/student_register_manager",
"root", "54zhangqi"); // 链接本地MYSQL
Statement stat=con.createStatement();//声明
ResultSet res= stat.executeQuery("select * from user_register");//执行查询
if (res.next()) {
if (res.getString("user_name").equals(user_name)&&res.getString("user_password").equals(user_pw)) {
dispose();
new Main();
} else {
JOptionPane.showMessageDialog(null, "登录失败!", "提示",
JOptionPane.ERROR_MESSAGE);
}
}
} catch (Exception e2) {
System.out.println("yc"+e2.getMessage());
}
}
});
this.add(login_button);
exit_button = new JButton("退 出");
exit_button.setBounds(260, 260, 100, 35);
exit_button.setFont(min);
exit_button.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
System.exit(0);
}
});
this.add(exit_button);
this.setVisible(true);
}
public static void main(String[] args) {
new Login();
}
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
}
}
package jiemian;
import java.awt.Color;
import java.awt.Font;
import java.awt.GridLayout;
import java.awt.Image;
import java.awt.MenuBar;
import java.awt.Window;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import javax.swing.ImageIcon;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.WindowConstants;
import menuItem_jiemian.banjiInfor;
import menuItem_jiemian.banjiInforXiugai;
import menuItem_jiemian.kaifaInfor;
import menuItem_jiemian.personInforXiugai;
import menuItem_jiemian.personInformation;
import menuItem_jiemian.pwMimaxiugai;
import menuItem_jiemian.xinZeng;
public class Main extends JFrame implements ActionListener {
private JLabel jLabel1;
private JLabel jLabel2;
private JLabel jLabel3;
private JMenu help_menu;
private JMenu information_weihu;
private JMenu infor_check;
private JMenu guanyu;
public Main() {
// 创建窗体事件
addWindowListener(new WindowAdapter() {
public void windowClosing(final WindowEvent e) {
Main.this.dispose();
}
});
Font max=new Font("楷体",Font.BOLD,48);
Font min=new Font("楷体",Font.ITALIC,32);
JPanel jPanel = new JPanel();
this.setContentPane(jPanel);
GridLayout gridLayout = new GridLayout(3, 0);
jPanel.setLayout(gridLayout);
ImageIcon ima_main_background = new ImageIcon("src/main_background.jpg");
JLabel ima_background_label = new JLabel(ima_main_background);
int height = 500;
int width = 700;
ima_main_background.setImage(ima_main_background.getImage()
.getScaledInstance(width, height, Image.SCALE_DEFAULT));
ima_background_label.setSize(width, height);
this.getLayeredPane().add(ima_background_label,
new Integer(Integer.MIN_VALUE));
this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
jPanel.setOpaque(false);// 设置面板不透明
this.setResizable(false);
countComponents();// 构造一个新的 Container容器。
setTitle("学生信息管理系统");
setBounds(350, 150, 700, 500);// 设置位置
this.setLayout(null);
jLabel1=new JLabel("明德 至善");
jLabel1.setFont(max);
jLabel1.setBounds(120, 100, 400, 50);
this.add(jLabel1);
jLabel2=new JLabel("博学 笃行");
jLabel2.setFont(max);
jLabel2.setBounds(220, 190, 400, 50);
this.add(jLabel2);
jLabel3=new JLabel("——淮南师范学院");
jLabel3.setFont(min);
jLabel3.setBounds(380, 280, 400, 50);
jLabel3.setForeground(Color.BLUE);
this.add(jLabel3);
JMenuBar bar = new JMenuBar();
information_weihu = new JMenu("信息维护");
JMenuItem person_check_infor = new JMenuItem("个人信息查询");
person_check_infor.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new personInformation();
}
});
JMenuItem pw_xiugai = new JMenuItem("密码修改");
pw_xiugai.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new pwMimaxiugai();
}
});
information_weihu.add(person_check_infor);
information_weihu.add(pw_xiugai);
infor_check=new JMenu("信息查询");
JMenuItem banji_infor_check=new JMenuItem("班级信息查询");
banji_infor_check.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new banjiInfor();
}
});
JMenuItem banji_infor_tianjia=new JMenuItem("同学信息添加");
banji_infor_tianjia.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new xinZeng();
}
});
JMenuItem banji_infor_xiugai=new JMenuItem("班级信息修改");
banji_infor_xiugai.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new banjiInforXiugai();
}
});
JMenuItem person_infor_xiugai=new JMenuItem("个人信息修改");
person_infor_xiugai.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new personInforXiugai();
}
});
infor_check.add(banji_infor_check);
infor_check.add(banji_infor_tianjia);
infor_check.add(banji_infor_xiugai);
infor_check.add(person_infor_xiugai);
help_menu=new JMenu("帮助");
JMenuItem help_item=new JMenuItem("帮助");
help_item.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
}
});
help_menu.add(help_item);
guanyu =new JMenu("关于");
JMenuItem guanyu_kaifa=new JMenuItem("开发人员");
guanyu_kaifa.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
new kaifaInfor();
}
});
guanyu.add(guanyu_kaifa);
bar.add(infor_check);
bar.add(information_weihu);
bar.add(help_menu);
bar.add(guanyu);
setJMenuBar(bar);// 在窗口中添加菜单栏
this.setVisible(true);
}
public static void main(String[] args) {
new Main();
}
@Override
public void actionPerformed(ActionEvent e) {
// TODO Auto-generated method stub
}
}
package db;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class connectDb {
private Connection con;
private Statement stat;
public connectDb() {
try {
Class.forName("com.mysql.jdbc.Driver"); //MYSQL驱动
con = DriverManager
.getConnection(
"jdbc:mysql://127.0.0.1:3306/student_register_manager",
"root", "54zhangqi"); // 链接本地MYSQL
stat=con.createStatement();//声明
} catch (Exception e) {
System.out.print("MYSQL ERROR:" + e.getMessage());
}
try {
stat = con.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
}
public java.sql.ResultSet query(String sql) throws SQLException {
return stat.executeQuery(sql);
}
/**
* 执行
* @param sql
* @return
* @throws SQLException
*/
public Boolean execute(String sql) throws SQLException {
return stat.execute(sql);
}
}
package menuItem_jiemian;
import java.awt.Color;
import java.awt.Font;
import java.awt.Window;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.sql.ResultSet;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.WindowConstants;
import db.connectDb;
import jiemian.Main;
public class personInformation extends JFrame implements ActionListener{
//学号
private JLabel jl_student_number;
private JTextField jt_student_number;
private JButton jb_student_number;
// private JLabel jl_student_name;
// private JButton jb_student_name;
//姓名
private JLabel jl_name;
private JTextField jt_name;
//性别
private JLabel jl_sex;
private JTextField jt_sex;
//民族
private JLabel jl_nation;
private JTextField jt_nation;
//照片
private JLabel jl_photo;
private JLabel photo;
//学院
private JLabel jl_xueyuan;
private JTextField jt_xueyuan;
//专业
private JLabel jl_zhuanye;
private JTextField jt_zhuanye;
//班级
private JLabel jl_banji;
private JTextField jt_banji;
//联系方式
private JLabel jl_mobile_phone;
private JTextField jt_mobile_phone;
private JLabel jl_qq_number;
private JTextField jt_qq_number;
//邮编
private JLabel jl_youbian;
private JTextField jt_youbian;
//父母姓名
private JLabel jl_father;
private JLabel jl_mather;
private JTextField jt_father;
private JTextField jt_mather;
//家庭住址
private JLabel jl_home_address;
private JTextField jt_home_address;
//备注
private JLabel jl_jiangcheng;
private JTextField jt_jiangcheng;
//窗体事件
public personInformation(){
addWindowListener(new WindowAdapter() {
public void WindowClose(Window event) {
personInformation.this.dispose();
}
});
Font kaiti1=new Font("kaiti", Font.BOLD, 20);
Font kaiti2=new Font("kaiti", Font.BOLD, 16);
JPanel jPanel=new JPanel();
this.setContentPane(jPanel);
// GridLayout layout=new GridLayout(3, 0);//定义grid布局
// jPanel.setLayout(layout);//向面板中添加布局
this.setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
jPanel.setOpaque(false);
setTitle("学生信息查询");
setBounds(250,50,900,600);
this.setResizable(false);// 设置窗体不可以调整大小
this.setLayout(null);
jl_student_number=new JLabel("学号:");
jl_student_number.setBounds(250,25,80,30);
jl_student_number.setFont(kaiti1);
this.add(jl_student_number);
jt_student_number=new JTextField();
jt_student_number.setBounds(320, 25, 170, 30);
jt_student_number.setFont(kaiti1);
this.add(jt_student_number);
jb_student_number=new JButton("查 询");
jb_student_number.setBounds(500, 25, 100, 30);
jb_student_number.setFont(kaiti1);
jb_student_number.addActionListener(this);
this.add(jb_student_number);
jl_name=new JLabel("姓 名:");
jl_name.setBounds(50, 80, 80, 30);
jl_name.setFont(kaiti1);
this.add(jl_name);
jt_name=new JTextField();
jt_name.setBounds(120, 80, 120, 30);
jt_name.setFont(kaiti2);
jt_name.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_name);
jl_sex=new JLabel("性 别:");
jl_sex.setBounds(270, 80, 80, 30);
jl_sex.setFont(kaiti1);
this.add(jl_sex);
jt_sex=new JTextField();
jt_sex.setBounds(340, 80, 40, 30);
jt_sex.setFont(kaiti2);
jt_sex.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_sex);
jl_nation=new JLabel("民 族:");
jl_nation.setBounds(410, 80, 80, 30);
jl_nation.setFont(kaiti1);
this.add(jl_nation);
jt_nation=new JTextField();
jt_nation.setBounds(480, 80, 120, 30);
jt_nation.setFont(kaiti2);
jt_nation.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_nation);
jl_photo=new JLabel("照 片:");
jl_photo.setBounds(630, 80, 80, 30);
jl_photo.setFont(kaiti1);
this.add(jl_photo);
photo=new JLabel();
photo.setBounds(680, 80, 100, 120);
photo.setBackground(Color.black);
this.add(photo);
jl_xueyuan=new JLabel("学 院:");
jl_xueyuan.setBounds(50, 150, 80, 30);
jl_xueyuan.setFont(kaiti1);
this.add(jl_xueyuan);
jt_xueyuan=new JTextField();
jt_xueyuan.setBounds(120, 150, 120, 30);
jt_xueyuan.setFont(kaiti2);
jt_xueyuan.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_xueyuan);
jl_zhuanye=new JLabel("专 业:");
jl_zhuanye.setBounds(270, 150, 80, 30);
jl_zhuanye.setFont(kaiti1);
this.add(jl_zhuanye);
jt_zhuanye=new JTextField();
jt_zhuanye.setBounds(340, 150, 180, 30);
jt_zhuanye.setFont(kaiti2);
jt_zhuanye.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_zhuanye);
jl_banji=new JLabel("班 级:");
jl_banji.setBounds(540,150, 80, 30);
jl_banji.setFont(kaiti1);
this.add(jl_banji);
jt_banji=new JTextField();
jt_banji.setBounds(610, 150, 83, 30);
jt_banji.setFont(kaiti2);
jt_banji.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_banji);
jl_mobile_phone=new JLabel("联系方式:");
jl_mobile_phone.setBounds(50, 210, 100, 30);
jl_mobile_phone.setFont(kaiti1);
this.add(jl_mobile_phone);
jt_mobile_phone=new JTextField();
jt_mobile_phone.setBounds(160, 210, 180, 30);
jt_mobile_phone.setFont(kaiti2);
jt_mobile_phone.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_mobile_phone);
jl_qq_number=new JLabel("QQ号:");
jl_qq_number.setBounds(360, 210, 80, 30);
jl_qq_number.setFont(kaiti1);
this.add(jl_qq_number);
jt_qq_number=new JTextField();
jt_qq_number.setBounds(425, 210, 180, 30);
jt_qq_number.setFont(kaiti2);
jt_qq_number.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_qq_number);
jl_youbian=new JLabel("邮 编:");
jl_youbian.setBounds(625, 210, 80, 30);
jl_youbian.setFont(kaiti1);
this.add(jl_youbian);
jt_youbian=new JTextField();
jt_youbian.setBounds(720, 210, 100, 30);
jt_youbian.setFont(kaiti2);
jt_youbian.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_youbian);
jl_father=new JLabel("父 亲:");
jl_father.setBounds(50, 270, 80, 30);
jl_father.setFont(kaiti1);
this.add(jl_father);
jt_father=new JTextField();
jt_father.setBounds(130, 270, 100, 30);
jt_father.setFont(kaiti2);
jt_father.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_father);
jl_mather=new JLabel("母 亲:");
jl_mather.setBounds(255, 270, 80, 30);
jl_mather.setFont(kaiti1);
this.add(jl_mather);
jt_mather=new JTextField();
jt_mather.setBounds(340, 270, 100, 30);
jt_mather.setFont(kaiti2);
jt_mather.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_mather);
jl_home_address=new JLabel("家庭住址:");
jl_home_address.setBounds(50, 330, 100, 30);
jl_home_address.setFont(kaiti1);
this.add(jl_home_address);
jt_home_address=new JTextField();
jt_home_address.setBounds(160,330, 660, 30);
jt_home_address.setFont(kaiti2);
jt_home_address.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_home_address);
jl_jiangcheng=new JLabel("奖 惩:");
jl_jiangcheng.setBounds(50, 390, 80, 30);
jl_jiangcheng.setFont(kaiti1);
this.add(jl_jiangcheng);
jt_jiangcheng=new JTextField();
jt_jiangcheng.setBounds(150, 390, 660, 160);
jt_jiangcheng.setFont(kaiti2);
jt_jiangcheng.setHorizontalAlignment(JTextField.CENTER);
this.add(jt_jiangcheng);
this.setVisible(true);
}
public static void main(String args[]){
new personInformation();
}
@Override
public void actionPerformed(ActionEvent e) {
Object button =e.getSource();
connectDb db=new connectDb();
String student_number_check=jt_student_number.getText();
//System.out.println("sss");
if (button.equals(jb_student_number)) {
//System.out.println("sss");
String sql="select * from student_infor";
ResultSet rs = null;//执行查询
try {
rs=db.query(sql);
if (rs.next()) {
if (rs.getString("student_number").equals(student_number_check)) {
//System.out.println("sss"); jt_name.setText(rs.getString("student_name")); jt_sex.setText(rs.getString("student_sex"));
jt_nation.setText(rs.getString("nation")); jt_xueyuan.setText(rs.getString("xueyuan")); jt_zhuanye.setText(rs.getString("zhuanye"));
jt_banji.setText(rs.getString("banji")); jt_mobile_phone.setText(rs.getString("mobile_telephone")); jt_qq_number.setText(rs.getString("QQ_number")); jt_youbian.setText(rs.getString("youbian")); jt_father.setText(rs.getString("father_name")); jt_mather.setText(rs.getString("mather_name")); jt_home_address.setText(rs.getString("home_address")); jt_jiangcheng.setText(rs.getString("jiangcheng"));
}
}
} catch (Exception e2) {
System.out.println("出错"+e2.getMessage());
}
} else {
}
}
}