studetailbean.java

来自「学生信息管理系统 jsp + sql + javabean 实现」· Java 代码 · 共 254 行

package sms.bean;

import sms.db.DBAccess;
import java.sql.ResultSet;
import java.sql.*;
import java.io.Serializable;
import java.util.ArrayList;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class StuDetailBean implements Serializable {

    public StuDetailBean() {
    }

    private String classId;
    private String collegeId;
    private String password;
    private String studentId;
    private String name;
    private String comeFrom;
    private String sex;
    private String collegeName;
    private String enrollTime;
    private String age;
    private String lenOfSchooling;
    private String nationality;
    private String description;
    private String character;
    private String address;
    private String telephone;
    private String specialty;
    private String eMail;

    public void setEMail(String eMail) {
        this.eMail = eMail;
    }

    public String getEMail() {
        return eMail;
    }

    public void setSpecialty(String specialty) {
        this.specialty = specialty;
    }

    public String getSpecialty() {
        return specialty;
    }

    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }

    public String getTelephone() {
        return telephone;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getAddress() {
        return address;
    }

    public void setCharacter(String character) {
        this.character = character;
    }

    public String getCharacter() {
        return character;
    }

    public void setEnrollTime(String enrollTime) {
        this.enrollTime = enrollTime;
    }

    public String getEnrollTime() {
        return enrollTime;
    }

    public void setAge(String age) {
        this.age = age;
    }

    public String getAge() {
        return age;
    }

    public void setLenOfSchooling(String lenOfSchooling) {
        this.lenOfSchooling = lenOfSchooling;
    }

    public String getLenOfSchooling() {
        return lenOfSchooling;
    }

    public void setNationality(String nationality) {
        this.nationality = nationality;
    }

    public String getNationality() {
        return nationality;
    }

    public String getClassId() {
        return classId;
    }

    public void setDescription(String description) {
        this.description = description;
    }

    public String getDescription() {
        return description;
    }

    public void setClassId(String classId) {
        this.classId = classId;
    }

    public void setStudentId(String studentId) {
        this.studentId = studentId;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public void setCollegeId(String collegeId) {
        this.collegeId = collegeId;
    }

    public void setName(String name) {
        this.name = name;
    }

    public void setComeFrom(String comeFrom) {
        this.comeFrom = comeFrom;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public void setCollegeName(String collegeName) {
        this.collegeName = collegeName;
    }

    public String getCollegeId() {
        return collegeId;
    }

    public String getPassword() {
        return password;
    }

    public String getStudentId() {
        return studentId;
    }

    public String getName() {
        return name;
    }

    public String getComeFrom() {
        return comeFrom;
    }

    public String getSex() {
        return sex;
    }

    public String getCollegeName() {
        return collegeName;
    }


    public static void main(String[] args) {
        StuDetailBean studentbean = new StuDetailBean();
    }

    public StuDetailBean queryStuDetail(String studentId) {
        System.out.println("queryClassStudents() start:1");
        DBAccess dba = new DBAccess();
        String sql = "select a.stu_id,a.name,a.password,a.class_id,a.college_id ,a.come_from,a.sex,a.enroll_time,a.age,a.nationality,a.len_of_schooling,a.description,a.address,a.charact,a.specialty,a.telephone,a.email,b.name collegename from student_info a,college_info b where a.college_id=b.college_id and a.stu_id = " +
                     studentId;
        try {
            dba.getConnection();
            ResultSet rs = dba.query(sql);
            StuDetailBean stuBean = null;
            if (rs != null && rs.next()) {
                stuBean = new StuDetailBean();
                stuBean.setClassId(rs.getString("class_id"));
                stuBean.setCollegeId("college_id");
                stuBean.setComeFrom(rs.getString("come_from"));
                stuBean.setName(rs.getString("name"));
                stuBean.setStudentId(rs.getString("stu_id"));
                stuBean.setSex(rs.getString("sex"));
                stuBean.setCollegeName(rs.getString("collegename"));
                stuBean.setEnrollTime(rs.getString("enroll_time"));
                stuBean.setAge(rs.getString("age"));
                stuBean.setNationality(rs.getString("nationality"));
                stuBean.setLenOfSchooling(rs.getString("len_of_schooling"));
                stuBean.setDescription(rs.getString("description"));
                stuBean.setAddress(rs.getString("address"));
                stuBean.setCharacter(rs.getString("charact"));
                stuBean.setSpecialty(rs.getString("specialty"));
                stuBean.setTelephone(rs.getString("telephone"));
                stuBean.setEMail(rs.getString("email"));
            }
            return stuBean;
        } catch (SQLException ex) {
            System.out.println("产生异常：in StuDetailBean.queryStuDetail()");///////////////////////
            ex.printStackTrace();
            return null;
        } finally {
            dba.closeConnection();
        }
    }


    public boolean modifyStuInfo(String stuId,String age, String address, String telephone,
                                 String eMail, String character, String remark) {
        System.out.println("modifyStuInfo() start:1");
        DBAccess dba = new DBAccess();
        String sql = "update student_info set age=" + age + ",address=" +
                     address + ",telephone=" + telephone;
        sql += ",email=" + eMail + ",charact=" + character + ",description=" +
                remark;
        sql += " where stu_id="+stuId;
        dba.getConnection();
        System.out.println("modifyStuInfo() start:2");
        int flag = dba.executeSql(sql);
        dba.closeConnection();
        if (flag > 0) {
            return true;
        } else {
            return false;
        }
    }
}