curedatamanage.java

利用JAVA语言实现

package com;


import java.sql.Date;
import java.sql.ResultSet;


/**
 * 处理语料库信息的类
 * @author lab
 *
 */
public class CureDataManage {
	
	/**功能：添加语料信息对象
	 * 
	 * @param user 需添加的语料信息对象
	 * @return true:添加成功！ false:添加失败！
	 */
	public boolean add(CureData cureData){
		
		StringBuffer sql = new StringBuffer();
		sql.append("INSERT INTO CureData(symptom,treatment,addDate) VALUES(");
		sql.append("'" + cureData.getSymptom() + "',");
		sql.append("'" + cureData.getTreatment() + "',");
		sql.append("'" + cureData.getAddDate() + "')");
		
		//向数据表CureData添加一条记录
		ConnDB conn = new ConnDB();
		if(conn.executeUpdate(sql.toString()) == 0){ //添加失败
			return false;
			
		}else{
			return true;
		}
	}
	
	/**功能：修改语料信息对象
	 * 
	 * @param user 需修改的语料信息对象
	 * @return true:修改成功！ false:修改失败！
	 */
	public boolean update(CureData cureData){
		
		StringBuffer sql = new StringBuffer();
		sql.append("UPDATE CureData ");
		sql.append("SET symptom='" + cureData.getSymptom() + "',");
		sql.append("treatment='" + cureData.getTreatment() + "',");
		sql.append("addDate='" + cureData.getAddDate() + "'");
		sql.append(" WHERE id=" + String.valueOf(cureData.getId()));
	
		//修改数据表CureData一条记录
		ConnDB conn = new ConnDB();
		if(conn.executeUpdate(sql.toString()) == 0){ //修改失败
			return false;
			
		}else{
			return true;
		}
	}
	
	/**功能：根据 id 删除单条语料信息
	 * 
	 * @param id
	 * @return true:删除成功！ false:删除失败！
	 */
	public boolean deleteById(int id){
		
		StringBuffer sql = new StringBuffer();
		sql.append("DELETE FROM CureData WHERE ");
		sql.append("id=" + String.valueOf(id));
		
		//删除数据表CureData一条记录
		ConnDB conn = new ConnDB();
		if(conn.executeUpdate(sql.toString()) == 0){ //删除失败
			return false;
			
		}else{
			return true;
		}
	}
	
	/**功能：根据 id 获取语料信息对象
	 * 
	 * @param id 唯一的id号
	 * @return 
	 */
	public CureData getDataById(int id){
		
		StringBuffer sql = new StringBuffer();
		sql.append("SElECT * FROM CureData WHERE");
		sql.append(" id=" + String.valueOf(id));
		CureData cureData = new CureData();
		ResultSet rs = null;
		String treatment = "";
		try {
			ConnDB conn = new ConnDB();
			rs = conn.executeQuery(sql.toString());
			if (rs != null && rs.next()) {
				cureData.setId(rs.getInt("id"));
				cureData.setSymptom(rs.getString("symptom"));
				treatment = rs.getString("treatment");
				
				//替换文本中的回车换行、空格
				treatment = Util.convertStr(treatment);
				
				cureData.setTreatment(treatment);
				cureData.setAddDate(rs.getString("addDate"));
			}
			
		} catch (Exception e) {
			System.out.println(e);
		}
		
		return cureData;
	}
	
}