operatordaoimpl.java

是我自己在做java训练的时候做的一个小项目

package com.magic.mobile.dao.impl;

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

import com.magic.mobile.dao.OperatorDAO;
import com.magic.mobile.exception.PasswordNotMatchException;
import com.magic.mobile.exception.UserNotFoundException;
import com.magic.mobile.util.*;
import com.magic.mobile.vo.*;

public class OperatorDAOImpl implements OperatorDAO {

	public Operator validate(String operator_id, String operator_pwd)
			throws UserNotFoundException, PasswordNotMatchException {
		Connection conn = null;
		ResultSet rs = null;
		Operator o = null;
		String sql = "select * from toperator where operator_id='"
				+ operator_id + "'";
		try {
			conn = DBUtil.getConn();
			rs = DBUtil.getRs(conn, sql);
			if (!rs.next()) {
				throw new UserNotFoundException();
			} else if (!rs.getString("operator_pwd").equals(operator_pwd)) {
				throw new PasswordNotMatchException();
			} else {

				o = new Operator();
				o.setOperatorId(rs.getString(1));
			    o.setOperatorName(rs.getString(2));
				o.setOperatorPwd(rs.getString(3));
				o.setIsAdmin(rs.getString(4));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBUtil.closeRs(rs);
			DBUtil.closeConn(conn);
		}
		return o;
	}
}