java 学生成绩管理系统

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

package stu;

import java.awt.*;

import javax.swing.*;

public class background extends JPanel{

Image im;

public background(Image im)

{

   this.im=im;

   this.setOpaque(true);

}

//Draw the back ground.

public void paintComponent(Graphics g)

{

   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("<