province.java

计算机技术的快速发展

package com.suninformation.tools;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.suninformation.database.DBManager;
import com.suninformation.user.UnacceptableException;

/**
 * 省份信息处理
 * 
 * @author 刘镇
 * @version 1.0
 */
public class Province {

	private static final String SEARCH_PROVINCE_BY_PROVID = "SELECT id,provname FROM province WHERE provid=?";

	private static final String SEARCH_PROVINCE_BY_PROVNAME = "SELECT id,provid FROM province WHERE provname=?";

	/**
	 * 通过省份ID，返回省份名称
	 * 
	 * @param provid
	 * @return
	 * @throws UnacceptableException
	 */
	public static String getProvName(int provid) throws UnacceptableException {
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String ProvName = "";
		try {
			conn = DBManager.getConnection();
			pstmt = conn.prepareStatement(SEARCH_PROVINCE_BY_PROVID);
			pstmt.setInt(1, provid);
			rs = pstmt.executeQuery();
			if (!rs.next()) {
				return "";
			}
			ProvName = rs.getString(2);
		} catch (SQLException sqle) {
			throw new UnacceptableException("读取省份数据失败。", sqle);
		} finally {
			DBManager.closeObject(conn, pstmt, rs);
		}
		return ProvName;
	}

	/**
	 * 通过省份名称，返回省份ID
	 * 
	 * @param provname
	 * @return
	 * @throws UnacceptableException
	 */
	public static int getProvId(String provname) throws UnacceptableException {
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		int ProvId = 0;
		try {
			conn = DBManager.getConnection();
			pstmt = conn.prepareStatement(SEARCH_PROVINCE_BY_PROVNAME);
			pstmt.setString(1, provname);
			rs = pstmt.executeQuery();
			if (!rs.next()) {
				return 0;
			}
			ProvId = rs.getInt(2);
		} catch (SQLException sqle) {
			throw new UnacceptableException("读取省份数据失败。", sqle);
		} finally {
			DBManager.closeObject(conn, pstmt, rs);
		}
		return ProvId;
	}

}