学生综合测评系统(Java)

}

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

double score_ave,score_syn;

score_ave=(Double.valueOf(txt_math.getText())+Double.valueOf(txt_physics.getT

score_syn=score_ave*0.6+Double.valueOf(txt_score_tog.getText())*0.1+Double.v

if(studentDao.modifyStudent_score(txt_sno.getText(),Double.valueOf(txt_math.g

ext())+Double.valueOf(txt_english.getText()))/3;

alueOf(txt_score_pol.getText())*0.1+Double.valueOf(txt_score_tea.getText())*0.2;

etText()),Double.valueOf(txt_physics.getText()),Double.valueOf(txt_english.getText()),

score_ave,Double.valueOf(txt_score_tog.getText()),Double.valueOf(txt_score_po }

}

if (e.getSource() == btn_del) { }

dispose();

JOptionPane.showMessageDialog(this, \学号为\ + txt_sno.getText() + \的记dispose();

l.getText()),Double.valueOf(txt_score_tea.getText()),score_syn)) 录修改成功!\);

package project; import javax.swing.*;

import javax.swing.table.DefaultTableModel; import java.awt.*; import java.awt.event.*;

public class StudentFrm_all extends JFrame{

private void updateTable() { }

String[][] rows = studentDao.queryStudents_all(); table.setModel(new DefaultTableModel(rows, cols)); private void initTable() { }

String[][] rows = studentDao.queryStudents_all(); table = new JTable(rows, cols); private JTable table = null;

private String[] cols = { \学号\,\姓名\,\性别\,\家庭住址\,\联系\,\高等数学\,\物理\,\英语\,

\考试平均成绩\,\考试名次\,\同学互评分\,\品德成绩\,\任课教师评分\,\综

合测评总分\,\综合测评名次\};

private StudentDao studentDao = new StudentDao();

Word 资料

}

public StudentFrm_all() { }

public static void main(String[] args) { }

new StudentFrm_all();

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

JScrollPane jsp_table = new JScrollPane(table); jp.add(jsp_table);

JPanel jp_top = new JPanel(); jp.add(jp_top, BorderLayout.NORTH); this.setSize(600, 400); this.setTitle(\全部学生信息\); this.setVisible(true);

package project; import javax.swing.*;

import javax.swing.table.DefaultTableModel; import java.awt.*; import java.awt.event.*;

public class StudentFrm_info_all extends JFrame{

private void updateTable() { }

public StudentFrm_info_all() {

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

JScrollPane jsp_table = new JScrollPane(table); jp.add(jsp_table);

JPanel jp_top = new JPanel(); jp.add(jp_top, BorderLayout.NORTH); this.setSize(600, 400); this.setTitle(\学生信息\this.setVisible(true);

String[][] rows = studentDao.queryStudents_info_all(); table.setModel(new DefaultTableModel(rows, cols)); private void initTable() { }

String[][] rows = studentDao.queryStudents_info_all(); table = new JTable(rows, cols); private JTable table = null;

private String[] cols = { \学号\姓名\性别\家庭住址\联系\private StudentDao studentDao = new StudentDao();

Word 资料

}

}

public static void main(String[] args) { }

new StudentFrm_info_all();

package project; import javax.swing.*;

import javax.swing.table.DefaultTableModel; import java.awt.*; import java.awt.event.*;

public class StudentFrm_score_all extends JFrame{

private void updateTable(int t) { }

public StudentFrm_score_all() {

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

JScrollPane jsp_table = new JScrollPane(table); jp.add(jsp_table);

JPanel jp_top = new JPanel(); jp_top.add(no_testBtn); jp_top.add(no_synBtn);

jp.add(jp_top, BorderLayout.NORTH); this.setSize(600, 400); this.setTitle(\学生成绩\); this.setVisible(true);

no_testBtn.addActionListener(new ActionListener() {

public void actionPerformed(ActionEvent e) { }

updateTable(1);

String[][] rows = studentDao.queryStudents_score_all(t); table.setModel(new DefaultTableModel(rows, cols)); private void initTable() { }

String[][] rows = studentDao.queryStudents_score_all(0); table = new JTable(rows, cols); private JTable table = null;

private JButton no_testBtn = new JButton(\按考试名次排序\); private JButton no_synBtn = new JButton(\按综合名次排序\); private String[] cols = { \学号\,\姓名\,\高等数学\,\物理\,\英语\,

\考试平均成绩\,\考试名次\,\同学互评分\,\品德成绩\,\任课教师评分\,\综

合测评总分\,\综合测评名次\};

private StudentDao studentDao = new StudentDao();

Word 资料

}

}

});

no_synBtn.addActionListener(new ActionListener() { });

public void actionPerformed(ActionEvent e) { }

updateTable(2);

public static void main(String[] args) { }

new StudentFrm_score_all();

Word 资料