第1页 / 共47页
第2页 / 共47页
第3页 / 共47页
第4页 / 共47页
第5页 / 共47页
第6页 / 共47页
第7页 / 共47页
第8页 / 共47页
学生信息管理系统完整源代码+mysql文件.doc
数据库所用的数据自己导入 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` VALUES ('张三', '男', '2010303755', '数学', '2', '2010-02-
12');
INSERT INTO `studentinfo` VALUES ('李四', '男', '2010303760', '物理', '1', '1995.9.6');
INSERT INTO `studentinfo` VALUES ('王二', '女', '2010303761', '应数', '2',
'1990.9.11');
INSERT INTO `studentinfo` VALUES ('麻子', '女', '2010303762', '信计', '1',
'1999.9.10');
INSERT INTO `userinfo` VALUES ('1', '1', '1');
INSERT INTO `userinfo` VALUES ('13', '13', '1');
INSERT INTO `userinfo` VALUES ('2', '2', '2');
INSERT INTO `userinfo` VALUES ('3', '3', '3');
INSERT INTO `userinfo` VALUES ('6', '6', '6');
INSERT INTO `userinfo` VALUES ('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{
con=DriverManager.getConnection(conURL,"root","123456");
Statement st=con.createStatement();
Connection
values('"+tf1.getText()+"','"+tf2.getText()+"','"+
String
s="insert
into
studentinfo
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");
相关推荐
2023年江西萍乡中考道德与法治真题及答案.doc
2012年重庆南川中考生物真题及答案.doc
2013年江西师范大学地理学综合及文艺理论基础考研真题.doc
2020年四川甘孜小升初语文真题及答案I卷.doc
2020年注册岩土工程师专业基础考试真题及答案.doc
2023-2024学年福建省厦门市九年级上学期数学月考试题及答案.doc
2021-2022学年辽宁省沈阳市大东区九年级上学期语文期末试题及答案.doc
2022-2023学年北京东城区初三第一学期物理期末试卷及答案.doc
2018上半年江西教师资格初中地理学科知识与教学能力真题及答案.doc
2012年河北国家公务员申论考试真题及答案-省级.doc
2020-2021学年江苏省扬州市江都区邵樊片九年级上学期数学第一次质量检测试题及答案.doc
2022下半年黑龙江教师资格证中学综合素质真题及答案.doc
