java 学生成绩管理系统

background.java 登录页面的背景面板

package stu;

import java.awt.*;

import javax.swing.*;

public class background extends JPanel{

Image im;

public background(Imageim)

{

   this.im=im;

   this.setOpaque(true);

}

//Draw the back ground.

public void paintComponent(Graphicsg)

{

   super.paintComponents(g);

   g.drawImage(im,0,0,this.getWidth(),this.getHeight(),this);

    

}

}

home.java登录页面

package stu;

//package stu;//登录页面

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

public class home extends JFrame implements ActionListener{

Container ct=this.getContentPane();

    JTextField f1=new JTextField(10);

JPasswordField f2=new JPasswordField(10);

JButton button1=new JButton("登录");

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

background bgp=new background((new ImageIcon("picture.png")).getImage());//创建背景面板。

JPanel p=new JPanel();

JPanel p1=new JPanel();

JPanel p2=new JPanel();

JPanel p3=new JPanel();

JPanel p4=new JPanel();

JLabel label=new JLabel("用户名或密码错误！");

home(){

init();

setVisible(true);

setBounds(300,200,550,430);

setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

}

void init(){

setTitle("学生成绩管理系统");

        p.setLayout(new BorderLayout());

        p.setBounds(100,100,100,100);

p1.setLayout(new GridLayout(2,1));

p.setOpaque(false);

        bgp.setBounds(0,0,550,430);

        p3.add(new JLabel("用户名:"));

p3.add(f1);

p4.add(new JLabel("    密码:"));

p4.add(f2);

p1.add(p3);

p1.add(p4);

p2.add(button1);

p2.add(button2);

p.add(p1,BorderLayout.CENTER);

p.add(p2, BorderLayout.SOUTH);

bgp.add(p);

bgp.add(label);

label.setVisible(false);

ct.add(bgp);

button1.addActionListener(this);

button2.addActionListener(this);

}

public void actionPerformed(ActionEvent e){

if(e.getSource()==button1){

if(f1.getText().equals(f2.getText())){

this.setVisible(false);

new index();

 

}

else{

    label.setVisible(true);

}

}

if(e.getSource()==button2){

f1.setText(null);

f2.setText(null);

}

}

}

 

connect.java   java连接数据库

package stu;

//package stu;

import java.sql.*;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

public class connect {

static String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";   

  static String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=javastu";   

  static String userName = "sa";  //默认用户名

  static String userPwd = "123456";  //密码

  static Connection dbConn;

  public void setcon(Connection con2){

  dbConn=con2;

  }

  public static Connection connection() {

try {

   Class.forName(driverName);

   dbConn = DriverManager.getConnection(dbURL, userName, userPwd);

   System.out.println("Connection Successful!");

  } catch (Exception e) {

   e.printStackTrace();

  }

 

return  dbConn;

}

}

 

 

 

index.java    学生管理系统首页

package stu;

//package stu;

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class xingming extends JPanel implements ActionListener{

JLabel xmlabel1=new JLabel("请输入要查询学生的姓名：");

JTextField xmf1=new JTextField(10);

JButton xmbutton1=new JButton("确定");

JLabel xmlabel2=new JLabel("学号:");

JTextField xmf2=new JTextField(10);

JLabel xmlabel3=new JLabel("姓名:");

JTextField xmf3=new JTextField(10);

JLabel xmlabel4=new JLabel("性别:");

JTextField xmf4=new JTextField(10);

JLabel xmlabel5=new JLabel("jsp分数:");

JTextField xmf5=new JTextField(10);

JLabel xmlabel6=new JLabel("java分数:");

JTextField xmf6=new JTextField(10);

JLabel xmlabel7=new JLabel("c分数:");

JTextField xmf7=new JTextField(10);

JLabel xmlabel8=new JLabel("平均分:");

JTextField xmf8=new JTextField(10);

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

JLabel xmlabel10=new JLabel("若要修改该学生信息，请将修改后的信息填入文本框！");

JButton xmbutton3=new JButton("确认修改");

JPanel xingming=new JPanel();

xingming(){

init();

setBounds(100,100,600,650);

setVisible(true);

}

void init(){

setLayout(null);

    xmlabel1.setBounds(50,10,180,20);

    xmf1.setBounds(230,10,150,20);

    xmbutton1.setBounds(500,10,60,30);

    xmlabel2.setBounds(50,60,50,20);

    xmf2.setBounds(120,60,120,20);

    xmlabel3.setBounds(50,90,50,20);

    xmf3.setBounds(120,90,120,20);

    xmlabel4.setBounds(50,120,50,20);

    xmf4.setBounds(120,120,120,20);

    xmlabel5.setBounds(50,150,80,20);

    xmf5.setBounds(120,150,120,20);

    xmlabel6.setBounds(300,60,80,20);

    xmf6.setBounds(400,60,120,20);

    xmlabel7.setBounds(300,90,80,20);

    xmf7.setBounds(400,90,120,20);

    xmlabel8.setBounds(300,120,50,20);

    xmf8.setBounds(400,120,120,20);

    xmbutton2.setBounds(500,150,60,30);

    xmlabel10.setBounds(120,250,320,30);

    xmbutton3.setBounds(480,250,90,30);

    add(xmlabel1);

    add(xmf1);

    add(xmbutton1);

    add(xmlabel2);

    add(xmf2);

    add(xmlabel3);

    add(xmf3);

    add(xmlabel4);

    add(xmf4);

    add(xmlabel5);

    add(xmf5);

    add(xmlabel6);

    add(xmf6);

    add(xmlabel7);

    add(xmf7);

    add(xmlabel8);

    add(xmf8);

    add(xmbutton2);

    add(xmlabel10);

    add(xmbutton3);

    xmbutton1.addActionListener(this);

    xmbutton2.addActionListener(this);

    xmbutton3.addActionListener(this);

 

}

public void actionPerformed(ActionEvent e){

//根据姓名查询某一学生信息ok

if(e.getSource()==xmbutton1){//查询

try {

Connection con = connect.connection();

String name = xmf1.getText();

String sql = "select * from student where name='"+name+"'";

Statement s = con.createStatement();

ResultSet rs = s.executeQuery(sql);

if(rs.next()){

xmf2.setText(rs.getString(1));

xmf3.setText(name);

xmf4.setText(rs.getString(3));

xmf5.setText(rs.getString(4));

xmf6.setText(rs.getString(5));

xmf7.setText(rs.getString(6));

xmf8.setText(rs.getString(7));

}

} catch (SQLException e1) {

 

e1.printStackTrace();

}

 

}

if(e.getSource()==xmbutton2){//删除数据库中该姓名对应的行

try {

Connection con = connect.connection();

String name = xmf1.getText();

PreparedStatement ps = con.prepareStatement("delete from student where name='"+ name+"'");

ps.executeUpdate();

} catch (SQLException e1) {

 

e1.printStackTrace();

}

xmf1.setText("");

xmf2.setText("");

xmf3.setText("");

xmf4.setText("");

xmf5.setText("");

xmf6.setText("");

xmf7.setText("");

xmf8.setText("");

}

if(e.getSource()==xmbutton3){//修改

String name = xmf1.getText();

try {

Connection con = connect.connection();

PreparedStatement ps = con.prepareStatement("update student set no=?,name=?,sex=?,jsp=?,java=?,c=?,ave=? where name='"+ name+"'");

    ps.setString(1,xmf2.getText());

ps.setString(2,xmf3.getText());

ps.setString(3,xmf4.getText());

ps.setString(4,xmf5.getText());

ps.setString(5,xmf6.getText());

ps.setString(6,xmf7.getText());

ps.setString(7,xmf8.getText());

ps.executeUpdate();

} catch (NumberFormatException e1) {

e1.printStackTrace();

} catch (SQLException e1) {

            e1.printStackTrace();

}

}

}

}

 

 

 luru.java    录入页面

package stu;

//package stu;

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class luru extends JPanel implements ActionListener,MouseListener,MouseMotionListener{

int rows=50;

Object [][]a0=new Object[rows][7];

Object []name={ "学号","姓名","性别","jsp","java","c","平均成绩"};

JTable table1=new JTable(a0,name);

JButton lurubutton1=new JButton("计算");

JButton lurubutton2=new JButton("保存");

JLabel lulabe1=new JLabel();

JLabel lulabe2=new JLabel();

    JPanel lurup1=new JPanel();

    int flag=0;

    double a[]=new double[50] ;

    double b[]=new double[50] ;

luru(){

init();

setBounds(100,100,600,650);

setVisible(true);

}

void init(){

setLayout(new BorderLayout());

lurup1.setLayout(new FlowLayout());

lurubutton1.addActionListener(this);

lurubutton2.addActionListener(this);

add(new JScrollPane(table1),BorderLayout.CENTER);

lurup1.add(lulabe1);

lurup1.add(lulabe2);

      lurup1.add(lurubutton1);

      lurup1.add(lurubutton2);

        add(lurup1,BorderLayout.SOUTH);

        table1.addMouseListener(this);

        table1.addMouseMotionListener(this);

}

 int add(JTable table){//确定table中编辑的行数

 int num=0;

 for(int i=0;i<50;i++){

 String m=(String)table.getValueAt(i, 0);

 if(m!=null){

 num++;

 }

 }

 return num;

 }

 

public void actionPerformed(ActionEvent e){

//计算

if(e.getSource()==lurubutton1){

for(int i3=0;i3<add(table1);i3++){

String a1=(String)table1.getValueAt(i3,3);

System.out.println(a1);

int m1=Integer.parseInt(a1);

String a2=(String)table1.getValueAt(i3,4);

int m2=Integer.parseInt(a2);

String a3=(String)table1.getValueAt(i3,5);

int m3=Integer.parseInt(a3);

String aValue=""+((m1+m2+m3)*1.0/3);

table1.setValueAt(aValue,i3,6);

    }

}

//录入

if(e.getSource()==lurubutton2){//向数据库中录入学生信息

flag++;

if((flag-1)==0){

try {

Connection con = connect.connection();

PreparedStatement ps = con.prepareStatement("insert into student values(?,?,?,?,?,?,?)");

for(int i=0;i<add(table1);i++){

ps.setString(1, (String)table1.getValueAt(i, 0));

ps.setString(2, (String)table1.getValueAt(i, 1));

ps.setString(3, (String)table1.getValueAt(i, 2));

ps.setString(4, (String)table1.getValueAt(i, 3));

ps.setString(5, (String)table1.getValueAt(i, 4));

ps.setString(6, (String)table1.getValueAt(i, 5));

ps.setString(7, (String)table1.getValueAt(i, 6));

ps.executeUpdate();

}

} catch (NumberFormatException e1) {

e1.printStackTrace();

} catch (SQLException e1) {

e1.printStackTrace();

}

}

else{

try {

Connection con = connect.connection();

String sql = "select no from student ";

Statement s = con.createStatement();

ResultSet rs = s.executeQuery(sql);

    while(rs.next()){

     PreparedStatement ps = con.prepareStatement("delete from student where no='"+ rs.getString(1)+"'");//删除数据库中该学号对应的行

ps.executeUpdate();

}

} catch (SQLException e1) {

   e1.printStackTrace();

 }

try {

Connection con = connect.connection();

PreparedStatement ps = con.prepareStatement("insert into student values(?,?,?,?,?,?,?,?)");

for(int i=0;i<add(table1);i++){

ps.setString(1, (String)table1.getValueAt(i, 0));

ps.setString(2, (String)table1.getValueAt(i, 1));

ps.setString(3, (String)table1.getValueAt(i, 2));

ps.setString(4, (String)table1.getValueAt(i, 3));

ps.setString(5, (String)table1.getValueAt(i, 4));

ps.setString(6, (String)table1.getValueAt(i, 5));

ps.setString(7, (String)table1.getValueAt(i, 6));

ps.executeUpdate();

}

} catch (NumberFormatException e1) {

e1.printStackTrace();

} catch (SQLException e1) {

e1.printStackTrace();

}

}

     

}

}

public void mousePressed(MouseEvent e){//对学号和年龄进行处理

for(int j=0;j<add(table1);j++){

String fcf=(String)table1.getValueAt(j,0);

if(fcf==null){}

else{

if(fcf.length()!=11)

lulabe1.setText("学号格式输入有误,请输入的学号格式为11位！");

else lulabe1.setText("");

}

}

 

for(int j=1;j<=add(table1);j++){

String fcf=(String)table1.getValueAt(j-1,3);

if(fcf==null){}

else{

int m=Integer.parseInt(fcf);

if(m<0||m>100)

lulabe2.setText("成绩输入有误,请输入0~100之间的成绩！");

else lulabe2.setText("");

}

}

for(int j=1;j<=add(table1);j++){

String fcf=(String)table1.getValueAt(j-1,4);

if(fcf==null){}

else{

int m=Integer.parseInt(fcf);

if(m<0||m>100)

lulabe2.setText("成绩输入有误,请输入0~100之间的成绩！");

else lulabe2.setText("");

}

}

for(int j=1;j<=add(table1);j++){

String fcf=(String)table1.getValueAt(j-1,5);

if(fcf==null){}

else{

int m=Integer.parseInt(fcf);

if(m<0||m>100)

lulabe2.setText("成绩输入有误,请输入0~100之间的成绩！");

else lulabe2.setText("");

}

}

   }

public void mouseReleased(MouseEvent e) {}

public void mouseEntered(MouseEvent e){}

public void mouseExited(MouseEvent e) {}

public void mouseClicked(MouseEvent e) {}

public void mouseDragged(MouseEvent e){}

public void mouseMoved(MouseEvent e)  {}

 

}

 

chakan.java   查看全部信息页面

package stu;

//package stu;

 

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class chakan extends JPanel implements ActionListener{

int row=50;

Object [][]a1=new Object[row][7];

Object []name1={ "学号","姓名","性别","jsp","java","c","平均成绩"};

JPanel chakan1=new JPanel();

JTable table2=new JTable(a1,name1);

JButton ckbutton=new JButton("查看全部信息");

chakan(){

init();

setBounds(100,100,600,650);

setVisible(true);

}

void init(){

//查看全部信息

    setLayout(new BorderLayout());

chakan1.setLayout(new FlowLayout());

    add(new JScrollPane(table2),BorderLayout.CENTER);

        chakan1.add(ckbutton);

        add(chakan1,BorderLayout.NORTH);

        ckbutton.addActionListener(this);

 

}

 int add(JTable table){//确定table1中编辑的行数

 int num=0;

 for(int i=0;i<50;i++){

 String m=(String)table.getValueAt(i, 0);

 if(m!=null){

 num++;

 }

 }

 return num;

 }

public void actionPerformed(ActionEvent e){

if(e.getSource()==ckbutton){

try {

Connection con = connect.connection();

String sql = "select * from student ";//获取数据库中所有学号

Statement s = con.createStatement();

ResultSet rs = s.executeQuery(sql);

    for(int i=0;rs.next();i++){

table2.setValueAt(rs.getString(1),i,0);

table2.setValueAt(rs.getString(2),i,1);

table2.setValueAt(rs.getString(3),i,2);

table2.setValueAt(rs.getString(4),i,3);

table2.setValueAt(rs.getString(5),i,4);

table2.setValueAt(rs.getString(6),i,5);

table2.setValueAt(rs.getString(7),i,6);

}

} catch (SQLException e1) {

 

e1.printStackTrace();

}

try{

Connection con = connect.connection();

String sql = "select no from student";//删除table2中重复行

Statement s = con.createStatement();

ResultSet rs = s.executeQuery(sql);

int count=0;

while(rs.next()){

count++;

}

for(int m=count;m<add(table2);m++){

   for(int n=0;n<7;n++){

     table2.setValueAt("",m,n);

   }

 }

}

catch (SQLException e1) {

 

e1.printStackTrace();}

    }

 

}

}

 

 

 

xingming.java   按姓名查询页面

package stu;

//package stu;

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class xingming extends JPanel implements ActionListener{

JLabel xmlabel1=new JLabel("请输入要查询学生的姓名：");

JTextField xmf1=new JTextField(10);

JButton xmbutton1=new JButton("确定");

JLabel xmlabel2=new JLabel("学号:");

JTextField xmf2=new JTextField(10);

JLabel xmlabel3=new JLabel("姓名:");

JTextField xmf3=new JTextField(10);

JLabel xmlabel4=new JLabel("性别:");

JTextField xmf4=new JTextField(10);

JLabel xmlabel5=new JLabel("jsp分数:");

JTextField xmf5=new JTextField(10);

JLabel xmlabel6=new JLabel("java分数:");

JTextField xmf6=new JTextField(10);

JLabel xmlabel7=new JLabel("c分数:");

JTextField xmf7=new JTextField(10);

JLabel xmlabel8=new JLabel("平均分:");

JTextField xmf8=new JTextField(10);

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

JLabel xmlabel10=new JLabel("若要修改该学生信息，请将修改后的信息填入文本框！");

JButton xmbutton3=new JButton("确认修改");

JPanel xingming=new JPanel();

xingming(){

init();

setBounds(100,100,600,650);

setVisible(true);

}

void init(){

setLayout(null);

    xmlabel1.setBounds(50,10,180,20);

    xmf1.setBounds(230,10,150,20);

    xmbutton1.setBounds(500,10,60,30);

    xmlabel2.setBounds(50,60,50,20);

    xmf2.setBounds(120,60,120,20);

    xmlabel3.setBounds(50,90,50,20);

    xmf3.setBounds(120,90,120,20);

    xmlabel4.setBounds(50,120,50,20);

    xmf4.setBounds(120,120,120,20);

    xmlabel5.setBounds(50,150,80,20);

    xmf5.setBounds(120,150,120,20);

    xmlabel6.setBounds(300,60,80,20);

    xmf6.setBounds(400,60,120,20);

    xmlabel7.setBounds(300,90,80,20);

    xmf7.setBounds(400,90,120,20);

    xmlabel8.setBounds(300,120,50,20);

    xmf8.setBounds(400,120,120,20);

    xmbutton2.setBounds(500,150,60,30);

    xmlabel10.setBounds(120,250,320,30);

    xmbutton3.setBounds(480,250,90,30);

    add(xmlabel1);

    add(xmf1);

    add(xmbutton1);

    add(xmlabel2);

    add(xmf2);

    add(xmlabel3);

    add(xmf3);

    add(xmlabel4);

    add(xmf4);

    add(xmlabel5);

    add(xmf5);

    add(xmlabel6);

    add(xmf6);

    add(xmlabel7);

    add(xmf7);

    add(xmlabel8);

    add(xmf8);

    add(xmbutton2);

    add(xmlabel10);

    add(xmbutton3);

    xmbutton1.addActionListener(this);

    xmbutton2.addActionListener(this);

    xmbutton3.addActionListener(this);

 

}

public void actionPerformed(ActionEvent e){

//根据姓名查询某一学生信息ok

if(e.getSource()==xmbutton1){//查询

try {

Connection con = connect.connection();

String name = xmf1.getText();

String sql = "select * from student where name='"+name+"'";

Statement s = con.createStatement();

ResultSet rs = s.executeQuery(sql);

if(rs.next()){

xmf2.setText(rs.getString(1));

xmf3.setText(name);

xmf4.setText(rs.getString(3));

xmf5.setText(rs.getString(4));

xmf6.setText(rs.getString(5));

xmf7.setText(rs.getString(6));

xmf8.setText(rs.getString(7));

}

} catch (SQLException e1) {

 

e1.printStackTrace();

}

 

}

if(e.getSource()==xmbutton2){//删除数据库中该姓名对应的行

try {

Connection con = connect.connection();

String name = xmf1.getText();

PreparedStatement ps = con.prepareStatement("delete from student where name='"+ name+"'");

ps.executeUpdate();

} catch (SQLException e1) {

 

e1.printStackTrace();

}

xmf1.setText("");

xmf2.setText("");

xmf3.setText("");

xmf4.setText("");

xmf5.setText("");

xmf6.setText("");

xmf7.setText("");

xmf8.setText("");

}

if(e.getSource()==xmbutton3){//修改

String name = xmf1.getText();

try {

Connection con = connect.connection();

PreparedStatement ps = con.prepareStatement("update student set no=?,name=?,sex=?,jsp=?,java=?,c=?,ave=? where name='"+ name+"'");

    ps.setString(1,xmf2.getText());

ps.setString(2,xmf3.getText());

ps.setString(3,xmf4.getText());

ps.setString(4,xmf5.getText());

ps.setString(5,xmf6.getText());

ps.setString(6,xmf7.getText());

ps.setString(7,xmf8.getText());

ps.executeUpdate();

} catch (NumberFormatException e1) {

e1.printStackTrace();

} catch (SQLException e1) {

            e1.printStackTrace();

}

}

}

}

 

 

 

xuehao.java     按学号查询页面

package stu;

//package stu;

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class xuehao extends JPanel implements ActionListener{

//学号

JLabel xhlabel1=new JLabel("请输入要查询学生的学号：");

JTextField xhf1=new JTextField(10);

JButton xhbutton1=new JButton("确定");

JLabel xhlabel2=new JLabel("学号:");

JTextField xhf2=new JTextField(10);

JLabel xhlabel3=new JLabel("姓名:");

JTextField xhf3=new JTextField(10);

JLabel xhlabel4=new JLabel("性别:");

JTextField xhf4=new JTextField(10);

JLabel xhlabel5=new JLabel("jsp分数:");

JTextField xhf5=new JTextField(10);

JLabel xhlabel6=new JLabel("java分数:");

JTextField xhf6=new JTextField(10);

JLabel xhlabel7=new JLabel("c分数:");

JTextField xhf7=new JTextField(10);

JLabel xhlabel8=new JLabel("平均分:");

JTextField xhf8=new JTextField(10);

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

JLabel xhlabel9=new JLabel("");

JLabel xhlabel10=new JLabel("若要修改该学生信息，请将修改后的信息填入文本框！");

JButton xhbutton3=new JButton("确认修改");

JPanel xuehao=new JPanel();

xuehao(){

init();

setBounds(100,100,600,650);

setVisible(true);

}

void init(){

 //学号

    setLayout(null);

    xhlabel1.setBounds(50,10,180,20);

    xhf1.setBounds(230,10,150,20);

    xhbutton1.setBounds(500,10,60,30);

    xhlabel2.setBounds(50,60,50,20);

    xhf2.setBounds(120,60,120,20);

    xhlabel3.setBounds(50,90,50,20);

    xhf3.setBounds(120,90,120,20);

    xhlabel4.setBounds(50,120,50,20);

    xhf4.setBounds(120,120,120,20);

    xhlabel5.setBounds(50,150,80,20);

    xhf5.setBounds(120,150,120,20);

    xhlabel6.setBounds(300,60,80,20);

    xhf6.setBounds(400,60,120,20);

    xhlabel7.setBounds(300,90,80,20);

    xhf7.setBounds(400,90,120,20);

    xhlabel8.setBounds(300,120,50,20);

    xhf8.setBounds(400,120,120,20);

    xhbutton2.setBounds(500,150,60,30);

    xhlabel9.setBounds(120,200,300,30);

    xhlabel10.setBounds(120,250,320,30);

    xhbutton3.setBounds(480,250,90,30);

    add(xhlabel1);

    add(xhf1);

    add(xhbutton1);

    add(xhlabel2);

    add(xhf2);

    add(xhlabel3);

    add(xhf3);

    add(xhlabel4);

    add(xhf4);

    add(xhlabel5);

    add(xhf5);

    add(xhlabel6);

    add(xhf6);

    add(xhlabel7);

    add(xhf7);

    add(xhlabel8);

    add(xhf8);

    add(xhbutton2);

    add(xhlabel9);

    add(xhlabel10);

    add(xhbutton3);

        xhbutton1.addActionListener(this);

    xhbutton2.addActionListener(this);

    xhbutton3.addActionListener(this);

}

public void actionPerformed(ActionEvent e){

 //根据学号查询某个学生信息ok

if(e.getSource()==xhbutton1){//查询

String no = xhf1.getText();

if(no.length()!=11){

xhlabel9.setText("学号格式输入错误，请输入的学号为11位！");

}

else{

xhlabel9.setText("");

try {

Connection con = connect.connection();

String sql = "select * from student where no='"+no+"'";

Statement s = con.createStatement();

ResultSet rs = s.executeQuery(sql);

if(rs.next()){

xhf2.setText(no);

xhf3.setText(rs.getString(2));

xhf4.setText(rs.getString(3));

xhf5.setText(rs.getString(4));

xhf6.setText(rs.getString(5));

xhf7.setText(rs.getString(6));

xhf8.setText(rs.getString(7));

}

} catch (SQLException e1) {

 

e1.printStackTrace();

}

}

}

if(e.getSource()==xhbutton2){//删除

try {

Connection con = connect.connection();

String no1 = xhf1.getText();

PreparedStatement ps = con.prepareStatement("delete from student where no='"+ no1+"'");//删除数据库中该学号对应的行

ps.executeUpdate();

} catch (SQLException e1) {

 

e1.printStackTrace();

}

xhf1.setText("");

xhf2.setText("");

xhf3.setText("");

xhf4.setText("");

xhf5.setText("");

xhf6.setText("");

xhf7.setText("");

xhf8.setText("");

}

if(e.getSource()==xhbutton3){//修改

String no1 = xhf1.getText();

try {

Connection con = connect.connection();

PreparedStatement ps = con.prepareStatement("update student set no=?,name=?,sex=?,jsp=?,java=?,c=?,ave=? where no='"+ no1+"'");

    ps.setString(1,xhf2.getText());

ps.setString(2,xhf3.getText());

ps.setString(3,xhf4.getText());

ps.setString(4,xhf5.getText());

ps.setString(5,xhf6.getText());

ps.setString(6,xhf7.getText());

ps.setString(7,xhf8.getText());

ps.executeUpdate();

} catch (NumberFormatException e1) {

e1.printStackTrace();

} catch (SQLException e1) {

            e1.printStackTrace();

}

}

}

 

}

 

test5.java    主函数

package stu;

 

public class test5 {

public static void main(Stringargs[]){

new home();

}

 

}