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;
    }
}