学生信息管理系统java源代码 学生管理系统代码

大家好，如果您还对学生信息管理系统java源代码不太了解，没有关系，今天就由本站为大家分享学生信息管理系统java源代码的知识，包括学生管理系统代码的问题都会给大家分析到，还望可以解决大家的问题，下面我们就开始吧！

学生考试管理系统,JAva源代码

//主类EnglishTest——

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

public class EnglishTest extends JFrame

{

TestArea testPanel=null;

Container con=null;

public EnglishTest()

{

super("模拟考试");

testPanel=new TestArea();

con=getContentPane();

con.add(testPanel,BorderLayout.CENTER);

addWindowListener(new WindowAdapter()

{ public void windowClosing(WindowEvent e)

{ System.exit(0);

}

});

setVisible(true);

setBounds(60,40,660,460);

con.validate();

validate();

}

public static void main(String args[])

{

new EnglishTest();

}

}

//读取试题 ReadTestquestion

import java.io.*;

import java.util.*;

public class ReadTestquestion

{ String filename="",

correctAnswer="",

testContent="",

selection="";

int score=0;

long time=0;

boolean完成考试=false;

File f=null;

FileReader in=null;

BufferedReader读取=null;

public void setFilename(String name)

{ filename=name;

score=0;

selection="";

try{

if(in!=null&&读取!=null)

{

in.close();

读取.close();

}

f=new File(filename);

in=new FileReader(f);

读取=new BufferedReader(in);

correctAnswer=(读取.readLine()).trim();

String temp=(读取.readLine()).trim();

StringTokenizer token=new StringTokenizer(temp,":");

int hour=Integer.parseInt(token.nextToken());

int minute=Integer.parseInt(token.nextToken());

int second=Integer.parseInt(token.nextToken());

time=1000*(second+minute*60+hour*60*60);

}

catch(Exception e)

{

testContent="没有选择试题";

}

}

public String getFilename()

{

return filename;

}

public long getTime()

{

return time;

}

public void set完成考试(boolean b)

{

完成考试=b;

}

public boolean get完成考试()

{

return完成考试;

}

public String getTestContent()

{ try{

String s=null;

StringBuffer temp=new StringBuffer();

if(读取!=null)

{

while((s=读取.readLine())!=null)

{

if(s.startsWith("**"))

break;

temp.append("\n"+s);

if(s.startsWith("endend"))

{

in.close();

读取.close();

完成考试=true;

}

}

testContent=new String(temp);

}

else

{

testContent=new String("没有选择试题");

}

}

catch(Exception e)

{

testContent="试题内容为空,考试结束！！";

}

return testContent;

}

public void setSelection(String s)

{

selection=selection+s;

}

public int getScore()

{ score=0;

int length1=selection.length();

int length2=correctAnswer.length();

int min=Math.min(length1,length2);

for(int i=0;i<min;i++)

{ try{

if(selection.charAt(i)==correctAnswer.charAt(i))

score++;

}

catch(StringIndexOutOfBoundsException e)

{

i=0;

}

}

return score;

}20:10 03-8-31

public String getMessages()

{

int length1=selection.length();

int length2=correctAnswer.length();

int length=Math.min(length1,length2);

String message="正确答案:"+correctAnswer.substring(0,length)+"\n"+

"你的回答:"+selection+"\n";

return message;

}

}

//考试区域TestArea

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

import java.io.*;

class FileName implements FilenameFilter

{

String str=null;

FileName(String s)

{

str="."+s;

}

public boolean accept(File dir,String name)

{

return name.endsWith(str);

}

}

public class TestArea extends JPanel implements ActionListener,ItemListener,Runnable

{

Choice list=null;

JTextArea试题显示区=null,消息区=null;

JCheckBox box[];

JButton提交该题答案,读取下一题,查看分数;

ReadTestquestion读取试题=null;

JLabel welcomeLabel=null;

Thread countTime=null;

long time=0;

JTextField timeShow=null;

boolean是否关闭计时器=false,

是否暂停计时=false;

JButton暂停或继续计时=null;

public TestArea()

{

list= new Choice();

String当前目录=System.getProperty("user.dir");

File dir=new File(当前目录);

FileName fileTxt=new FileName("txt");

String fileName[]=dir.list(fileTxt);

for(int i=0;i<fileName.length;i++)

{

list.add(fileName[i]);

}

试题显示区=new JTextArea(15,12);

试题显示区.setLineWrap(true);

试题显示区.setWrapStyleWord(true);

试题显示区.setFont(new Font("TimesRoman",Font.PLAIN,14));

试题显示区.setForeground(Color.blue);

消息区=new JTextArea(8,8);

消息区.setForeground(Color.blue);

消息区.setLineWrap(true);

消息区.setWrapStyleWord(true);

countTime=new Thread(this);

String s[]={"A","B","C","D"};

box=new JCheckBox[4];

for(int i=0;i<4;i++)

{

box[i]=new JCheckBox(s[i]);

}

暂停或继续计时=new JButton("暂停计时");

暂停或继续计时.addActionListener(this);

提交该题答案=new JButton("提交该题答案");

读取下一题=new JButton("读取第一题");

读取下一题.setForeground(Color.blue);

提交该题答案.setForeground(Color.blue);

查看分数=new JButton("查看分数");

查看分数.setForeground(Color.blue);

提交该题答案.setEnabled(false);

提交该题答案.addActionListener(this);

读取下一题.addActionListener(this);

查看分数.addActionListener(this);

list.addItemListener(this);

读取试题=new ReadTestquestion();

JPanel pAddbox=new JPanel();

for(int i=0;i<4;i++)

{

pAddbox.add(box[i]);

}

Box boxH1=Box.createVerticalBox(),

boxH2=Box.createVerticalBox(),

baseBox=Box.createHorizontalBox();

boxH1.add(new JLabel("选择试题文件"));

boxH1.add(list);

boxH1.add(new JScrollPane(消息区));

boxH1.add(查看分数);

timeShow=new JTextField(20);

timeShow.setHorizontalAlignment(SwingConstants.RIGHT);

timeShow.setEditable(false);

JPanel p1=new JPanel();

p1.add(new JLabel("剩余时间："));

p1.add(timeShow);

p1.add(暂停或继续计时);

boxH1.add(p1);

boxH2.add(new JLabel("试题内容:"));

boxH2.add(new JScrollPane(试题显示区));

JPanel p2=new JPanel();

p2.add(pAddbox);

p2.add(提交该题答案);

p2.add(读取下一题);

boxH2.add(p2);

baseBox.add(boxH1);

baseBox.add(boxH2);

setLayout(new BorderLayout());

add(baseBox,BorderLayout.CENTER);

welcomeLabel=new JLabel("欢迎考试,提高英语水平",JLabel.CENTER);

welcomeLabel.setFont(new Font("隶书",Font.PLAIN,24));

welcomeLabel.setForeground(Color.blue);

add(welcomeLabel,BorderLayout.NORTH);

}

public void itemStateChanged(ItemEvent e)

{

timeShow.setText(null);

是否关闭计时器=false;

是否暂停计时=false;

暂停或继续计时.setText("暂停计时");

String name=(String)list.getSelectedItem();

读取试题.setFilename(name);

读取试题.set完成考试(false);

time=读取试题.getTime();

if(countTime.isAlive())

{

是否关闭计时器=true;

countTime.interrupt();

}

countTime=new Thread(this);

消息区.setText(null);

试题显示区.setText(null);

读取下一题.setText("读取第一题");

提交该题答案.setEnabled(false);

读取下一题.setEnabled(true);

welcomeLabel.setText("欢迎考试,你选择的试题:"+读取试题.getFilename());

}

public void actionPerformed(ActionEvent e)

{

if(e.getSource()==读取下一题)

{

读取下一题.setText("读取下一题");

提交该题答案.setEnabled(true);

String contentTest=读取试题.getTestContent();

试题显示区.setText(contentTest);

消息区.setText(null);

读取下一题.setEnabled(false);

try{

countTime.start();

}

catch(Exception event)

{

}

}

if(e.getSource()==提交该题答案)

{

读取下一题.setEnabled(true);

提交该题答案.setEnabled(false);

String answer="?";

for(int i=0;i<4;i++)

{

if(box[i].isSelected())

{

answer=box[i].getText();

box[i].setSelected(false);

break;

}

}

读取试题.setSelection(answer);

}

if(e.getSource()==查看分数)

{

int score=读取试题.getScore();

String messages=读取试题.getMessages();

消息区.setText("分数:"+score+"\n"+messages);

}

if(e.getSource()==暂停或继续计时)

{

if(是否暂停计时==false)

{

暂停或继续计时.setText("继续计时");

是否暂停计时=true;

}

else if(是否暂停计时==true)

{

暂停或继续计时.setText("暂停计时");

是否暂停计时=false;

countTime.interrupt();

}

}

}

public synchronized void run()

{

while(true)

{

if(time<=0)

{

是否关闭计时器=true;

countTime.interrupt();

提交该题答案.setEnabled(false);

读取下一题.setEnabled(false);

timeShow.setText("用时尽,考试结束");

}

else if(读取试题.get完成考试())

{

是否关闭计时器=true;

timeShow.setText("考试效果:分数*剩余时间(秒)="+1.0*读取试题.getScore()*(time/1000));

countTime.interrupt();

提交该题答案.setEnabled(false);

读取下一题.setEnabled(false);

}

else if(time>=1)

{

time=time-1000;

long leftTime=time/1000;

long leftHour=leftTime/3600;

long leftMinute=(leftTime-leftHour*3600)/60;

long leftSecond=leftTime%60;

timeShow.setText(""+leftHour+"小时"+leftMinute+"分"+leftSecond+"秒");

}

try

{

Thread.sleep(1000);

}

catch(InterruptedException ee)

{

if(是否关闭计时器==true)

return;

}

while(是否暂停计时==true)

{

try

{

wait();

}

catch(InterruptedException ee)

{

if(是否暂停计时==false)

{

notifyAll();

}

}

}

}

}

}

急求java学生信息管理系统源代码,带有连接数据库的,万分感谢

import java.awt.BorderLayout;

import java.awt.CardLayout;

import java.awt.Container;

import java.awt.Font;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.Icon;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JFrame;

import javax.swing.JLabel;

import javax.swing.JMenu;

import javax.swing.JMenuBar;

import javax.swing.JMenuItem;

import javax.swing.JPanel;

import javax.swing.JToolBar;

import javax.swing.SwingConstants;

public class MainFrame extends JFrame implements ActionListener{

InsertPanel ip= null;

SelectPanel sp= null;

JPanel pframe;

JButton jb1,jb2,jb3;

JMenuItem jm11,jm21,jm22,jm23,jm31,jm32,jm41,jm42;

CardLayout clayout;

public MainFrame(String s){

super(s);

JMenuBar mb= new JMenuBar();

this.setJMenuBar(mb);

JMenu m1= new JMenu("系统");

JMenu m2= new JMenu("基本信息");

JMenu m3= new JMenu("成绩");

JMenu m4= new JMenu("奖惩");

mb.add(m1);

mb.add(m2);

mb.add(m3);

mb.add(m4);

jm11= new JMenuItem("退出系统");

jm21= new JMenuItem("输入");

jm22= new JMenuItem("查询");

jm23= new JMenuItem("更改");

jm31= new JMenuItem("输入成绩");

jm32= new JMenuItem("查询成绩");

jm41= new JMenuItem("奖励");

jm42= new JMenuItem("处分");

m1.add(jm11);

m2.add(jm21);

m2.add(jm22);

m2.add(jm23);

m3.add(jm31);

m3.add(jm32);

m4.add(jm41);

m4.add(jm42);

Icon i1= new ImageIcon();

Icon i2= new ImageIcon();

Icon i3= new ImageIcon();

jb1= new JButton(i1);

jb1.setToolTipText("输入");

jb2= new JButton(i2);

jb2.setToolTipText("查询");

jb3= new JButton(i3);

jb3.setToolTipText("退出");

JToolBar tb= new JToolBar("系统工具");

tb.add(jb1);

tb.add(jb2);

tb.add(jb3);

add(tb,BorderLayout.NORTH);

jm11.addActionListener(this);

jm21.addActionListener(this);

jm22.addActionListener(this);

jb1.addActionListener(this);

jb2.addActionListener(this);

jb3.addActionListener(this);

clayout= new CardLayout();

pframe= new JPanel(clayout);

add(pframe);

JPanel mainp= new JPanel(new BorderLayout());

JLabel mainl= new JLabel("学生信息管理平台",SwingConstants.CENTER);

mainl.setFont(new Font("serif",Font.BOLD,30));

mainp.add(mainl);

pframe.add(mainp,"main");

clayout.show(pframe,"main");

}

public void actionPerformed(ActionEvent e){

if(e.getSource()== jm21|| e.getSource()== jb1){

if(ip== null){

ip= new InsertPanel();

pframe.add(ip,"insert");

}

clayout.show(pframe,"insert");

this.setTitle("输入学生信息");

}

else if(e.getSource()== jm22|| e.getSource()== jb2){

if(sp== null){

sp= new SelectPanel();

pframe.add(sp,"select");

}

clayout.show(pframe,"select");

this.setTitle("查询学生信息");

}

else if(e.getSource()== jm11|| e.getSource()== jb3){

System.exit(0);

}

}

}

第二个：

import javax.swing.JFrame;

public class MainTest{

public static void main(String [] args){

MainFrame f= new MainFrame("学生信息管理平台");

f.setSize(400,300);

f.setLocation(350,250);

f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

f.setVisible(true);

}

}

第二个：

import java.sql.Connection;

import java.sql.DriverManager;

public class MySQLConnection{

static Connection getCon(){

Connection con= null;

try{

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

con= DriverManager.getConnection("jdbc:mysql://localhost/test","root","123");

}

catch(Exception e){

System.out.println("建立数据库连接遇到异常！");

}

return con;

}

}

第四个：

import java.awt.BorderLayout;

import java.awt.GridLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JTextField;

import javax.swing.SwingConstants;

public class SelectPanel extends JPanel implements ActionListener{

JButton jb;

JTextField jt;

JTextField jt1,jt2,jt3,jt4;

public SelectPanel(){

JLabel jl= new JLabel("请输入学号:",SwingConstants.CENTER);

jt= new JTextField();

jb= new JButton("确定");

JPanel jp1= new JPanel(new GridLayout(1,3));

jp1.add(jl);

jp1.add(jt);

jp1.add(jb);

JLabel j1,j2,j3,j4;

j1= new JLabel("学号:",SwingConstants.CENTER);

j2= new JLabel("姓名:",SwingConstants.CENTER);

j3= new JLabel("性别:",SwingConstants.CENTER);

j4= new JLabel("年龄:",SwingConstants.CENTER);

jt1= new JTextField(6);

jt1.setEditable(false);

jt2= new JTextField(6);

jt2.setEditable(false);

jt3= new JTextField(6);

jt3.setEditable(false);

jt4= new JTextField(6);

jt4.setEditable(false);

JPanel jp2= new JPanel(new BorderLayout());

JPanel jp3= new JPanel(new GridLayout(4,2));

jp2.add(new JLabel(""),BorderLayout.NORTH);

jp3.add(j1);

jp3.add(jt1);

jp3.add(j2);

jp3.add(jt2);

jp3.add(j3);

jp3.add(jt3);

jp3.add(j4);

jp3.add(jt4);

jp2.add(jp3);

this.setLayout(new BorderLayout());

add(jp1,BorderLayout.NORTH);

add(jp2);

jb.addActionListener(this);

}

public void actionPerformed(ActionEvent e){

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

String stuNo= jt.getText().trim();

Student s= new Student();

boolean b= true;

try{

b= s.selectByStuNo(stuNo);

}

catch(Exception ex){

System.out.println("查询学生信息遇到异常!");

}

if(b){

jt1.setText(s.getStuNo());

jt2.setText(s.getName());

jt3.setText(s.getGender());

int a= s.getAge();

Integer i= new Integer(a);

jt4.setText(i.toString());

}

else{

JOptionPane.showMessageDialog(null,"无此学生!");

}

}

}

}

第五个：

import javax.swing.JFrame;

public class SelectTest{

public static void main(String [] args){

JFrame f= new JFrame("查询学生信息");

SelectPanel p= new SelectPanel();

f.add(p);

f.setSize(400,300);

f.setLocation(300,250);

f.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

f.setVisible(true);

}

}

第六个：

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.Statement;

public class Student{

String stuNo;

String name;

String gender;

int age;

public Student(){}

public Student(String stuNo,String name,String gender, int age){

this.stuNo= stuNo;

this.name= name;

this.gender= gender;

this.age= age;

}

public String getStuNo(){

return stuNo;

}

public void setStuNo(String stuNo){

this.stuNo= stuNo;

}

public String getName(){

return name;

}

public void setName(String name){

this.name= name;

}

public String getGender(){

return gender;

}

public void setGender(String gender){

this.gender= gender;

}

public int getAge(){

return age;

}

public void setAge(int age){

this.age= age;

}

public boolean insertStudent(){

boolean b= true;

try{

Connection con= MySQLConnection.getCon();

Statement statement= con.createStatement();

String sql="insert into student values('"+ stuNo+"','"+ name+"','"+ gender+"',"+ age+")";

sql= new String(sql.getBytes("gb2312"),"ISO8859_1");

statement.executeUpdate(sql);

con.close();

}

catch(Exception e){

b= false;

System.out.println("插入数据库遇到异常！");

}

return b;

}

public boolean selectByStuNo(String stuNo)throws Exception{

boolean b= true;

Connection con= MySQLConnection.getCon();

Statement statement= con.createStatement();

String sql="select* from student where stuNo="+ stuNo;

ResultSet rs= statement.executeQuery(sql);

if(rs!= null&& rs.next()){

String no= rs.getString(1);

this.setStuNo(no);

String n= rs.getString(2);

n= new String(n.getBytes("ISO8859_1"),"gb2312");

this.setName(n);

String g= rs.getString(3);

g= new String(g.getBytes("ISO8859_1"),"gb2312");

this.setGender(g);

this.setAge(rs.getInt(4));

b= true;

}

rs.close();

statement.close();

con.close();

return b;

}

}

数据库你自己弄吧，我没时间弄了！初学得多动手哦

学生信息综合查询管理系统 JAVA程序编写

package test;

import java.sql.*;

import java.awt.*;

import javax.swing.*;

import java.awt.event.*;

import javax.swing.border.*;

import javax.swing.JOptionPane;

class Add extends Panel implements ActionListener{

Connection con;

Statement sql;

Button b1,b2;

TextField tf1,tf2,tf3,tf4,tf5,tf6;

Box baseBox,bv1,bv2;

Add(){

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch(ClassNotFoundException e){}

try{

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql=con.createStatement();

}

catch(SQLException ee){}

setLayout(new BorderLayout());

Panel p1=new Panel();

Panel p2=new Panel();

tf1=new TextField(16);

tf2=new TextField(16);

tf3=new TextField(16);

tf4=new TextField(16);

tf5=new TextField(16);

tf6=new TextField(16);

b1=new Button("录入");

b1.setBackground(Color.green);

b2=new Button("重置");

b2.setBackground(Color.green);

b1.addActionListener(this);

b2.addActionListener(this);

p1.add(b1);

p1.add(b2);

bv1=Box.createVerticalBox();

bv1.add(new Label("学号"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("姓名"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("性别"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("专业"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("年级"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("出生"));

bv1.add(Box.createVerticalStrut(8));

bv2=Box.createVerticalBox();

bv2.add(tf1);

bv2.add(Box.createVerticalStrut(8));

bv2.add(tf2);

bv2.add(Box.createVerticalStrut(8));

bv2.add(tf3);

bv2.add(Box.createVerticalStrut(8));

bv2.add(tf4);

bv2.add(Box.createVerticalStrut(8));

bv2.add(tf5);

bv2.add(Box.createVerticalStrut(8));

bv2.add(tf6);

bv2.add(Box.createVerticalStrut(8));

baseBox=Box.createHorizontalBox();

baseBox.add(bv1);

baseBox.add(Box.createHorizontalStrut(10));

baseBox.add(bv2);

p2.add(baseBox);

add(p1,"South");

add(p2,"Center");

setSize(350,300);

setBackground(Color.pink);

}

public void actionPerformed(ActionEvent e){

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

try{ insert();}

catch(SQLException ee){}

JOptionPane.showMessageDialog(this,"数据已入库!","提示对话框",JOptionPane.INFORMATION_MESSAGE);

}

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

tf1.setText("");

tf2.setText("");

tf3.setText("");

tf4.setText("");

tf5.setText("");

tf6.setText("");

}

}

public void insert() throws SQLException{

String s1="'"+tf1.getText().trim()+"'";

String s2="'"+tf2.getText().trim()+"'";

String s3="'"+tf3.getText().trim()+"'";

String s4="'"+tf4.getText().trim()+"'";

String s5="'"+tf5.getText().trim()+"'";

String s6="'"+tf6.getText().trim()+"'";

String temp="INSERT INTO jesse VALUES("+s1+","+s2+","+s3+","+s4+","+s5+","+s6+")";

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql.executeQuery(temp);

con.close();

}

}

class Query extends Panel implements ActionListener{

Connection con;

Statement sql;

TextField t1,t2,t3,t4,t5,t6;

Button b;

Box baseBox,bv1,bv2;

int flag=0;

Query(){

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch(ClassNotFoundException e){}

try{

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql=con.createStatement();

}

catch(SQLException ee){}

setLayout(new BorderLayout());

b=new Button("查询");

b.setBackground(Color.orange);

b.addActionListener(this);

t1=new TextField(8);

t2=new TextField(16);

t3=new TextField(16);

t4=new TextField(16);

t5=new TextField(16);

t6=new TextField(16);

t2.setEditable(false);

t3.setEditable(false);

t4.setEditable(false);

t5.setEditable(false);

t6.setEditable(false);

Panel p1=new Panel(),p2=new Panel();

p1.add(new Label("输入要查询的学号"));

p1.add(t1);

p1.add(b);

bv1=Box.createVerticalBox();

bv1.add(new Label("姓名"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("性别"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("专业"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("年级"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("出生"));

bv1.add(Box.createVerticalStrut(8));

bv2=Box.createVerticalBox();

bv2.add(t2);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t3);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t4);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t5);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t6);

bv2.add(Box.createVerticalStrut(8));

baseBox=Box.createHorizontalBox();

baseBox.add(bv1);

baseBox.add(Box.createHorizontalStrut(10));

baseBox.add(bv2);

p2.add(baseBox);

add(p1,"North");

add(p2,"Center");

setSize(300,250);

setBackground(Color.red);

}

public void actionPerformed(ActionEvent e){

flag=0;

try{query();}

catch(SQLException ee){}

}

public void query() throws SQLException{

String num,name,sex,subject,grade,born;

con=DriverManager.getConnection("jdbc:odbc:data","","");

ResultSet rs=sql.executeQuery("SELECT* FROM jesse");

while(rs.next()){

num=rs.getString("学号");

name=rs.getString("姓名");

sex=rs.getString("性别");

subject=rs.getString("专业");

grade=rs.getString("年级");

born=rs.getString("出生");

if(num.equals(t1.getText().trim())){

t2.setText(name);

t3.setText(sex);

t4.setText(subject);

t5.setText(grade);

t6.setText(born);

flag=1;

break;

}

}

con.close();

if(flag==0){t1.setText("没有该学生");}

}

}

class Update extends Panel implements ActionListener{

Connection con;

Statement sql;

Button b1,b2,b3;

Box baseBox,bv1,bv2;

TextField t1,t2,t3,t4,t5,t6;

Update(){

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch(ClassNotFoundException e){}

try{

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql=con.createStatement();

}

catch(SQLException ee){}

setLayout(new BorderLayout());

b1=new Button("开始修改");

b1.setBackground(Color.green);

b2=new Button("录入修改");

b2.setBackground(Color.yellow);

b3=new Button("重置");

b3.setBackground(Color.yellow);

b1.addActionListener(this);

b2.addActionListener(this);

b3.addActionListener(this);

t1=new TextField(8);

t2=new TextField(16);

t3=new TextField(16);

t4=new TextField(16);

t5=new TextField(16);

t6=new TextField(16);

Panel p1=new Panel(),p2=new Panel(),p3=new Panel();

p1.add(new Label("输入要修改信息的学号"));

p1.add(t1);

p1.add(b1);

bv1=Box.createVerticalBox();

bv1.add(new Label("(新)姓名"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("(新)性别"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("(新)专业"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("(新)年级"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("(新)出生"));

bv1.add(Box.createVerticalStrut(8));

bv2=Box.createVerticalBox();

bv2.add(t2);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t3);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t4);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t5);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t6);

bv2.add(Box.createVerticalStrut(8));

baseBox=Box.createHorizontalBox();

baseBox.add(bv1);

baseBox.add(Box.createHorizontalStrut(10));

baseBox.add(bv2);

p2.add(baseBox);

p3.add(b2);

p3.add(b3);

add(p1,"North");

add(p2,"Center");

add(p3,"South");

setSize(300,250);

setBackground(Color.cyan);

}

public void actionPerformed(ActionEvent e){

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

try{

String num,name,sex,subject,grade,born;

con=DriverManager.getConnection("jdbc:odbc:data","","");

ResultSet rs=sql.executeQuery("SELECT* FROM jesse");

while(rs.next()){

num=rs.getString("学号");

name=rs.getString("姓名");

sex=rs.getString("性别");

subject=rs.getString("专业");

grade=rs.getString("年级");

born=rs.getString("出生");

if(num.equals(t1.getText().trim())){

t2.setText(name);

t3.setText(sex);

t4.setText(subject);

t5.setText(grade);

t6.setText(born);

break;

}

}

con.close();

}

catch(SQLException ee){}

}

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

try{update();}

catch(SQLException ee){}

}

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

t2.setText("");

t3.setText("");

t4.setText("");

t5.setText("");

t6.setText("");

}

}

public void update() throws SQLException{

String s1="'"+t1.getText().trim()+"'";

String s2="'"+t2.getText().trim()+"'";

String s3="'"+t3.getText().trim()+"'";

String s4="'"+t4.getText().trim()+"'";

String s5="'"+t5.getText().trim()+"'";

String s6="'"+t6.getText().trim()+"'";

String temp="UPDATE jesse SET姓名="+s2+",性别="+s3+",专业="+s4+",年级="+s5+",出生="+s6+" WHERE学号="+s1;

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql.executeQuery(temp);

con.close();

}

}

class Delete extends Panel implements ActionListener{

Connection con;

Statement sql;

TextField t1,t2,t3,t4,t5,t6;

Button b;

Box baseBox,bv1,bv2;

Delete(){

try{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch(ClassNotFoundException e){}

try{

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql=con.createStatement();

}

catch(SQLException ee){}

setLayout(new BorderLayout());

b=new Button("删除");

b.setBackground(Color.cyan);

b.addActionListener(this);

t1=new TextField(8);

t1.addActionListener(this);

t2=new TextField(16);

t3=new TextField(16);

t4=new TextField(16);

t5=new TextField(16);

t6=new TextField(16);

t2.setEditable(false);

t3.setEditable(false);

t4.setEditable(false);

t5.setEditable(false);

t6.setEditable(false);

Panel p1=new Panel(),p2=new Panel();

p1.add(new Label("输入要删除的学号"));

p1.add(t1);

p1.add(b);

bv1=Box.createVerticalBox();

bv1.add(new Label("姓名"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("性别"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("专业"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("年级"));

bv1.add(Box.createVerticalStrut(8));

bv1.add(new Label("出生"));

bv1.add(Box.createVerticalStrut(8));

bv2=Box.createVerticalBox();

bv2.add(t2);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t3);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t4);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t5);

bv2.add(Box.createVerticalStrut(8));

bv2.add(t6);

bv2.add(Box.createVerticalStrut(8));

baseBox=Box.createHorizontalBox();

baseBox.add(bv1);

baseBox.add(Box.createHorizontalStrut(10));

baseBox.add(bv2);

p2.add(baseBox);

add(p1,"North");

add(p2,"Center");

setSize(300,250);

setBackground(Color.green);

}

public void actionPerformed(ActionEvent e){

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

try{delete();}

catch(SQLException ee){}

}

else if(e.getSource()==b){

int n=JOptionPane.showConfirmDialog(this,"确定要删除该学号及全部信息吗?","确定",JOptionPane.YES_NO_OPTION);

if(n==JOptionPane.YES_OPTION){

try{

String s1="'"+t1.getText().trim()+"'";

String temp="DELETE FROM jesse WHERE学号="+s1;

con=DriverManager.getConnection("jdbc:odbc:data","","");

sql.executeUpdate(temp);

con.close();

}

catch(SQLException ee){}

}

else if(n==JOptionPane.NO_OPTION){}

}

}

public void delete() throws SQLException{

String num,name,sex,subject,grade,born;

con=DriverManager.getConnection("jdbc:odbc:data","","");

ResultSet rs=sql.executeQuery("SELECT* FROM jesse");

while(rs.next()){

num=rs.getString("学号");

name=rs.getString("姓名");

sex=rs.getString("性别");

subject=rs.getString("专业");

grade=rs.getString("年级");

born=rs.getString("出生");

if(num.equals(t1.getText().trim())){

t2.setText(name);

t3.setText(sex);

t4.setText(subject);

t5.setText(grade);

t6.setText(born);

break;

}

}

con.close();

}

}

public class tyj extends Frame implements ActionListener{

MenuBar bar=null;

Menu menu1,menu2,menu3,menu4,menu5;

MenuItem item1,item2,item3,item4,item5;

Add zengjia;

Query chaxun;

Update gengxin;

Delete shanchu;

tyj(){

super("欢迎进入学生信息管理系统");

zengjia=new Add();

chaxun=new Query();

gengxin=new Update();

shanchu=new Delete();

bar=new MenuBar();

menu1=new Menu("信息录入");

menu2=new Menu("信息查询");

menu3=new Menu("信息更新");

menu4=new Menu("信息删除");

menu5=new Menu("退出系统");

item1=new MenuItem("录入");

item2=new MenuItem("查询");

item3=new MenuItem("更新");

item4=new MenuItem("删除");

item5=new MenuItem("退出");

menu1.add(item1);

menu2.add(item2);

menu3.add(item3);

menu4.add(item4);

menu5.add(item5);

bar.add(menu1);

bar.add(menu2);

bar.add(menu3);

bar.add(menu4);

bar.add(menu5);

setMenuBar(bar);

item1.addActionListener(this);

item2.addActionListener(this);

item3.addActionListener(this);

item4.addActionListener(this);

item5.addActionListener(this);

Label label=new Label("欢迎进入学生信息管理系统",Label.CENTER);

String s="";

Font f=new Font(s,Font.BOLD,22);

label.setFont(f);

label.setBackground(Color.GREEN);

label.setForeground(Color.BLUE);

add(label,"Center");

setVisible(true);

setSize(320,300);

}

public void actionPerformed(ActionEvent e){

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

removeAll();

add(zengjia,"Center");

validate();

}

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

removeAll();

add(chaxun,"Center");

validate();

}

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

removeAll();

add(gengxin,"Center");

validate();

}

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

removeAll();

add(shanchu,"Center");

validate();

}

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

removeAll();

setBackground(Color.GREEN);

Label label=new Label("欢迎进入学生信息管理系统",Label.CENTER);

String s="";

Font f=new Font(s,Font.BOLD,22);

label.setFont(f);

label.setForeground(Color.BLUE);

add(label,"Center");

validate();

}

}

public static void main(String[] args)

{

tyj jesse=new tyj();

jesse.setVisible(true);

jesse.addWindowListener(new WindowAdapter(){

public void windowClosing(WindowEvent e){

System.exit(0);

}

});

}

}

学生信息管理系统java源代码的介绍就聊到这里吧，感谢你花时间阅读本站内容，更多关于学生管理系统代码、学生信息管理系统java源代码的信息别忘了在本站进行查找哦。