Java学生课程设计源码.

package com.lb.view;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

public class Login extends JFrame {

private TextField f1;

private TextField f2;

private JButton b1;

private JButton b2;

private JButton b3;

//登陆界面

public Login(){

Container cp=getContentPane();//容器

cp.setBackground(Color.cyan);

cp.setLayout(new GridLayout(4,1));//四行一列布局

Panel p1=new Panel();

Panel p2=new Panel();

Panel p3=new Panel();

Panel p4=new Panel();

f1=new TextField(15);

f2=new TextField(15);

f2.setEchoChar('*');//回显字符为*

b1=new JButton("登录");

b2=new JButton("重置");

b3=new JButton("退出");

p1.add(new Label(" "));

p2.add(new Label("用户名"));

p2.add(f1);

p3.add(new Label("密码"));

p3.add(f2);

p4.add(b1);

p4.add(b2);

p4.add(b3);

cp.add(p1);

cp.add(p2);

cp.add(p3);

cp.add(p4);

b1.addActionListener(new Enter());

b2.addActionListener(new ReWrite());

b3.addActionListener(new Close());

}

class Enter implements ActionListener{

public void actionPerformed(ActionEvent e)

{

if((f1.getText()).equals("任艳云")&&(f2.getText()).equals("ren12"))

{

XueSheng frame1 = new XueSheng();

frame1.setBounds(200, 200, 400, 400);

frame1.setVisible(true);

}

else JOptionPane.showMessageDialog(null, "用户名或密码错误，请重新登录！");

}

}

class ReWrite implements ActionListener{

public void actionPerformed(ActionEvent e)

{

f1.setText("");

f2.setText("");

f1.requestFocus();

}

}

class Close implements ActionListener{

public void actionPerformed(ActionEvent e)

{

JButton bt=(JButton)e.getSource();

if(bt==b3){

System.exit(0);

}

}

}

//主函数程序开始

public static void main(String[] args) {

Login log=new Login();

log.setTitle("系统登录");

log.setBounds(200, 200, 300, 300);

log.setBackground(Color.red);

log.setVisible(true);

}

//信息管理界面内部类进行初始化和保存

class XueSheng extends JFrame implements ActionListener {

private JButton cx, zj, tc, sc,xg,tj;

public XueSheng()

{

Container c = this.getContentPane();

c.setLayout(new GridLayout(4, 1));

c.setBackground(Color.cyan);

c.setFont(new Font("true",Font.TRUETYPE_FONT,13));

JPanel panel1 = new JPanel();

panel1.setBackground(Color.cyan);

JLabel label1 = new JLabel("欢迎登入成绩管理主页",SwingConstants.CENTER);

label1.setFont(new Font("true",Font.TRUETYPE_FONT,15));

panel1.add(label1);

JPanel panel2 = new JPanel();

panel2.setBackground(Color.cyan);

JPanel panel3 = new JPanel();

panel3.setBackground(Color.cyan);

JPanel panel4 = new JPanel();

panel4.setBackground(Color.cyan);

//添加按钮

cx = new JButton("查询");

panel2.add(cx);

zj = new JButton("增加");

panel2.add(zj);

sc = new JButton("删除");

panel3.add(sc);

xg = new JButton("修改");

panel3.add(xg);

tc = new JButton("退出");

panel4.add(tc);

c.add(panel1);

c.add(panel2);

c.add(panel3);

c.add(panel4);

cx.addActionListener(this);

zj.addActionListener(this);

sc.addActionListener(this);

xg.addActionListener(this);

tc.addActionListener(this);

this.setVisible(true);

}

public void actionPerformed(ActionEvent e) {

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

Query f = new Query();

}

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

Inseter f = new Inseter();

}

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

Delete d = new Delete();

}

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

Update x=new Update();

}

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

shutDown();

}

}

private void shutDown()

{

JOptionPane.showMessageDialog(null, "信息已保存");

this.dispose();

}

} }

插入源码：

package com.lb.view;

import java.awt.Color;

import java.awt.Container;

import java.awt.FlowLayout;

import java.awt.Font;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.io.FileNotFoundException;

import java.io.IOException;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import com.lb.bean.Student;

import com.lb.dao.DaoImpl;

class Inseter extends JFrame implements ActionListener {

private JTextField STNOText, SNAMEText, MAText, CHIText, JAVAText;

private JButton b1, b2, b3;

private String STNO, SNAME,MAT, CHI, JAVA;

private Student a;

public Inseter() {

super("添加学生信息");

Container c2 = this.getContentPane();

c2.setLayout(new GridLayout(3, 1));

c2.setBackground(Color.cyan);

JPanel center = new JPanel();

center.setLayout(new GridLayout(5, 4));

center.setBackground(Color.cyan);

JPanel low = new JPanel(new FlowLayout());

low.setBackground(Color.cyan);

JLabel label1 = new JLabel("添加学生信息", SwingConstants.CENTER);

label1.setFont(new Font("TRUE", Font.TRUETYPE_FONT, 20));

c2.add(label1);

STNOText = new JTextField(20);//30列文本框

SNAMEText = new JTextField(20);

CHIText = new JTextField(20);

MAText = new JTextField(20);

JAVAText = new JTextField(20);

center.add(new JLabel(" "));

center.add(new JLabel("学号:", SwingConstants.CENTER));//添加标签学号写在标签中间center.add(STNOText);//添加文本框

center.add(new JLabel(" "));

center.add(new JLabel(" "));

center.add(new JLabel("姓名:", SwingConstants.CENTER));

center.add(SNAMEText);

center.add(new JLabel(" "));

center.add(new JLabel(" "));

center.add(new JLabel("语文:", SwingConstants.CENTER));

center.add(CHIText);

center.add(new JLabel(" "));

center.add(new JLabel(" "));

center.add(new JLabel("数学:", SwingConstants.CENTER));

center.add(MAText);

center.add(new JLabel(" "));

center.add(new JLabel(" "));

center.add(new JLabel("java:", SwingConstants.CENTER));

center.add(JAVAText);

center.add(new JLabel(" "));

c2.add(center);

b1 = new JButton("添加");

b2 = new JButton("清除");

b3 = new JButton("退出");

low.add(b1);

low.add(b2);

low.add(b3);

c2.add(low);

// 添加监听

b1.addActionListener(this);

b2.addActionListener(this);

b3.addActionListener(this);

this.setBounds(200, 200, 600, 400);

this.setVisible(true);

this.setTitle("添加学生信息");

}

public void actionPerformed(ActionEvent e) {

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

try {

inseter();

} catch (FileNotFoundException e1) {

e1.printStackTrace();

} catch (IOException e1) {

e1.printStackTrace();

}

}

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

clearForm();

}

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

this.dispose();

}

}

private void inseter() throws FileNotFoundException, IOException { STNO = STNOText.getText();

SNAME = SNAMEText.getText();

CHI = CHIText.getText();

MAT = MAText.getText();

JAVA = JAVAText.getText();

Student stu =new Student();

if (STNO.length() == 0 || SNAME.length() == 0 || MAT.length() == 0

|| JAVA.length() == 0 || CHI.length() == 0){

JOptionPane.showMessageDialog(this, "请添加完全信息");

}

else {

Student a=new Student(SNAME,STNO,

Integer.parseInt(CHI),Integer.parseInt(MAT),Integer.parseInt(JAVA));

DaoImpl di = new DaoImpl();

di.inseter(a);

JOptionPane.showMessageDialog(this, "添加成功！！");

}

}

private void clearForm() {

STNOText.setText("");

SNAMEText.setText("");

MAText.setText("");

CHIText.setText("");

JAVAText.setText("");

}

}

删除源码：

package com.lb.view;

import java.awt.Color;

import java.awt.Container;

import java.awt.Font;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTextArea;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import com.lb.dao.DaoImpl;

class Delete extends JFrame implements ActionListener{

private JButton yes;

private JButton cancle;

private JTextField text1;

private String STNO;

public Delete(){

Container c3 = this.getContentPane();

c3.setBackground(Color.pink);

c3.setLayout(new GridLayout(3, 1));

c3.setFont(new Font("true",Font.TRUETYPE_FONT,13));

JPanel p1 = new JPanel();

p1.setBackground(Color.pink);

JPanel p2 = new JPanel();

p2.setBackground(Color.pink);

JLabel label1 = new JLabel("删除学生信息",SwingConstants.CENTER);

label1.setFont(new Font("true",Font.TRUETYPE_FONT,13));

label1.setForeground(Color.blue);

c3.add(label1);

JLabel label2 = new JLabel("请输入学号");

text1 = new JTextField(10);

p1.add(label2);

p1.add(text1);

c3.add(p1);

yes = new JButton("确定");

cancle = new JButton("退出");

p2.add(yes);

p2.add(cancle);

c3.add(p2);

yes.addActionListener(this);

cancle.addActionListener(this);

this.setTitle("删除学生信息");

this.setBounds(200,200,400,300);

this.setVisible(true);

}

public void actionPerformed(ActionEvent e){

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

DaoImpl di =new DaoImpl();

STNO = text1.getText();

di.delete(STNO);

}

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

this.dispose();

}

JOptionPane.showMessageDialog(this, "删除成功！！！");

}

}

修改源码：

package com.lb.view;

import java.awt.Color;

import java.awt.Container;

import java.awt.Font;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import com.lb.bean.Student;

import com.lb.dao.DaoImpl;

class Update extends JFrame implements ActionListener{

private JTextField STNOText, SNAMEText, MAText, CHIText, JAVAText;

private JButton b1,b2,b3;

public Update(){

Container c4 = this.getContentPane();

c4.setLayout(new GridLayout(5, 1));

c4.setFont(new Font("true",Font.TRUETYPE_FONT,13)); JPanel up1 = new JPanel();

up1.setBackground(Color.pink);

JPanel up2 = new JPanel();

up2.setBackground(Color.pink);

JPanel center = new JPanel(new GridLayout(4,4)); center.setBackground(Color.pink);

JPanel low = new JPanel();

low.setBackground(Color.pink);

JPanel low1 = new JPanel();

low1.setBackground(Color.pink);

JLabel label11 = new JLabel("需要修改的学号:"); STNOText=new JTextField(15);

up2.add(label11);

up2.add(STNOText);

b1=new JButton("查找");

up2.add(b1);

c4.add(up1);

c4.add(up2);

c4.add(center);

SNAMEText=new JTextField(22);

MAText=new JTextField(22);

CHIText=new JTextField(22);

JAVAText=new JTextField(22);

center.add(new JLabel(" "));

center.add(new JLabel("姓名:", SwingConstants.CENTER)); center.add(SNAMEText);

center.add(new JLabel(" "));

center.add(new JLabel(" "));

center.add( new JLabel("数学:", SwingConstants.CENTER)); center.add(MAText);

center.add(new JLabel(" "));

center.add(new JLabel(" "));

center.add(new JLabel("语文:", SwingConstants.CENTER)); center.add(CHIText);

center.add(new JLabel(" "));

center.add(new JLabel(" "));

center.add(new JLabel("java:", SwingConstants.CENTER)); center.add(JAVAText);

center.add(new JLabel(" "));

c4.add(center);

b2=new JButton("修改");

b3=new JButton("退出");

low1.add(b2);

low1.add(b3);

c4.add(low);

c4.add(low1);

b1.addActionListener(this);

b2.addActionListener(this);

b3.addActionListener(this);

this.setTitle("修改信息");

this.setBounds(200, 200, 400, 400);

this.setVisible(true);

}

public void actionPerformed(ActionEvent e) {

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

DaoImpl di = new DaoImpl();

String num = STNOText.getText();

Student stu = di.findStudentByNum(num);

if(num.equals(stu.getNum())){

SNAMEText.setText(stu.getName());

MAText.setText(String.valueOf(stu.getShuxue()));

CHIText.setText(String.valueOf(stu.getYuwen()));

JAVAText.setText(String.valueOf(stu.getJava()));

}

}

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

if (SNAMEText.getColumns() == 0 || MAText.getColumns() == 0

|| JAVAText.getColumns() == 0 || CHIText.getColumns() == 0)

{

}

else {

Student a=new Student(SNAMEText.getText(),STNOText.getText(),

Integer.parseInt(CHIText.getText()),Integer.parseInt(MAText.getText()),

Integer.parseInt(JAVAText.getText()));

DaoImpl dl = new DaoImpl();

dl.update(a);

JOptionPane.showMessageDialog(this, "修改成功！！！");

}

}

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

this.dispose();

}

}

}

查询源码：

package com.lb.view;

import java.awt.Color;

import java.awt.Container;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

import com.lb.bean.Student;

import com.lb.dao.DaoImpl;

class Query extends JFrame implements ActionListener {

private JTextField STNOText, SNAMEText, MAText, CHIText, JAVAText;

private String STNO;

private JButton b1, b2;

public Query() {

Container c1 = this.getContentPane();

c1.setLayout(new GridLayout(4, 1));

JLabel label1 = new JLabel("查询学生信息", SwingConstants.CENTER);

JLabel label0 = new JLabel("请输入你的学号",SwingConstants.CENTER);

JPanel pp = new JPanel(new GridLayout(2, 1));

pp.setBackground(Color.pink);

pp.add(label1);

pp.add(label0);

c1.add(pp);

JPanel p1 = new JPanel();

p1.setBackground(Color.pink);

STNOText = new JTextField(10);

p1.add(STNOText);

c1.add(p1);

JPanel p2 = new JPanel();

p2.setBackground(Color.pink);

b1 = new JButton("查询");

b2 = new JButton("退出");

b1.addActionListener(this);

b2.addActionListener(this);

p2.add(b1);

p2.add(b2);

c1.add(p2);

JPanel center = new JPanel(new GridLayout(4, 4));

center.setBackground(Color.pink);

SNAMEText = new JTextField(30);

CHIText = new JTextField(30);

MAText = new JTextField(30);

JAVAText = new JTextField(30);

center.add(new JLabel(" "));

center.add(new JLabel("姓名", SwingConstants.CENTER));

center.add(SNAMEText);

center.add(new JLabel(" "));

center.add(new JLabel(" "));

center.add(new JLabel("语文", SwingConstants.CENTER));

center.add(CHIText);

center.add(new JLabel(" "));

center.add(new JLabel(" "));

center.add(new JLabel("数学", SwingConstants.CENTER));

center.add(MAText);

center.add(new JLabel(" "));

center.add(new JLabel(" "));

center.add(new JLabel("java", SwingConstants.CENTER));

center.add(JAVAText);

center.add(new JLabel(" "));

c1.add(center);

this.setVisible(true);

this.setBounds(200, 200, 400, 300);

}

public void actionPerformed(ActionEvent e){

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

STNO = STNOText.getText();

DaoImpl dl = new DaoImpl();

Student stu = dl.findStudentByNum(STNO);

if((STNO).equals(stu.getNum()))

{

SNAMEText.setText(stu.getName());

MAText.setText(String.valueOf(stu.getShuxue()));

CHIText.setText(String.valueOf(stu.getYuwen()));

JAVAText.setText(String.valueOf(stu.getJava()));

}

}

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

this.dispose();

}

}

}

连库源码：

package com.lb.dao;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.List;

import com.lb.bean.Student;

public class DaoImpl {

public Student login(String num,String pass){

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

Student stu = new Student();

int sid = 0;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/java","root","root");

String sql = "select * from user where num = ? and pass = ?";

ps = conn.prepareStatement(sql);

ps.setString(1, num);

ps.setString(2, pass);

rs = ps.executeQuery();

while(rs.next()){

sid = rs.getInt("sid");

}

String sql2 = "select * from student where id = "+sid;

ps = conn.prepareStatement(sql);

rs = ps.executeQuery();

while(rs.next()){

stu.setId(rs.getInt("id"));

stu.setJava(rs.getInt("java"));

stu.setName(rs.getString("name"));

stu.setNum(rs.getString("num"));

stu.setShuxue(rs.getInt("shuxue"));

stu.setYuwen(rs.getInt("yuwen"));

}

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

if(ps != null){

ps.close();

}

if(conn != null){

conn.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

return stu;

}

public void inseter(Student stu){

Connection conn = null;

PreparedStatement ps = null;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/java","root","root");

String sql ="insert into student values(null,?,?,?,?,?)";

ps = conn.prepareStatement(sql);

ps.setString(1, stu.getName());

ps.setString(2,stu.getNum() );

ps.setInt(3, stu.getYuwen());

ps.setInt(4, stu.getShuxue());

ps.setInt(5, stu.getJava());

ps.executeUpdate();

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

if(ps != null){

ps.close();

}

if(conn != null){

conn.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

public void delete(String num){

Connection conn = null;

PreparedStatement ps = null;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/java","root","root");

String sql = "delete from student where num = ?";

ps = conn.prepareStatement(sql);

ps.setString(1, num);

ps.executeUpdate();

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

if(ps != null){

ps.close();

}

if(conn != null){

conn.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

public void update(Student stu){

Connection conn = null;

PreparedStatement ps = null;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/java","root","root");

String sql = "update student set name = ?,yuwen = ?,shuxue = ?,java = ? where num = ?";

ps = conn.prepareStatement(sql);

ps.setString(1, stu.getName());

ps.setInt(2, stu.getYuwen());

ps.setInt(3, stu.getShuxue());

ps.setInt(4, stu.getJava());

ps.setString(5, stu.getNum());

ps.executeUpdate();

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

if(ps != null){

ps.close();

}

if(conn != null){

conn.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

public List query(){

List li = new ArrayList();

Connection conn = null;

PreparedStatement ps = null;

ResultSet rs = null;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/java","root","root");

String sql = "select * from student";

ps = conn.prepareStatement(sql);

rs = ps.executeQuery();

while(rs.next()){

Student stu = new Student();

stu.setId(rs.getInt("id"));

stu.setName(rs.getString("name"));

stu.setNum(rs.getString("num"));

stu.setYuwen(rs.getInt("yuwen"));

stu.setShuxue(rs.getInt("shuxue"));

stu.setJava(rs.getInt("java"));

li.add(stu);

}

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

if(rs != null){

rs.close();

}

if(ps != null){

ps.close();

}

if(conn != null){

conn.close();

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

return li;

}