java学生信息管理系统课程设计_基于Java的学生信息管理系统课程设计论文

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;

//QQ

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 {

}

}

}