enrollmentbo.java

网上报名系统,是一个功能很完善的系统,推存给大家,很好用的

package bo;

import java.util.List;
import java.util.ArrayList;
import myjdbc.DatabaseOperation;

import java.util.*;
import struts.actionform.EnrollmentForm;
import java.io.UnsupportedEncodingException;
import vo.WbApplicantInfo;

public class EnrollmentBo {
  private static EnrollmentBo rbo = null;
  private static DatabaseOperation db = null;
  private EnrollmentBo() {
    db = DatabaseOperation.getInstance();
  }
  public static EnrollmentBo getInstance()
  {
    if (rbo == null)
      rbo = new EnrollmentBo();
    return rbo;
  }
  public String saveNewApplicant(EnrollmentForm form)
  {
    try {
      WbApplicantInfo temp = form.getWbApplicantInfo();
      StringBuffer sql = new StringBuffer();
      sql.append("INSERT INTO Wb_ApplicantInfo (id_card, name, password, sex, telephone, enroll_time, note) ");
      sql.append("VALUES('").append(temp.getIdCard()).append("', ");
      sql.append("'").append(convertEncoding(temp.getName())).append("', ");
      sql.append("'").append(convertEncoding(temp.getPassword())).append("', ");
      sql.append("'").append(convertEncoding(temp.getSex())).append("', ");
      sql.append("'").append(convertEncoding(temp.getTelephone())).append("', ");
      sql.append("'").append(new java.sql.Date(System.currentTimeMillis()).toString()).append("', ");
      sql.append("'").append(convertEncoding(temp.getNote())).append("' ");
      sql.append(")");
      System.out.println("sql = " + sql.toString());
      db.executeSQL(sql.toString());
      return "保存成功！";
    }catch(Exception e) {
      e.printStackTrace();
      return "保存失败！";
   }
  }

  public String saveModifyRelation(EnrollmentForm form) {
    try {
    WbApplicantInfo temp = form.getWbApplicantInfo();
    String idCard = form.getIdCard();
    StringBuffer sql = new StringBuffer();
    sql.append("UPDATE Wb_ApplicantInfo ");
    sql.append("SET id_card = ").append("'").append(convertEncoding(temp.getIdCard())).append("', ");
    sql.append("name = ").append("'").append(convertEncoding(temp.getName())).append("', ");
    sql.append("password = ").append("'").append(convertEncoding(temp.getPassword())).append("', ");
    sql.append("sex = ").append("'").append(convertEncoding(temp.getSex())).append("', ");
    sql.append("telephone = ").append("'").append(convertEncoding(temp.getTelephone())).append("', ");
    sql.append("enroll_time = ").append("'").append(new java.sql.Date(System.currentTimeMillis()).toString()).append("', ");
    sql.append("note = ").append("'").append(convertEncoding(temp.getNote())).append("' ");
    sql.append("WHERE id_card = '").append(idCard).append("' ");
    System.out.println("sql = " + sql.toString());
    db.executeSQL(sql.toString());
    return "修改成功！";
    }catch(Exception e){
      e.printStackTrace();
      return "修改失败！";
    }
  }
  public void getApplicantInfoByIdCard(EnrollmentForm form) throws Exception{
      String idCard = form.getIdCard();
      String sql = "select * from Wb_ApplicantInfo where id_card ='"+idCard+"' ";
     System.out.println("idCard = " + idCard +",and sql = " + sql);
      List rs = db.executeSQL(sql);
      if (rs.size() > 1)
          throw new Exception("主键(" + idCard +
                              ")重复，请检查数据库表Wb_ApplicantInfo中已有的记录！");
      form.setWbApplicantInfo((WbApplicantInfo) rs.get(0));
  }

  private static String convertEncoding(String old)
 {
   try
   {
     return new String(old.getBytes("ISO8859-1"));
   }catch(UnsupportedEncodingException e)
   {
     e.printStackTrace();
     return "编码转化出错！";
   }
 }

}