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);
}
}