src/com/service/liuService.java

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.service;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import java.util.Random;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.dao.DB;
import com.orm.Tkeshi;


public class liuService
{
	//返回所有科室
	public static List keshiList()
	{
		List keshiList=new ArrayList();
		String sql4="select  * from keshi  ";
		Object[] params4={}; 
		DB mydb4=new DB();
		try
		{
			mydb4.doPstm(sql4, params4);
			ResultSet rs4=mydb4.getRs();
			while(rs4.next())
			{
				Tkeshi keshi=new Tkeshi();
				
				keshi.setId(rs4.getInt("id"));			
				keshi.setKeshiming(rs4.getString("keshiming"));					
				keshiList.add(keshi);
		    }
			rs4.close();
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	     mydb4.closed();
	
		return keshiList;
	}
	
	
}