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