江阴网站建设,江阴网站制作,江阴网站设计,江阴SEO优化,江阴小程序开发-江阴雨辰互联

  1. JustNews 首页
  2. 网站建设

java学生成绩管理系统代码

admin••网站建设•阅读20

java学生成绩管理系统代码


2024年1月24日发(作者：)

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import Header;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import .*;

import tTableModel;

import Header;

import .*;

import .*;

import .*;

import .*;

class AddForm extends JFrame implements ActionListener{

JLabel labName=new JLabel("学号：");

JLabel labDate=new JLabel("出生日期：");

JLabel labScore=new JLabel("成绩：");

JTextField txtName=new JTextField(20);

JTextField txtDate=new JTextField(18);

JTextField txtScore=new JTextField(20);

JButton btnOk=new JButton("确定");

JButton btnClear=new JButton("清空");

JPanel pan=new JPanel();

JPanel pan1=new JPanel();

JPanel pan2=new JPanel();

JPanel pan3=new JPanel();

JPanel pan4=new JPanel();

Connection cnn;

Statement stm;

ResultSet rs;

AddForm(){

super("添加数据");

setSize(400,300);

setDefaultCloseOperation(E_ON_CLOSE);

der(EtchedBorder());

(labName);

(txtName);

(labDate);

(txtDate);

(labScore);

(txtScore);

(btnOk);

(btnClear);

out(new GridLayout(3,1));

(pan1);

(pan2);

(pan3);

getContentPane().add(pan,"Center");

getContentPane().add(pan4,"South");

ionListener(this);

ionListener(this);

setVisible(true);

tFocus();

}

public void actionPerformed(ActionEvent ae){

if(rce()==btnClear){

t("");

t("");

t("");

tFocus();

}else if(rce()==btnOk){

String strName=t();

String strDate=t();

String strScore=t();

if((""))

ssageDialog(this,"学号不能为空！","警告",_MESSAGE);

else if((""))

ssageDialog(this,"出生日期不能为空！","警告",_MESSAGE);

else if((""))

ssageDialog(this,"成绩不能为空！","警告",_MESSAGE);

else{

try {

e("bcDriver");

} catch (ClassNotFoundException ex) {

tackTrace();

}

try {

cnn=nection("Jdbc:Odbc:MyDB");

stm=Statement();

} catch (SQLException ex) {

tackTrace();

}

try{

rs = eQuery("select * from 成绩表 where 学号='" +strName

+ "'");

if (()) {

ssageDialog(this,"对不起，该成绩信息已存在！");

} else //否则插入记录

{

//n("insert

values('"+strName+"',#"+strDate+"#,"+strScore+")");

eUpdate("insert

into

into

成成绩绩表

表

values('"+strName+"','"+strDate+"',"+strScore+")");

ssageDialog(null,"记录已经成功添加！");

}

//断开连接

();

();

} catch (SQLException ex) {

n("SQLException:" + sage());

}

}

}

}

public static void main(String[] args) {

new AddForm();

}

}

class BrowseForm extends JFrame {

String []str={"学号","出生日期","成绩"};

Object[][] data;

JTable table;

JTableHeader head;

JScrollPane jsp;

Connection conn;

Statement stmt;

ResultSet rs;

BrowseForm(){

super("浏览数据");

setSize(400,300);

int i=0,j=0;

int row;

try{

e("bcDriver");

conn=nection("jdbc:odbc:MyDB","","");

stmt=Statement();

rs=eQuery("select COUNT(*) as a from 成绩表");

();

row=("a");

();

data=new Object[row][3];

rs=eQuery("select * from 成绩表");

while(()){

data[i][j++]=ing("学号");

data[i][j++]=e("出生日期");

data[i][j]=new Integer(("成绩"));

i++;j=0;

}

table=new JTable(data,str);

head=leHeader();

jsp=new JScrollPane(table);

getContentPane().add(head,"North");

getContentPane().add(jsp,"Center");

();

();

();

}catch(Exception e){

tackTrace();

}

setDefaultCloseOperation(E_ON_CLOSE);

setVisible(true);

}

public static void main(String[] args) {

new BrowseForm();

}

}

class DeleteForm extends JFrame implements ActionListener{

JLabel labName=new JLabel("学号：");

JLabel labDate=new JLabel("出生日期：");

JLabel labScore=new JLabel("成绩：");

JTextField txtName=new JTextField(20);

JTextField txtDate=new JTextField(18);

JTextField txtScore=new JTextField(20);

JButton btnDel=new JButton("删除");

JButton btnCancel=new JButton("取消");

JButton btnQuery=new JButton("查询");

JPanel pan=new JPanel();

JPanel pan1=new JPanel();

JPanel pan2=new JPanel();

JPanel pan3=new JPanel();

JPanel pan4=new JPanel();

Connection cnn;

Statement stm;

ResultSet rs;

DeleteForm(){

super("删除数据");

setSize(400,300);

setDefaultCloseOperation(E_ON_CLOSE);

der(EtchedBorder());

(labName);

(txtName);

(labDate);

(txtDate);

(labScore);

(txtScore);

(btnQuery);

(btnDel);

(btnCancel);

out(new GridLayout(3,1));

(pan1);

(pan2);

(pan3);

getContentPane().add(pan,"Center");

getContentPane().add(pan4,"South");

ionListener(this);

ionListener(this);

ionListener(this);

bled(false);

table(false);

table(false);

setVisible(true);

tFocus();

}

public void actionPerformed(ActionEvent ae){

/* if(rce()==btnCancel){

try {

if(stm!=null)

();

if(cnn!=null)

();

} catch (SQLException ex) {

tackTrace();

}

e();

} else if(rce()==btnQuery){

try{

e("bcDriver");

cnn=nection("jdbc:odbc:MyDB","","");

stm=Statement();

rs=eQuery("select * from 成绩表 where 学号

='"+t()+"'");

if(()){

t(ing("学号"));

t(e("出生日期").toString());

t(new Integer(("成绩")).toString

());

bled(true);

}else{

ssageDialog(this,"不存在该记录！");

bled(false);

t("");

t("");

t("");

}

}catch(Exception e){

tackTrace();

}

}else if(rce()==btnDel){

try {

if(_OPTION==nfirmDialog

(this,"确定要删除该记录？","信息",_NO_OPTION)){

eUpdate("delete from 成绩表 where 学号

='"+t()+"'");

bled(false);

t("");

t("");

t("");

}

}

catch (SQLException ex) {

tackTrace();

}

}*/

}

public static void main(String[] args) {

new DeleteForm();

}

}

class LoginForm extends JFrame implements ActionListener{

JLabel labName=new JLabel("姓名");

JLabel labPwd=new JLabel("密码");

JTextField txtName=new JTextField(20);

JPasswordField txtPwd=new JPasswordField(20);

JButton btnOk=new JButton("确定");

JButton btnCancel=new JButton("取消");

JPanel pan=new JPanel();

JPanel pan1=new JPanel();

JPanel pan2=new JPanel();

JPanel pan3=new JPanel();

JPanel pan4=new JPanel();

Connection cnn;

Statement stm;

ResultSet rs;

LoginForm(){

super("用户登录");

setSize(300,200);

setDefaultCloseOperation(E_ON_CLOSE);

der(TitledBorder("登录"));

out(new GridLayout(2,1));

(labName);

(txtName);

(labPwd);

(txtPwd);

(pan1);

(pan2);

(btnOk);

(btnCancel);

(pan);

getContentPane().add(pan4,"Center");

getContentPane().add(pan3,"South");

ionListener(this);

ionListener(this);

ionListener(this);

ionListener(this);

setVisible(true);

try {

e("bcDriver");

} catch (ClassNotFoundException ex) {

tackTrace();

}

try {

cnn=nection("Jdbc:Odbc:MyDB");

stm=Statement();

} catch (SQLException ex) {

tackTrace();

}

tFocus();

}

public void actionPerformed(ActionEvent ae){

if(rce()==txtName)

tFocus();

else if(rce()==txtPwd)

tFocus();

else if(rce()==btnCancel){

t("");

t("");

tFocus();

}else if(rce()==btnOk){

String str="select * from 用户表 where 用户名='"+t()+"'and 密码='"+new String(sword())+"'";

try {

rs=eQuery(str);

} catch (SQLException ex) {

tackTrace();

}

try {

if(()){

ssageDialog(this,"验证通过!","信息",ATION_MESSAGE);

();

();

();

new MainForm().setVisible(true);

e();

}else{

ssageDialog(this,"用户名或密码不正确!","信息",ATION_MESSAGE);

}

} catch (SQLException ex) {

tackTrace();

}

}

}

public static void main(String[] args) {

new LoginForm();

}

}

class ModifyForm extends JFrame implements ActionListener{

JLabel labName=new JLabel("学号：");

JLabel labDate=new JLabel("出生日期：");

JLabel labScore=new JLabel("成绩：");

JTextField txtName=new JTextField(20);

JTextField txtDate=new JTextField(18);

JTextField txtScore=new JTextField(20);

JButton btnModify=new JButton("修改");

JButton btnCancel=new JButton("取消");

JButton btnQuery=new JButton("查询");

JPanel pan=new JPanel();

JPanel pan1=new JPanel();

JPanel pan2=new JPanel();

JPanel pan3=new JPanel();

JPanel pan4=new JPanel();

Connection cnn;

Statement stm;

ResultSet rs;

ModifyForm(){

super("修改数据");

setSize(400,300);

setDefaultCloseOperation(E_ON_CLOSE);

der(EtchedBorder());

(labName);

(txtName);

(labDate);

(txtDate);

(labScore);

(txtScore);

(btnQuery);

(btnModify);

(btnCancel);

out(new GridLayout(3,1));

(pan1);

(pan2);

(pan3);

getContentPane().add(pan,"Center");

getContentPane().add(pan4,"South");

ionListener(this);

ionListener(this);

ionListener(this);

bled(false);

table(false);

table(false);

setVisible(true);

tFocus();

}

public void actionPerformed(ActionEvent ae){

if(rce()==btnCancel){

try {

if(stm!=null)

();

if(cnn!=null)

();

} catch (SQLException ex) {

tackTrace();

}

e();

} else if(rce()==btnQuery){

try{

e("bcDriver");

cnn=nection("jdbc:odbc:MyDB","","");

stm=Statement();

rs=eQuery("select * from 成绩表 where

='"+t()+"'");

if(()){

t(ing("学号"));

t(new Integer(("成绩")).toString());

t(e("出生日期").toString());

bled(true);

table(true);

table(true);

}else{

ssageDialog(this,"不存在该记录！");

bled(false);

t("");

t("");

t("");

table(false);

table(false);

}

}catch(Exception e){

tackTrace();

}

}else if(rce()==btnModify){

try{

n("Update 成绩表 set 出生日期=#"+t()+"#,成绩="+t()+" where 学号='"+t()+"'");

学号

eUpdate("Update 成绩表 set 出生日期=#"+t()+"#,成绩="+t()+" where 学号='"+t()+"'");

ssageDialog(this,"记录修改完毕！");

bled(false);

t("");

t("");

t("");

table(false);

table(false);

();

();

}catch(Exception e){

tackTrace();

}

}

}

public static void main(String[] args) {

new ModifyForm();

}

}

class NumberQueryForm extends JFrame implements ActionListener{

JLabel labName=new JLabel("学号：");

JLabel labDate=new JLabel("出生日期：");

JLabel labScore=new JLabel("成绩：");

JTextField txtName=new JTextField(20);

JTextField txtDate=new JTextField(18);

JTextField txtScore=new JTextField(20);

JButton btnCancel=new JButton("取消");

JButton btnQuery=new JButton("查询");

JPanel pan=new JPanel();

JPanel pan1=new JPanel();

JPanel pan2=new JPanel();

JPanel pan3=new JPanel();

JPanel pan4=new JPanel();

Connection cnn;

Statement stm;

ResultSet rs;

NumberQueryForm(){

super("按学号查询");

setSize(400,300);

setDefaultCloseOperation(E_ON_CLOSE);

der(EtchedBorder());

(labName);

(txtName);

(labDate);

(txtDate);

(labScore);

(txtScore);

(btnQuery);

(btnCancel);

out(new GridLayout(3,1));

(pan1);

(pan2);

(pan3);

getContentPane().add(pan,"Center");

getContentPane().add(pan4,"South");

ionListener(this);

ionListener(this);

table(false);

table(false);

setVisible(true);

tFocus();

}

public void actionPerformed(ActionEvent ae){

if(rce()==btnCancel){

try {

if(stm!=null)

();

if(cnn!=null)

();

} catch (SQLException ex) {

tackTrace();

}

e();

} else if(rce()==btnQuery){

try{

e("bcDriver");

cnn=nection("jdbc:odbc:MyDB","","");

stm=Statement();

rs=eQuery("select * from 成绩表 where

='"+t()+"'");

if(()){

t(ing("学号"));

学号

t(new Integer(("成绩")).toString());

t(e("出生日期").toString());

}else{

ssageDialog(this,"不存在该记录！");

t("");

t("");

t("");

tFocus();

}

}catch(Exception e){

tackTrace();

}

}

}

public static void main(String[] args) {

new NumberQueryForm();

}

}

class ScoreQueryForm extends JFrame implements ActionListener{

JLabel labScore=new JLabel("请输入成绩：");

JTextField txtScore=new JTextField(10);

JButton btnQuery=new JButton("查询");

JPanel pan1=new JPanel();

JPanel pan2=new JPanel();

String []str={"学号","出生日期","成绩"};

Object[][] data=new Object[10][3];

JTable table=new JTable(data,str);

JTableHeader head=leHeader();

JScrollPane jsp=new JScrollPane(table);

Connection conn;

Statement stmt;

ResultSet rs;

ScoreQueryForm(){

super("按成绩查询");

setSize(400,300);

(labScore);

(txtScore);

(btnQuery);

getContentPane().add(pan1,"North");

table=new JTable(data,str);

out(new BorderLayout());

head=leHeader();

jsp=new JScrollPane(table);

(head,"North");

(jsp,"Center");

getContentPane().add(pan2,"Center");

ionListener(this);

setDefaultCloseOperation(E_ON_CLOSE);

setVisible(true);

}

public void actionPerformed(ActionEvent ae){

if(rce()==btnQuery){

int i,j,row;

try{

e("bcDriver");

conn=nection("jdbc:odbc:MyDB","","");

stmt=Statement();

rs=eQuery("select COUNT(*) as rowcount from 成绩表 where

成绩="+t());

();

row=("rowcount");

();

data=new Object[row][3];

rs=eQuery("select

="+t());

i=0;j=0;

while(()){

data[i][j++]=ing("学号");

data[i][j++]=e("出生日期");

data[i][j]=new Integer(("成绩"));

i++;j=0;

}

All();

getContentPane().remove(pan2);

table=new JTable(data,str);

out(new BorderLayout());

head=leHeader();

jsp=new JScrollPane(table);

(head,"North");

(jsp,"Center");

getContentPane().add(pan2,"Center");

te();

* from 成绩表 where 成绩

();

();

();

}catch(Exception e){

tackTrace();

}

}

}

public static void main(String[] args) {

new ScoreQueryForm();

}

}

class MyPanel extends JPanel{

Image img=aultToolkit().getImage("c:/");

public void paint(Graphics g){

age(img,0,0,this);

}

}

class MainForm extends JFrame implements ActionListener{

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

JMenuItem mExit=new JMenuItem("退出");

JMenu mOperate=new JMenu("数据操作");

JMenuItem mAdd=new JMenuItem("添加");

JMenuItem mDel=new JMenuItem("删除");

JMenuItem mModify=new JMenuItem("修改");

JMenuItem mBrowse=new JMenuItem("浏览");

JMenu mQuery=new JMenu("查询");

JMenuItem mNumber=new JMenuItem("按学号查询");

JMenuItem mScore=new JMenuItem("按成绩查询");

JMenu mHelp=new JMenu("帮助");

JMenuItem mAbout=new JMenuItem("关于");

JMenuBar mBar=new JMenuBar();

MainForm(){

super("学生成绩管理系统");

setSize(700,630);

setDefaultCloseOperation(E_ON_CLOSE);

(mExit);

(mAdd);

(mDel);

(mModify);

(mBrowse);

(mNumber);

(mScore);

(mAbout);

(mSystem);

(mOperate);

(mQuery);

(mHelp);

setJMenuBar(mBar);

ionListener(this);

ionListener(this);

ionListener(this);

ionListener(this);

ionListener(this);

ionListener(this);

ionListener(this);

ionListener(this);

setContentPane(new MyPanel());

setVisible(true);

}

public void actionPerformed(ActionEvent ae){

if(rce()==mExit)

(0);

else if(rce()==mAbout)

ssageDialog(this,"学生管理系统 V1.0nn重庆邮电大学计算机学院nn2011年11月","关于",ATION_MESSAGE);

else if(rce()==mAdd)

new AddForm().setVisible(true);

else if(rce()==mDel)

new DeleteForm().setVisible(true);

else if(rce()==mModify)

new ModifyForm().setVisible(true);

else if(rce()==mBrowse)

new BrowseForm().setVisible(true);

else if(rce()==mNumber)

new NumberQueryForm().setVisible(true);

else if(rce()==mScore)

new ScoreQueryForm().setVisible(true);

}

public static void main(String[] args) {

new MainForm();

}

}


发布者：admin，转转请注明出处：http://www.yc00.com/web/1706098402a1440446.html

adminadmin
0

相关推荐

发表回复

评论列表（0条）

  • 暂无评论

联系我们

400-800-8888

在线咨询： QQ交谈

邮件：admin@example.com

工作时间：周一至周五，9:30-18:30，节假日休息

关注微信