java mysql学籍管理系统_java-Mysql学生管理系统

Window1//主方法

package stu_zizhu1;

import java.awt.Button;

import java.awt.Color;

import java.awt.Dimension;

import java.awt.FlowLayout;

import java.awt.Point;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JPanel;

public class Window1 {

public static void main(String[] args) {

JFrame jf=new JFrame("学生管理系统");

JButton b1=new JButton("添加");

JButton b2=new JButton("查找");

JButton b3=new JButton("修改");

JButton b4=new JButton("删除");

JButton b5=new JButton("浏览");

FlowLayout flow = new FlowLayout(FlowLayout.LEFT,10,10);

JPanel jp=new JPanel(flow);

jp.add(b1);

jp.add(b2);

jp.add(b3);

jp.add(b4);

jp.add(b5);

jf.add(jp);

jp.setBackground(Color.red);

jf.setSize(500,500);

jf.setLocation(500,500);

jf.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

jf.setVisible(true);

b1.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

Add1 a1=new Add1();

}

});

b2.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

Find1 find1=new Find1();

}

});

b3.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

Modify1 modify1=new Modify1();

}

});

b4.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

Delete1 delete1=new Delete1();

}

});

b5.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) {

Look1 look1=new Look1();

}

});

}

}

package stu_zizhu1;

import java.awt.Button;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.DriverManager;

import java.sql.SQLException;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.PreparedStatement;

import com.mysql.jdbc.Statement;

public class Add1 extends JFrame{

//定义标签

JLabel jlid=new JLabel("ID:");

JLabel jlname=new JLabel("Name:");

JLabel jlage=new JLabel("Age:");

JLabel jlsex=new JLabel("Sex:");

JLabel jlscore=new JLabel("Score:");

JLabel jlbirthday=new JLabel("Birthday:");

//定义文本框

JTextField jfid=new JTextField("",20);

JTextField jfname=new JTextField("",20);

JTextField jfage=new JTextField("",20);

JTextField jfsex=new JTextField("",20);

JTextField jfscore=new JTextField("",20);

JTextField jfbirthday=new JTextField("",20);

//定义按钮(本人再次严重犯错JButton被我写成Button 真的是头疼)

JButton tianjia=new JButton("添加");

JButton chongzhi =new JButton("重置");

JButton fanhui=new JButton("返回");

public Add1() {

//定义面板

//jpid面板添加标签(jlid)&&文本框(jfid)

JPanel jpid=new JPanel();

jpid.add(jlid);

jpid.add(jfid);

JPanel jpname=new JPanel();

jpname.add(jlname);

jpname.add(jfname);

JPanel jpage=new JPanel();

jpage.add(jlage);

jpage.add(jfage);

JPanel jpsex=new JPanel();

jpsex.add(jlsex);

jpsex.add(jfsex);

JPanel jpscore=new JPanel();

jpscore.add(jlscore);

jpscore.add(jfscore);

JPanel jpbirthday=new JPanel();

jpbirthday.add(jlbirthday);

jpbirthday.add(jfbirthday);

JPanel jpbutton=new JPanel(new GridLayout(1,3));

jpbutton.add(tianjia);

jpbutton.add(chongzhi);

jpbutton.add(fanhui);

//按钮添加监听器

tianjia.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

Connection conn=null;

PreparedStatement prestat=null;

Statement stat =null;

String sql ="insert into student1(id,name,age,sex,score,birthday) "+"values(?,?,?,?,?,?)";//少加一个问好？

try{

Class.forName("Driver");

System.out.println("JBDC 加载成功!");

}catch(Exception a){

System.out.println("JBDC 狗带!");

a.printStackTrace();

}

try {

conn= (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/yonghu?useSSL=false","root","123456");

prestat=(PreparedStatement) conn.prepareStatement(sql);

prestat.setString(1,jfid.getText());

prestat.setString(2,jfname.getText());

prestat.setString(3,jfage.getText());

prestat.setString(4,jfsex.getText());

prestat.setString(5,jfscore.getText());

prestat.setString(6,jfbirthday.getText());

prestat.executeUpdate();

} catch (SQLException s) {

// TODO Auto-generated catch block

s.printStackTrace();

}finally {

try {

conn.close();

} catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

}

}

});

fanhui.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

Window1 window1=new Window1();

}

});

chongzhi.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

jfid.setText("");

jfname.setText("");

jfage.setText("");

jfsex.setText("");

jfscore.setText("");

jfbirthday.setText("");

}

});

this.setTitle("添加学生信息");

this.setLayout(new GridLayout(9,1));

this.add(jpid);

this.add(jpname);

this.add(jpage);

this.add(jpsex);

this.add(jpscore);

this.add(jpbirthday);

this.add(jpbutton);

this.setLocation(400,300);

this.setSize(350,300);

this.setVisible(true);

}

}

package stu_zizhu1;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.Statement;

public class Find1 extends JFrame{

JLabel jlid=new JLabel("ID:");

JTextField jtfid=new JTextField("",20);

JLabel jlname=new JLabel("Name:");

JLabel jlage=new JLabel("Age:");

JLabel jlsex=new JLabel("Sex:");

JLabel jlscore=new JLabel("Score:");

JLabel jlbirthday=new JLabel("Birthday:");

//JLabel jid=new JLabel();

JLabel jname=new JLabel();

JLabel jage=new JLabel();

JLabel jsex=new JLabel();

JLabel jscore=new JLabel();

JLabel jbirthday=new JLabel();

//此处按钮一定要设置成JButton

JButton query=new JButton("查询");

JButton ret=new JButton("返回");

//此处不可有void

public Find1() {

JPanel jpid=new JPanel();

jpid.add(jlid);

jpid.add(jtfid);

JPanel jpname=new JPanel();

jpname.add(jlname);

jpname.add(jname);

JPanel jpage=new JPanel();

jpage.add(jlage);

jpage.add(jage);

JPanel jpsex=new JPanel();

jpsex.add(jlsex);

jpsex.add(jsex);

JPanel jpscore=new JPanel();

jpscore.add(jlscore);

jpscore.add(jscore);

JPanel jpbirthday=new JPanel();

jpbirthday.add(jlbirthday);

jpbirthday.add(jbirthday);

JPanel button1=new JPanel(new GridLayout(1,1));

button1.add(query);

button1.add(ret);

query.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e1) {

Connection conn=null;

Statement state=null;

ResultSet res=null;

//此处犯错 忘记写id

String sql="select id,name,age,sex,score,birthday from student1;";

try {

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

} catch (ClassNotFoundException e) {

System.out.println("123");

e.printStackTrace();

}

try {

conn=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/yonghu?useSSL=false","root","123456");

state=(Statement) conn.createStatement();

res=state.executeQuery(sql);

while(res.next()) {

if(res.getString(1).equals(jtfid.getText())) {

jname.setText(res.getString(2));

jage.setText(res.getString(3));

jsex.setText(res.getString(4));

jscore.setText(res.getString(5));

jbirthday.setText(res.getString(6));

}

}

} catch (SQLException e) {

System.out.println("1234");

e.printStackTrace();

}finally {

try {

conn.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

});

ret.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

Window1 window1=new Window1();

}

});

this.setTitle("学生查询系统 ");

this.setLayout(new GridLayout(9,1));//9组建

this.add(jpid);

this.add(jpname);

this.add(jpage);

this.add(jpsex);

this.add(jpscore);

this.add(jpbirthday);

this.add(button1);

this.setSize(300, 400);

this.setLocation(300, 400);

this.setVisible(true);

}

}

package stu_zizhu1;

import java.awt.BorderLayout;

import java.awt.Color;

import java.awt.GridLayout;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Vector;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.JTextField;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.PreparedStatement;

public class Look1 extends JFrame{

Connection conn =null;

PreparedStatement pre=null;

ResultSet res=null;

JScrollPane jps=null;

Vector columnsname=null;

Vector rowData=null;

public Look1() {

JPanel jp1=new JPanel();

jp1.setBackground(Color.gray);

jp1.setSize(500, 500);

JLabel jb=new JLabel("欢迎使用学生管理系统");

jb.setBounds(0, 0, 50, 50);

jp1.add(jb);

JPanel jp=new JPanel();

//JLabel jb1=new JLabel("欢迎使用学生管理系统");

jp.setSize(400, 400);

jp.setBackground(Color.green);

//jp.add(jb1);

jp.add(jp1);

//定义列名

columnsname=new Vector();

columnsname.add("id");

columnsname.add("name");

columnsname.add("age");

columnsname.add("sex");

columnsname.add("score");

columnsname.add("birthday");

rowData =new Vector();

try {

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

conn=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/yonghu?useSSL=false","root","123456");

pre=(PreparedStatement) conn.prepareStatement("select *from student1");

res=pre.executeQuery();

while(res.next()) {

Vector hang =new Vector();

hang.add(res.getString(1));

hang.add(res.getString(2));

hang.add(res.getString(3));

hang.add(res.getString(4));

hang.add(res.getString(5));

hang.add(res.getString(6));

rowData.add(hang);

}

System.out.println("load ok!");

} catch (Exception e) {

System.out.println("go die");

e.printStackTrace();

}finally {

try {

res.close();

pre.close();

conn.close();

System.out.println("close ok");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

JTable jtable=new JTable(rowData,columnsname);

jps=new JScrollPane(jtable);

this.add(jps);

this.setTitle("学生浏览系统");

this.setLayout(new GridLayout(3,4));

this.add(jp);

this.setSize(400, 500);

this.setLocation(300,400);

this.setVisible(true);

this.setResizable(false);

}

}

package stu_zizhu1;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JTextField;

import com.mysql.jdbc.Connection;

import com.mysql.jdbc.PreparedStatement;

import com.mysql.jdbc.Statement;

import First.Window;

public class Modify1 extends JFrame{

//定义标签

JLabel jlid=new JLabel("ID:");

JLabel jlname=new JLabel("Name:");

JLabel jlage=new JLabel("Age:");

JLabel jlsex=new JLabel("Sex:");

JLabel jlscore=new JLabel("Score:");

JLabel jlbirthday=new JLabel("Birthday:");

//定义文本框

JTextField jfid=new JTextField("",20);

JTextField jfname=new JTextField("",20);

JTextField jfage=new JTextField("",20);

JTextField jfsex=new JTextField("",20);

JTextField jfscore=new JTextField("",20);

JTextField jfbirthday=new JTextField("",20);

//定义按钮(本人再次严重犯错JButton被我写成Button 真的是头疼)

JButton change=new JButton("修改");

JButton chongzhi =new JButton("重置");

JButton fanhui=new JButton("返回");

public Modify1() {

//定义面板

//jpid面板添加标签(jlid)&&文本框(jfid)

JPanel jpid=new JPanel();

jpid.add(jlid);

jpid.add(jfid);

JPanel jpname=new JPanel();

jpname.add(jlname);

jpname.add(jfname);

JPanel jpage=new JPanel();

jpage.add(jlage);

jpage.add(jfage);

JPanel jpsex=new JPanel();

jpsex.add(jlsex);

jpsex.add(jfsex);

JPanel jpscore=new JPanel();

jpscore.add(jlscore);

jpscore.add(jfscore);

JPanel jpbirthday=new JPanel();

jpbirthday.add(jlbirthday);

jpbirthday.add(jfbirthday);

JPanel jpbutton=new JPanel(new GridLayout(1,3));

jpbutton.add(change);

jpbutton.add(chongzhi);

jpbutton.add(fanhui);

change.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent arg0) {

//String id1=jfid.getText();

String name1=jfname.getText();//此处犯错

String age1=jfage.getText();

String sex1=jfsex.getText();

String score1=jfscore.getText();

String birthday1=jfbirthday.getText();

Connection conn=null;

Statement state=null;

//PreparedStatement prestate=null;

ResultSet res=null;

String sql="select id,name,age,sex,score,birthday from student1;";

try{

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

}catch(Exception d){

System.out.println("jdbc fall");

d.printStackTrace();

}

try{

conn=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/yonghu?useSSL=false","root","123456");

state=(Statement) conn.createStatement();

res=state.executeQuery(sql);

while (res.next())

{

//change

if (res.getString(1).equals(jfid.getText()))

{

try{

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

}catch(Exception d){

System.out.println("jdbc fall");

d.printStackTrace();

}

String sql1="update student1 set name='"+name1+"'where id='"+jfid.getText()+"'";

String sql2="update student1 set age='"+age1+"'where id='"+jfid.getText()+"'";

String sql3="update student1 set sex='"+sex1+"'where id='"+jfid.getText()+"'";

String sql4="update student1 set score='"+score1+"'where id='"+jfid.getText()+"'";

String sql5="update student1 set birthday='"+birthday1+"'where id='"+jfid.getText()+"'";

try {

conn=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/yonghu?useSSL=false","root","123456");

state=(Statement) conn.createStatement();

state.execute(sql1);

state.execute(sql2);

state.execute(sql3);

state.execute(sql4);

state.execute(sql5);

} catch (SQLException g) {

// TODO Auto-generated catch block

g.printStackTrace();

}try{

state.close();

conn.close();

}catch(SQLException ar){

ar.printStackTrace();

}

break;

}

//change end

}

}catch (SQLException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

finally{

try{

conn.close();

}catch(SQLException ar){

ar.printStackTrace();

}

}

}

});

fanhui.addActionListener(new ActionListener(){

public void actionPerformed(ActionEvent e){

Window window = new Window();

}

});

chongzhi.addActionListener(new ActionListener() {

@Override

public void actionPerformed(ActionEvent e) {

jfid.setText("");

jfname.setText("");

jfage.setText("");

jfsex.setText("");

jfscore.setText("");

jfbirthday.setText("");

}

});

this.setTitle("修改学生信息");

this.setLayout(new GridLayout(9,1));

this.add(jpid);

this.add(jpname);

this.add(jpage);

this.add(jpsex);

this.add(jpscore);

this.add(jpbirthday);

this.add(jpbutton);

this.setLocation(400,300);

this.setSize(350,300);

this.setVisible(true);

}

}