学生信息管理系统完整源代码+mysql文件

数据库所用的数据自己导入MYSQL5.5，Navicat8就可以用了。

下面是具体的数据资料

/*

MySQL Data Transfer

Source Host: localhost

Source Database: sims

Target Host: localhost

Target Database: sims

Date: 2013-6-25 9:24:26

*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------

-- Table structure for manager

-- ----------------------------

DROP TABLE IF EXISTS `manager`;

CREATE TABLE `manager` (

`id` varchar(10) NOT NULL,

`name` varchar(30) NOT NULL,

`Mima` varchar(20) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Table structure for studentinfo

-- ----------------------------

DROP TABLE IF EXISTS `studentinfo`;

CREATE TABLE `studentinfo` (

`Sname` varchar(30) NOT NULL,

`Ssex` varchar(10) NOT

NULL,

`Snumber` varchar(10) NOT NULL,

`Sprofession` varchar(30) NOT NULL,

`Sclass`

varchar(20) NOT NULL,

`Sdate` varchar(30) character set utf8 collate utf8_unicode_ci

NOT NULL,

PRIMARY KEY (`Snumber`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='InnoDB

free: 4096 kB';

-- ----------------------------

-- Table structure for userinfo

-- ----------------------------

DROP TABLE IF EXISTS `userinfo`;

CREATE TABLE `userinfo` (

`id` varchar(10) NOT NULL,

`name` varchar(30) NOT NULL,

`Mima` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL, PRIMARY KEY

(`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------

-- Records

-- ----------------------------

INSERT INTO `manager` VALUES ('1', '1', '2');

INSERT INTO `manager` VALUES ('2', '恩恩', '123456');

INSERT INTO `manager` VALUES ('3', '大大', '123456');

INSERT INTO `manager` VALUES ('4', '啊啊', '123456');

INSERT INTO `manager` VALUES ('5', '5', '5');

INSERT INTO `manager` VALUES ('6', '孙霞', '123456');

INSERT INTO `studentinfo` V ALUES ('张三', '男', '2010303755', '数学', '2', '2010-02- 12');

INSERT INTO `studentinfo` V ALUES ('李四', '男', '2010303760', '物理', '1', '1995.9.6'); INSERT INTO `studentinfo` V ALUES ('王二', '女', '2010303761', '应数', '2',

'1990.9.11');

INSERT INTO `studentinfo` V ALUES ('麻子', '女', '2010303762', '信计', '1',

'1999.9.10');

INSERT INTO `userinfo` V ALUES ('1', '1', '1');

INSERT INTO `userinfo` V ALUES ('13', '13', '1');

INSERT INTO `userinfo` V ALUES ('2', '2', '2');

INSERT INTO `userinfo` V ALUES ('3', '3', '3');

INSERT INTO `userinfo` V ALUES ('6', '6', '6');

INSERT INTO `userinfo` V ALUES ('7', '7', '6');

下面是相应的程序：

package MS;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener; import java.awt.Color;

import java.awt.Container;

import java.awt.Dimension;

import java.awt.GridLayout;

import java.awt.Toolkit;

import java.awt.event.FocusEvent;

import java.awt.event.FocusListener;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

public class Add implements ActionListener {

JFrame f1;

Container ct;

JPanel jp,jp1,jp2,jp3;

JButton btn1,btn2;

JLabel label;

JTextField tf1,tf2,tf3,tf4,tf5,tf6;

Add(){

f1=new JFrame();

ct=f1.getContentPane();//初始化面板

jp=new JPanel();

jp1=new JPanel(new GridLayout(6,1));

jp2=new JPanel(new GridLayout(6,1));

jp3=new JPanel();

btn1=new JButton("确定");

btn2=new JButton("取消");

label=new JLabel("添加学生信息",SwingConstants.CENTER);

label.setForeground(Color.gray);

tf1=new JTextField(20);

tf2=new JTextField(20);

tf3=new JTextField(20);

tf4=new JTextField(20);

tf5=new JTextField(20);

tf6=new JTextField(20);

tf6.setText("例：2000-02-02");

//文本框加入提示语

tf6.addFocusListener(new FocusListener(){

public void focusGained(FocusEvent e) {

tf6.setText("");

}

public void focusLost(FocusEvent e) {}

});

jp.add(label);

ct.add(jp,"North");

jp1.add(new JLabel("姓名",SwingConstants.CENTER));

jp2.add(tf1);

jp1.add(new JLabel("性别",SwingConstants.CENTER));

jp2.add(tf2);

jp1.add(new JLabel("学号",SwingConstants.CENTER));

jp2.add(tf3);

jp1.add(new JLabel("专业",SwingConstants.CENTER));

jp2.add(tf4);

jp1.add(new JLabel("班级",SwingConstants.CENTER));

jp2.add(tf5);

jp1.add(new JLabel("入学时间",SwingConstants.CENTER));

jp2.add(tf6);

jp3.add(btn1);

jp3.add(btn2);

ct.add(jp1,"West");

ct.add(jp2,"East");

ct.add(jp3,"South");

Toolkit kit=Toolkit.getDefaultToolkit();

Dimension screen=kit.getScreenSize();

int x=screen.width;

int y=screen.height;

f1.setSize(350,330);

int xcenter=(x-350)/2;

int ycenter=(y-330)/2;

f1.setLocation(xcenter, ycenter);

f1.setVisible(true);

//f1.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

btn1.addActionListener(this);

btn2.addActionListener(this);

}

public void insert(){

if(tf1.getText().equals("")||tf2.getText().equals("")||tf3.getText().equals("")||

tf4.getText().equals("")||tf5.getText().equals("")||tf6.getText().equals("")){

JOptionPane.showMessageDialog(f1,"请填写完整信息");

return;

}

try{

Class.forName("com.mysql.jdbc.Driver");

}catch(ClassNotFoundException e){

System.out.print("加载驱动程序失败");

}

String conURL="jdbc:mysql://localhost:3306/sims";

try{

Connection

con=DriverManager.getConnection(conURL,"root","123456");

Statement st=con.createStatement();

String s="insert into studentinfo values('"+tf1.getText()+"','"+tf2.getText()+"','"+

tf3.getText()+"','"+tf4.getText()+"','"+tf5.getText()+"','"+tf6.getText()+"');";

String query="select * from studentinfo where Snumber='"+tf3.getText().trim()+"'";

ResultSet res=st.executeQuery(query);

if(res.next()){

JOptionPane.showMessageDialog(f1,"学号信息已经存在！");

con.close();

tf3.setText("");

}else if(tf6.getText().length()!=10){

JOptionPane.showMessageDialog(f1,"入学时间格式有误!");

con.close();

tf6.setText("");

}

int insert=st.executeUpdate(s);

if(insert==1){

JOptionPane.showMessageDialog(f1,"录入信息成功！");

tf1.setText("");

tf2.setText("");

tf3.setText("");

tf4.setText("");

tf5.setText("");

tf6.setText("");

}

}catch(SQLException e){

System.out.println("错误代码："+e.getErrorCode());

System.out.println("错误信息："+e.getMessage());

}

}

@SuppressWarnings("deprecation")

public void actionPerformed(ActionEvent e){

String cmd=e.getActionCommand();

if(cmd.equals("确定")){

insert();

}

else if(cmd.equals("取消")){

f1.hide();

}

}

public Container getCt()

{

return ct;

}

public void setCt(Container ct)

{

this.ct = ct;

}

}

package MS;

import java.awt.BorderLayout;

import java.awt.Color;

import java.awt.Container;

import java.awt.Dimension;

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.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

public class Delete implements ActionListener {

JFrame f2;

Container ct;

JPanel jp1,jp2,jp3,jp4;

JLabel label;

JTextField text;

JTable table;//接收数据库中返回的信息

JButton btn1,btn2,btn3;

Object columnName[]={"姓名","性别","学号","专业","班级","入学时间"};

Object ar[][]=new Object[80][6];

Delete(){

f2=new JFrame();

ct=f2.getContentPane();

jp1=new JPanel();

jp2=new JPanel();

jp3=new JPanel();

jp4=new JPanel();

label=new JLabel();

text=new JTextField();

btn1=new JButton("查询");

btn2=new JButton("删除");

btn3=new JButton("取消");

label=new JLabel("请输入要删除的学生姓名:",SwingConstants.CENTER);

label.setBackground(Color.blue);

table=new JTable(ar,columnName);

JScrollPane scroll=new JScrollPane(table);

text=new JTextField(20);

jp2.add(btn1);

jp2.add(btn2);

jp2.add(btn3);

jp1.add(label);

jp1.add(text);

ct.add(jp1,"North");

jp3.setLayout(new BorderLayout());

jp3.add(new JLabel("学生信息如下"));

jp3.add(scroll);

ct.add(jp2,"South");

ct.add(jp3,"Center");

Toolkit kit=Toolkit.getDefaultToolkit();

Dimension screen=kit.getScreenSize();

int x=screen.width;

int y=screen.height;

f2.setSize(450, 400);

int xcenter=(x-450)/2;

int ycenter=(y-400)/2;

f2.setLocation(xcenter, ycenter);

f2.setVisible(true);

//f2.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

btn1.addActionListener(this);

btn2.addActionListener(this);

btn3.addActionListener(this);

}

int i=0;

public void show(String s){

while(i>=0)

{

ar[i][0]="";

ar[i][1]="";

ar[i][2]="";

ar[i][3]="";

ar[i][4]="";

ar[i][5]="";

i--;

}

i=0;

try{

Class.forName("com.mysql.jdbc.Driver");

}catch(ClassNotFoundException e){

System.out.print("加载驱动程序失败");

}

String conURL="jdbc:mysql://localhost:3306/sims";

try{

Connection con=DriverManager.getConnection(conURL,"root","123456");

Statement st=con.createStatement();

String sql="select * from studentinfo where Sname='"+s+"'";

ResultSet res=st.executeQuery(sql);

/*if(!(res.next())){

JOptionPane.showMessageDialog(f,"所要查询的信息不存在");

} */

while(res.next()){

String sName=res.getString(1);

String sSex=res.getString(2);

String sNumber=res.getString(3);

String sProfession=res.getString(4);

String sClass=res.getString(5);

String sDate=res.getString(6);

ar[i][0]=sName;

ar[i][1]=sSex;

ar[i][2]=sNumber;

ar[i][3]=sProfession;

ar[i][4]=sClass;

ar[i][5]=sDate;

i++;

}

f2.repaint();

con.close();

}catch(SQLException e){

System.out.println("错误代码："+e.getErrorCode());

System.out.println("错误信息："+e.getMessage());

}

}

public void delete(int line){

try{

Class.forName("com.mysql.jdbc.Driver");

}catch(ClassNotFoundException e){

System.out.print("加载驱动程序失败");

}

String conURL="jdbc:mysql://localhost:3306/sims";

try{

Connection con=DriverManager.getConnection(conURL,"root","123456");

Statement st=con.createStatement();

String name=(String)(ar[line][2]);

String sql="delete from studentinfo where Snumber ='"+name+"'";

int del=st.executeUpdate(sql);

if(del==1){

ar[line][0]="";

ar[line][1]="";

ar[line][2]="";

ar[line][3]="";

ar[line][4]="";

ar[line][5]="";

JOptionPane.showMessageDialog(null,"删除成功！",

"信息", JOptionPane.YES_NO_OPTION);

}

con.close();

f2.repaint();

}catch(SQLException e){

System.out.println("错误代码："+e.getErrorCode());

System.out.println("错误信息："+e.getMessage());

}

}

@SuppressWarnings("deprecation")

public void actionPerformed(ActionEvent e){

String cmd=e.getActionCommand();

if(cmd.equals("查询")){

String qu=text.getText().trim();

show(qu);

}

if(cmd.equals("删除")){

int de=table.getSelectedRow();

if(de==-1){

JOptionPane.showMessageDialog(null,"请选定要删除的行",

"错误信息", JOptionPane.YES_NO_OPTION);

}

else{

delete(de);

}

}

if(cmd.equals("取消")){

f2.hide();

}

}

}

package MS;

import java.awt.Color;

import java.awt.Container;

import java.awt.Dimension;

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.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.SwingConstants;

public class Liulan implements ActionListener {

JFrame f4;

Container ct;

JPanel jp1,jp2,jp3,jp4;

JLabel label;

JButton btn1,btn2;

JTable table;

Object[][] ar=new Object[80][6];

Object[] columnName={"姓名","性别","学号","专业","班级","入学时间"};

Liulan(){

f4=new JFrame();

ct=f4.getContentPane();

jp1=new JPanel();

jp2=new JPanel();

jp3=new JPanel();

jp4=new JPanel();

btn1=new JButton("点击浏览");

btn2=new JButton(" 取消");

label=new JLabel("学生信息浏览",SwingConstants.CENTER);

label.setBackground(Color.blue);

table=new JTable(ar, columnName);

JScrollPane scroll=new JScrollPane(table);

jp1.add(label);

jp2.add(btn1);

jp2.add(btn2);

jp3.add(scroll);

ct.add(jp1,"North");

ct.add(jp3,"Center");

ct.add(jp2,"South");

Toolkit kit=Toolkit.getDefaultToolkit();

Dimension screen=kit.getScreenSize();

int x=screen.width;

int y=screen.height;

f4.setSize(500,530);

int xcen=(x-500)/2;

int ycen=(y-530)/2;

f4.setLocation(xcen,ycen);

f4.setVisible(true);

btn1.addActionListener(this);

btn2.addActionListener(this);

}

int i=0;

public void select(){

while(i>=0){

ar[i][0]="";

ar[i][1]="";

ar[i][2]="";

ar[i][3]="";

ar[i][4]="";

ar[i][5]="";

i--;

}

i=0;

try{

Class.forName("com.mysql.jdbc.Driver");

}catch(ClassNotFoundException e){

System.out.print("加载驱动程序失败");

}

String conURL="jdbc:mysql://localhost:3306/sims";

try{

Connection con=DriverManager.getConnection(conURL,"root","123456");

Statement st=con.createStatement();

String s="select * from studentinfo";

ResultSet res=st.executeQuery(s);

while(res.next()){

String sName=res.getString(1);

String sSex=res.getString(2);

String sNumber=res.getString(3);

String sProfession=res.getString(4);

String sClass=res.getString(5);

String sDate=res.getString(6);

ar[i][0]=sName;

ar[i][1]=sSex;

ar[i][2]=sNumber;

ar[i][3]=sProfession;

ar[i][4]=sClass;

ar[i][5]=sDate;

i++;

}

f4.repaint();

con.close();

}catch(SQLException e){

System.out.println("错误代码："+e.getErrorCode());

System.out.println("错误信息："+e.getMessage());

}

}

@SuppressWarnings("deprecation")

public void actionPerformed(ActionEvent e){

// TODO Auto-generated method stub

String cmd=e.getActionCommand();

if(cmd.equals("点击浏览")){

select();

}else if(cmd.equals(" 取消")){

f4.hide();

}

}

}

package MS;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.Color;

import java.awt.Container;

import java.awt.Dimension;

import java.awt.Toolkit;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.sql.Connection;

import java.sql.DriverManager;

import javax.swing.ButtonGroup;

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.JRadioButton;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

@SuppressWarnings("serial")

public class Login extends JFrame implements ActionListener {

Container cp=null;

JFrame f=null;

JButton button1,button2,button3;

JTextField t1;

JPasswordField t2;

JLabel jlable1,jlable2;

JRadioButton rabtn1,rabtn2;

Color c;

JPanel jp1,jp2,jp3;

String table=null;

Login(){

f=new JFrame("学生信息管理系统");

button1=new JButton("确定");

button2=new JButton("取消");

button3=new JButton("注册");

//button3.setOpaque(false);

button3.setBorder(null);

button3.setBackground(Color.getColor("#292421"));

rabtn1=new JRadioButton("普通用户");

rabtn1.setBackground(Color.getColor("#292421"));

rabtn2=new JRadioButton("管理员");

rabtn2.setBackground(Color.getColor("#292421"));

ButtonGroup group=new ButtonGroup();

group.add(rabtn1);

group.add(rabtn2);

cp=f.getContentPane();

jlable1=new JLabel("输入用户号");

jlable2=new JLabel("输入密码");

jp1=new JPanel();

jp2=new JPanel();

jp3=new JPanel();

t1=new JTextField(20);

t2=new JPasswordField(20);

//jp3.add(group);

jp1.add(jlable1);

jp1.add(t1);

jp1.add(jlable2);

jp1.add(t2);

jp1.add(rabtn1);

jp1.add(rabtn2);

jp1.add(button3);

JLabel JL=new JLabel("欢迎登陆" + "",SwingConstants.CENTER);

cp.add(JL,"North");

jp2.add(button1);

jp2.add(button2);

cp.add(jp1,"Center");

cp.add("South",jp2);

cp.setBackground(new Color(127, 255, 212 ));

jp2.setBackground(new Color(127, 255, 212 ));

jp1.setBackground(new Color(127, 255, 212 ));

Toolkit kit=Toolkit.getDefaultToolkit();

Dimension screen=kit.getScreenSize();

int x=screen.width;

int y=screen.height;

f.setSize(250,300);

int xcenter=(x-300)/2;

int ycenter=(y-300)/2;

f.setLocation(xcenter,ycenter);/*显示在窗口中央*/

f.setVisible(true);

//f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

//------------------------------------------------------------//

/*监听事件*/

button1.addActionListener(this);

button2.addActionListener(this);

button3.addActionListener(this);

rabtn1.addItemListener(new ItemListener()

{

public void itemStateChanged(ItemEvent e)

{

JRadioButton jop=(JRadioButton) e.getSource();

if (jop.isSelected())

table="userinfo";

}

});

rabtn2.addItemListener(new ItemListener()

{

public void itemStateChanged(ItemEvent e)

{

JRadioButton jop=(JRadioButton) e.getSource();

if (jop.isSelected())

table="manager";

}

});

f.addWindowListener(new WindowAdapter(){

public void windowClosing(WindowEvent e){

System.exit(0);

}

});

}

@SuppressWarnings("deprecation")

public void confirm(String tableName){

try{

Class.forName("com.mysql.jdbc.Driver");

}catch(ClassNotFoundException e){

System.out.print("加载驱动程序失败");

}

String conURL="jdbc:mysql://localhost:3306/sims";

try{

Connection con=DriverManager.getConnection(conURL,"root","123456");

Statement st=con.createStatement();

String id=t1.getText().trim();

String Mima=t2.getText().trim();

String queryMima="select * from "+tableName+" where id='"+id+"' and mima='"+Mima+"'";

ResultSet res=st.executeQuery(queryMima);

if(res.next()){

if(tableName.equals("manager"))

new Mstudent(id);

else if(tableName.equals("userinfo"))

new Ustudent(id);

f.hide();

con.close();

}else{

JOptionPane.showMessageDialog(null,"密码错误请重输！！！","提示！",

JOptionPane.YES_NO_OPTION);

}

t1.setText("");

t2.setText("");

}catch(SQLException g)

{

System.out.println("错误代码："+g.getErrorCode());

System.out.println("错误内容："+g.getMessage());

}

}

ItemListener listen=new ItemListener(){

public void itemStateChanged(ItemEvent e) {

// TODO Auto-generated method stub

}

};

public void actionPerformed(ActionEvent e)

{

String cmd=e.getActionCommand();

if(cmd.equals("确定")){

if(table==null){

JOptionPane.showMessageDialog(f,"请选择用户类型");

}

confirm(table);

}

else if(cmd.equals("取消")){

f.dispose();

}else if(cmd.equals("注册")){

new Regist();

}

}

public static void main(String []arg){

new Login();

}

}

package MS;

import java.awt.BorderLayout;

import java.awt.Color;

import java.awt.Container;

import java.awt.Dimension;

import java.awt.Toolkit;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.BorderFactory;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JMenuBar;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.SwingConstants;

import javax.swing.border.TitledBorder;

@SuppressWarnings("serial")

public class Mstudent extends JFrame implements ActionListener {

JButton Query = new JButton("查询信息");

JButton add = new JButton("添加信息");