学生成绩管理系统java程序设计

学生成绩管理系统j a v a

程序设计

集团文件发布号：（9816-UATWW-MWUB-WUNN-INNUL-DQQTY-

系统登录模块设计

1）运行结果：

2）实验代码：

//登录界面

import

import

import java.sql.*;

import javax.swing.*;

public class Login extends JFrame implements ActionListener{ private static final long serialVersionUID = 1L;

JFrame mm=new JFrame("您好！请您先登录！");

JTextField t2=new JTextField(null,15);

JTextField t4=new JPasswordField(null,15);

public String zh=null;

JRadioButton b=new JRadioButton("教师");

JRadioButton b1=new JRadioButton("学生");

JRadioButton b2=new JRadioButton("管理员");

static Connection con;

static PreparedStatement sql;

static ResultSet res;

public void jiemian(){

mm.setSize(300,340);

mm.setVisible(true);

mm.setLocation(200,300);

JLabel t1=new JLabel("ID号:");

JLabel t3=new JLabel("密码:");

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

denglu2.setContentAreaFilled(false);

Container n=mm.getContentPane();

n.setLayout(null);

t1.setBounds(40,100,75,35);

t2.setBounds(80,100,150,35);

t3.setBounds(40,150,75,35);

t4.setBounds(80,150,150,35);

denglu2.setBounds(120,210,70,30);

n.add(t1);n.add(t2); n.add(t3); n.add(t4);

n.add(denglu2);

b.setBounds(120,50,60,30);

b1.setBounds(60,50,80,30);

b2.setBounds(180,50,80,30);

ButtonGroup rg=new ButtonGroup();

b.setSelected(false);

b1.setSelected(false);

b1.setSelected(false);

n.add(b);n.add(b1); n.add(b2);

rg.add(b); rg.add(b1);rg.add(b2);

b.setContentAreaFilled(false);

b1.setContentAreaFilled(false);

b2.setContentAreaFilled(false);

denglu2.addActionListener(this);

denglu2.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent arg0) {

JButton denglu2=(JButton)arg0.getSource();

boolean flag = true;

if(arg0.getSource()==denglu2)

{

if(b1.isSelected()) {

Login app=new Login();

app.Login();

con=app.getConnection();

try {

Class.forName(); String url = ; String user = "root"; String

passWord = "raoyang"; con =

DriverManager.getConnection(url, user, passWord); // 连接连接

} catch (Exception e) {

e.printStackTrace();

}

String id = t2.getText().toString();

String mm = t4.getText().toString();

try { Statement sql = con.createStatement();

ResultSet res = sql.executeQuery("select * from 学籍");

while(res.next())

{ if((res.getString("学号

").equals(id))&&(res.getString("登入密码").equals(mm)))

{ JOptionPane.showMessageDialog(null,"登陆成功");

flag = false;

new xscaozuo();

}}

if(flag)

{ JOptionPane.showMessageDialog(null,"登录失败");}

res.close();

}catch (SQLException e) {

e.printStackTrace();