teacherselect.java

来自「功能是公安和学校的管理系统,用struts+hibernate+spring等匡」· Java 代码 · 共 46 行

package com.comingnet.bean;
import java.util.*;
import com.db.*;
import java.sql.*;
public class TeacherSelect {
	Connection conn=null;
	PreparedStatement stmt=null;
	ResultSet rs=null;
	public TeacherSelect()
	{
		
	}
	public Map getTeacherInfor(String zdkc)
	{
		String sqlStr=""; 
		Map teacherinfor = new HashMap();
		try
		{
			conn=DBUtils.getConnection();
			if(zdkc==null||zdkc.equals(""))
			{
				sqlStr="select jsid,jsxm from m_teacher order by jsid";
			}else
			{
				sqlStr="select jsid,jsxm from m_teacher where jszdkc='"+zdkc+"'";
			}
			stmt=conn.prepareStatement(sqlStr);
			rs=stmt.executeQuery();
			while(rs.next())
			{
				teacherinfor.put(rs.getInt("jsid"),rs.getString("jsxm"));				
			}
		}catch(Exception e)
		{
			System.out.println("DWR："+e);
		}finally
		{
			DBUtils.closeResultSet(rs);
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
		}
		return teacherinfor;
	}

}