学生综合测评系统(Java)

}

m2.add(m23); m2.add(m24); m3.add(m31); bar.add(m1); bar.add(m2); bar.add(m3);

this.setJMenuBar(bar);

protected void StudentFrm_all_Clicked() { }

protected void StudentFrm_score_all_Clicked() { }

protected void ModifyStudent_score_Clicked() { }

protected void AddStudent_score_Clicked() { }

protected void StudentFrm_score_Clicked() { }

protected void StudentFrm_info_Clicked() { }

protected void ModifyStudent_info_Clicked() { }

protected void StudentFrm_info_all_Clicked() { }

private void DeleteStudent_info_Clicked() { }

new EnterStudentFrm_delete_info(); new StudentFrm_info_all();

new EnterStudentFrm_modify_info(); new EnterStudentFrm_disp_info(); new EnterStudentFrm_disp_score(); new AddStudentFrm_score();

new EnterStudentFrm_modify_score(); new StudentFrm_score_all(); new StudentFrm_all();

Word 资料

}

package project;

import java.math.BigDecimal; import java.sql.*;

public class StudentDao {

private void executeUpdate(String sql) { }

try { }

Class.forName(driver);

Connection con = DriverManager.getConnection(url); Statement cmd = con.createStatement(); cmd.executeUpdate(sql); con.close();

ex.printStackTrace();

private String driver = \; private String url = \; public static void main(String[] args) { }

new MainFrm(); public MainFrm() { }

JPanel jp = (JPanel) this.getContentPane(); initMenu();

this.setTitle(\学生综合测评系统\); this.setSize(1000, 600); this.setVisible(true);

this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); private void exit_Clicked() { }

if (JOptionPane.showConfirmDialog(this, \确认退出？\, \退出系统\,

JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE)

private void AddStudent_info_Clicked() { }

new AddStudentFrm_info();

== JOptionPane.YES_OPTION)

System.exit(0);

} catch (Exception ex) {

Word 资料

public boolean modifyStudent_info(String sno, String sname, String sex, String }

public boolean modifyStudent_score(String sno,double math,double }

public void orderStudent_no_syn(){

String[][] rows = null; int rowcount=0; try {

Class.forName(driver);

Connection con = DriverManager.getConnection(url); Statement cmd = con.createStatement(); String sql = \; ResultSet rs = cmd.executeQuery(sql); rs.next();

rowcount = rs.getInt(1);

rows = new String[rowcount][3];

sql = \; rs = cmd.executeQuery(sql); rowcount = 0; while (rs.next()) {

rows[rowcount][0] = rs.getString(1);

double score_tog,double score_pol,double score_tea,double String sql = \+sno+\+sname+\

+\+tel+\+sno+\;

add ,String tel) { '\+sex+\+add

executeUpdate(sql); orderStudent_no_test(); orderStudent_no_syn(); return true ;

physics,double english,double score_ave, score_syn){

String sql = \+math+\

+\+score_ave+\+score_tog+\+\+score_tea+\+score_syn+\

'\+physics+\+english = '\+score_pol = '\+sno+\;

executeUpdate(sql); orderStudent_no_test(); orderStudent_no_syn(); return true;

Word 资料

}

}

}

rows[rowcount][1] = rs.getString(15);

rows[rowcount][2] = String.valueOf(rowcount+1);

rowcount++;

con.close();

ex.printStackTrace();

} catch (Exception ex) {

for(int i=0;i

executeUpdate(\+rows[i][2]+\

sno='\+rows[i][0]+\);

public void orderStudent_no_test(){ }

String[][] rows = null; int rowcount=0; try { }

for(int i=0;i

executeUpdate(\+rows[i][2]+\Class.forName(driver);

Connection con = DriverManager.getConnection(url); Statement cmd = con.createStatement(); String sql = \; ResultSet rs = cmd.executeQuery(sql); rs.next();

rowcount = rs.getInt(1);

rows = new String[rowcount][3];

sql = \; rs = cmd.executeQuery(sql); rowcount = 0; while (rs.next()) { }

con.close();

ex.printStackTrace();

rows[rowcount][0] = rs.getString(1); rows[rowcount][1] = rs.getString(9);

rows[rowcount][2] = String.valueOf(rowcount+1);

rowcount++;

} catch (Exception ex) {

sno='\+rows[i][0]+\);

Word 资料

{

public boolean addStudent_info(String sno, String sname, String sex, String }

public int addStudent_score(String sno,double math,double physics,double

double score_tog,double score_pol,double score_tea,double score_syn) int flag=-1; try { }

if(flag==0){

String sql = \executeUpdate(sql); return true ;

Class.forName(driver);

Connection con = DriverManager.getConnection(url); Statement cmd = con.createStatement();

String sql = \+sno+\; ResultSet rs = cmd.executeQuery(sql); rs.next(); flag=rs.getInt(1); con.close();

ex.printStackTrace();

add ,String tel) {

} catch (Exception ex) {

values('\+sno+\+sname+\+sex+\+add+\+tel+\;

}else return false;

english,double score_ave,

int flag=-1;

StudentDao studentDao = new StudentDao(); try { }

String[] temp_info=studentDao.queryStudents_info_one(sno); String[] temp_score=studentDao.queryStudents_score_one(sno);

Class.forName(driver);

Connection con = DriverManager.getConnection(url); Statement cmd = con.createStatement();

String sql = \+sno+\; ResultSet rs = cmd.executeQuery(sql); rs.next(); flag=rs.getInt(1); con.close();

ex.printStackTrace();

} catch (Exception ex) {

Word 资料