学生管理系统(图形界面)——Java

学生管理系统（图形界面）——Java 源代码：

package exp10;

import javax.swing.JFrame;

public class MainClass {

/**

* @param args

*/

public static void main(String[] args) {

// TODO Auto-generated method stub

JFrame myFrame=new JFrame("学生成绩管理系统");

myFrame.setLocation(300,100);

//

myFrame.setContentPane(new LoginPane(myFrame));

myFrame.pack();

myFrame.setVisible(true);

}

}

package exp10;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class DataBase {

Connection conn=null;

public Connection getConn(){

return this.conn;

}

public void setConn(Connection conn){ this.conn=conn;

}

public boolean getConnection(){

String

url="jdbc:mysql://localhost:3306/ScoreManagement?user=root&passwor d=123";

try{

Class.forName("org.gjt.mm.mysql.Driver");

conn=DriverManager.getConnection(url);

return true;

}catch(SQLException e){

System.out.println(e.getMessage());

return false;

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

return false;

}

}

public ResultSet executeQuery(String sql){

ResultSet rs=null;

Statement stmt=null;

if(conn==null){

this.getConnection();}

try{

stmt=conn.createStatement();

rs=stmt.executeQuery(sql);

return rs;

}catch(SQLException e){

return null;

}

}

public int executeUpdate(String sql){

Statement stmt=null;

int linecount=0;

if(conn==null){

this.getConnection();}

try{

stmt=conn.createStatement();

linecount=stmt.executeUpdate(sql);

}catch(SQLException e){}

return linecount;

}

}

package exp10;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.sql.ResultSet;

import java.sql.SQLException;

import javax.swing.Box;

import javax.swing.ButtonGroup;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JPasswordField;

import javax.swing.JRadioButton;

import javax.swing.JTextField;

public class LoginPane extends JPanel implements ActionListener{ /**

*

*/

private static final long serialVersionUID = 1L;

JFrame myFrame;

JLabel lab_username=new JLabel("用户名"); JTextField jt_username=new JTextField(20);

JLabel lab_password=new JLabel("密码"); JPasswordField jt_pwd=new JPasswordField(20); JRadioButton jrb_manager=new JRadioButton("管理员"); JRadioButton jrb_teacher=new JRadioButton("教师"); JRadioButton jrb_student=new JRadioButton("学生"); public LoginPane(JFrame myFrame){

this.myFrame=myFrame;

this.init();

}

public void init(){

Box box_user=Box.createHorizontalBox();

box_user.add(lab_username);

box_user.add(Box.createHorizontalStrut(20));

box_user.add(jt_username);

jt_pwd.setEchoChar('#');

Box box_pwd=Box.createHorizontalBox();