listengine.java

来自「利用JAVA语言实现」· Java 代码 · 共 85 行

/**
 * 
 */
package com;

import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

/**获取数据库各表的数据
 * @author lab
 *
 */
public class ListEngine {
	
	/**功能：获取用户信息列表
	 * 
	 * @return
	 */
	public  List<User> getUserList(){
		List<User> list = new ArrayList<User>();
		
		String sql = "SElECT * FROM AD_User";
		ResultSet rs = null;
		try {
			ConnDB conn = new ConnDB();
			rs = conn.executeQuery(sql.toString());
			while (rs != null && rs.next()) {
				User user = new User();
				user.setId(rs.getInt("id"));
				user.setName(rs.getString("name"));
				user.setPwd(rs.getString("pwd"));
				user.setEmail(rs.getString("email"));
				
				list.add(user);
			}
			
		} catch (Exception e) {
			System.out.println(e);
			
		}
		
		return list;
	}
	
	/**功能：根据 ‘症状’ 获取相关语料库列表
	 * 
	 * @param symptom ‘症状’ 关键字
	 * @return
	 */
	public  List<CureData> getCureDataList(String symptom){
		List<CureData> list = new ArrayList<CureData>();
		
		String m_symptom = (symptom == null) ? "" : symptom;
		String sql = "SElECT id,symptom,addDate FROM CureData";
		sql += " WHERE symptom LIKE '%"+m_symptom+"%'";
		sql += " ORDER BY addDate DESC";
		ResultSet rs = null;
		try {
			ConnDB conn = new ConnDB();
			rs = conn.executeQuery(sql.toString());
			while (rs != null && rs.next()) {
				CureData cureData = new CureData();
				cureData.setId(rs.getInt("id"));
				cureData.setSymptom(rs.getString("symptom"));
				cureData.setAddDate(rs.getString("addDate"));
				
				list.add(cureData);
			}
			
		} catch (Exception e) {
			System.out.println(e);
			
		}
		
		return list;
	}
	
	public static void main(String[] args){
		//ListEngine li = new ListEngine();
		//System.out.println(li.getUserList().size());
  		
	}
}