ACH.CNO"));
setName(DBConn.getNewString(rs1.getString("TNAME")));
setSex(DBConn.getNewString(rs1.getString("SEX")));
setTitle(DBConn.getNewString(rs1.getString("TITLE")));
setPassword(DBConn.getNewString(rs1.getString("PASSWORD")));
}
}catch(Exception e){
e.printStackTrace();
}
DBConn.close(); //关闭数据库连接
String sql2 ="select * from STUDENT,STUDY,TEACH where STUDY.SNO=STUDENT.SNO and STUDY.CNO=TEACH.CNO and TEACH.CNO='"+Teacher.courseid+"';";
ResultSet rs2 = DBConn.executeQuery(sql2);
try{
while(rs2.next()){
String[] ste = {rs2.getString("STUDENT.SNO").trim(),rs2.getString("TEACH.CNO").trim()};
scoreInfoList.add(ste);
}
}catch(Exception e){
e.printStackTrace();
}
DBConn.close();
}
public static List getScoreInfoList(){
List scoreInfoList = new ArrayList();
Iterator i = Teacher.scoreInfoList.iterator();
while(i.hasNext()){
String[] str2= (String[])i.next();
ScoreInfo info = new ScoreInfo(str2[0],str2[1]);
scoreInfoList.add(info);
}
return scoreInfoList;
}
public static void setId(String sid){ //设置教师代码的方法
id = sid;
}
public static void setName(String sname){ //设置的方法
name = sname;
}
public static void setSex(String sex){ //设置性别的方法
Teacher.sex = sex;
}
public static void setTitle(String title){ //设置性别的方法
Teacher.title = title;
}
public static void setPassword(String spassword){ //设置密码的方法
password = spassword;
}
public static void setCourse(String courseid){ //设置所教课程的方法
Teacher.courseid=courseid;
}
public static boolean changePassword(String newpassword){ //教师用户修改密码的方法
return DBConn.teacherChangePassword(Teacher.id, newpassword);
}
public static boolean setStudentScore(String studentid,double score){ //修改学生分数的方法
if(score>=0&&score<=100){
return DBConn.teacherSetScoreOfStudent(studentid , courseid, score);
}else {
return false;
}
}
} 2009-04-12 18:44
//StudentCourse.java
/*
*@author ougaoyan ,date:2008-9-29
*/
package com.system.model;
import java.sql.ResultSet;
import com.system.dbconnection.DBConn;
public class StudentCourse extends Course {
public double score;
public String teacher;
public StudentCourse(String studentid,String courseid){ //以学生和课程号为参数的构造函数
super();
String sid = studentid;
String cid = courseid;
try{
String sql ="select * from STUDENT,COURSE,STUDY,TEACHER,TEACH where STUDENT.SNO=STUDY.SNO and STUDY.CNO=COURSE.CNO and COURSE.CNO = TEACH.CNO and TEACH.TNO= TEACHER.TNO and STUDY.SNO='"+sid+"'and STUDY.CNO='"+cid+"';" ;
ResultSet rs = DBConn.executeQuery(sql);
//if(rs != null){
while(rs.next()){
setId(rs.getString("STUDY.CNO"));
setName(DBConn.getNewString(rs.getString("COURSE.CNAME")));
setYear(rs.getString("COURSE.YEAR"));
setTerm(rs.getString("COURSE.TERM"));
setXueshi(rs.getInt("COURSE.XUEFEN")*12);
setXuefen(rs.getInt("COURSE.XUEFEN"));
setScore(rs.getDouble("STUDY.SCORE"));
setTeacher(DBConn.getNewString(rs.getString("TNAME")));
}
//}
DBConn.close(); //关闭数据库连接
}catch(Exception e){
e.printStackTrace();
}
}
public void setScore(double score){
this.score = score;
}
public void setTeacher(String teachername){
teacher = teachername;
}
}
//ScoreInfo.java
/*
*@author ougaoyan ,date:2008-10-2
*/
package com.system.model;
import java.sql.ResultSet;
import com.system.dbconnection.DBConn;
public class ScoreInfo {
public String studentName; //
public String studentId; //
public String studentClass; //班级
public String studentDepartment;//院系
public String couseId; //课程代码
public double score; //分数
public ScoreInfo(String studentid,String courseid){
String sql = "select * from STUDENT,STUDY where STUDENT.SNO = STUDY.SNO and STUDENT.SNO ='"+studentid+"'and STUDY.CNO='"+courseid+"';";
ResultSet rs = DBConn.executeQuery(sql);
try{
while(rs.next()){
setCouseId(rs.getString("CNO"));
setScore(rs.getDouble("SCORE"));
setStudentClass(rs.getString("CLASS"));
setStudentDepartment(DBConn.getNewString(rs.getString("DEPARTMENT")));
setStudentId(rs.getString("STUDENT.SNO"));
setStudentName(DBConn.getNewString(rs.getString("SNAME")));
}
}catch(Exception e){
e.printStackTrace();
}
DBConn.close(); //关闭数据库连接
}/*construct over*/
//public boolean changeScore( ){ //连接数据库修改分数的方法
//return
// }
private void setStudentName(String studentName ){
this.studentName=studentName;
}
private void setStudentId(String studentId){
this.studentId=studentId;
}
private void setStudentClass(String studentClass){
this.studentClass=studentClass;
}
private void setStudentDepartment(String studentDepartment){
this.studentDepartment=studentDepartment;
}
private void setCouseId(String couseId ){
this.couseId=couseId;
}
private void setScore(double score){
this.score=score;
}
} 2009-04-12 18:45
3.system.jiemian包
/*
*@author ougaoyan ,date:2008-9-27
*/
package com.system.jiemian;
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import javax.swing.SwingConstants;
import javax.swing.border.EmptyBorder;
import com.system.model.Student;
import com.system.model.Teacher;
public class LoginJframe extends JFrame { // 登录界面
private static final long serialVersionUID = 8086983321056040840L;
private JPasswordField password; //密码输入框
private JTextField username; //用户名输入框
private JButton studentLogin; //学生登录按钮
private JButton teacherLogin;
private JButton reset; //重置按钮
public LoginJframe() { //登录界面构造器
super();
final BorderLayout borderLayout = new BorderLayout();
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
borderLayout.setVgap(10);
getContentPane().setLayout(borderLayout);
setTitle("学生成绩管理查询系统");
setBounds(400, 250, 285, 194);
final JPanel panel = new JPanel(); /
上一篇:
文本编辑器java
下一篇:
计算机网络毕业论文