student.java

编写的一个访问本地学生数据库的Servlet

import java.sql.*;
import javax.servlet.http.*;

/**
 * Title:        三层结构数据库应用系统
 * Description:  Java语言演示程序：三层结构数据库应用系统，用于北京师范大学计算机系Java课程教学示范。
 * Copyright:    Copyright (c) 2002
 * Company:      北京师范大学计算机系
 * @author 孙一林
 * @version 1.0
 */

 public class Student {
    protected String Number;
    protected String Name;
    protected String Age;
    protected String Sex;
    protected String Department;
    protected java.sql.Date courseDate;
    protected final String CR = "\n";     // carriage return
    public Student() {   }
    public Student(HttpServletRequest request){
        Number = request.getParameter("Number");
        Name = request.getParameter("Name");
        Age = request.getParameter("Age");
        Sex = request.getParameter("Sex");
        Department = request.getParameter("Department");
    }
    public Student(ResultSet dataResultSet) {
        try {
            Number = dataResultSet.getString("学号");
            Name = dataResultSet.getString("姓名");
            Age = dataResultSet.getString("年龄");
            Sex = dataResultSet.getString("性别");
            Department = dataResultSet.getString("系别");
        }
        catch (SQLException e){
            e.printStackTrace();
        }
    }
    public String getNumber(){
        return Number;
    }
    public String getName(){
        return Name;
    }
    public String getAge() {
        return Age;
    }
    public String getSex(){
        return Sex;
    }
    public String getDepartment(){
        return Department;
    }
    public String toString() {
        String replyString = "";
        replyString += "学号：" + Number + CR;
        replyString += "姓名：" + Name + CR;
        replyString += "年龄：" + Age + CR;
        replyString += "性别：" + Sex + CR;
        replyString += "系别：" + Department + CR;
        return replyString;
    }
    public String toWebString() {
        String replyString = "<ul>";
        replyString += "<li><B>学号：</B> " + Number + CR;
        replyString += "<li><B>姓名：</B> " + Name + CR;
        replyString += "<li><B>年龄：</B> " + Age + CR;
        replyString += "<li><B>性别：</B> " + Sex + CR;
        replyString += "<li><B>系别：</B> " + Department + CR;
        replyString += "</ul>" + CR;
        return replyString;
    }
    public String toTableString(int rowNumber){
        String replyString = "";
        String tdBegin = "<td>";
        String tdEnd = "</td>" + CR;
        replyString += "<tr>" + CR;
        replyString += tdBegin + rowNumber + tdEnd;
        replyString += tdBegin + Number + tdEnd;
        replyString += tdBegin + Name + tdEnd;
        replyString += tdBegin + Age + tdEnd;
        replyString += tdBegin + Sex + tdEnd;
        replyString += tdBegin + Department + tdEnd;
        replyString += "</tr>" + CR;
        return replyString;
    }
}