oracleoperatordao.java

ｊｓｐ／ｓｅｒｖｌｅｔ中国移动模拟收费系统

package dao;

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

import javabean.Operator;

public class OracleOperatorDAO implements OperatorDAO {
	private final String GET_AN_OPERATOR = "select * from toperator where operator_id=?";
	private final String INSERT_AN_OPERATOR = "insert into toperator values(?,?,?,?)";
	
	public int isExists(Operator operator){
		Connection conn = null;
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		int tmp = 0;
		try{
		conn = OracleDAOFactory.getConnection();
		pstmt = conn.prepareStatement(GET_AN_OPERATOR);
		pstmt.setString(1, operator.getOperatorId());
		rs = pstmt.executeQuery();
		if(rs.next()){
			System.out.println("operator.getOperatorPwd()   :"+operator.getOperatorPwd());
			System.out.println("rs.getString(3)   :"+rs.getString(3));
			System.out.println("rs.getString(4)   :"+rs.getString(4));
			if((operator.getOperatorPwd()).equals(rs.getString(3))){
				if((rs.getString(4)).equals("Y")){
					tmp = 1;
				}else if((rs.getString(4)).equals("N")){
					tmp = 2;	
				}			
			}else tmp = 3;
		}
		}catch(SQLException e){
			tmp = 9;
		}finally{
			OracleDAOFactory.closeResultSet(rs);
			OracleDAOFactory.closeStatement(pstmt);
			OracleDAOFactory.closeConnection(conn);
		}
		return tmp;
	}
	
	public boolean createOperator(Operator operator){
		Connection conn = null;
		PreparedStatement pstmt = null;
		boolean tmp = true;
		try{
			conn = OracleDAOFactory.getConnection();
			pstmt = conn.prepareStatement(INSERT_AN_OPERATOR);
			pstmt.setString(1, operator.getOperatorId());
			pstmt.setString(2, operator.getOperatorName());
			pstmt.setString(3, operator.getOperatorPwd());
			pstmt.setString(4, operator.getIsAdmin());
			int result = pstmt.executeUpdate();
			if(result!=1){
				tmp = false;
			}
		}catch(SQLException e){
			e.printStackTrace();
			tmp = false;
		}finally{
			OracleDAOFactory.closeStatement(pstmt);
			OracleDAOFactory.closeConnection(conn);
		}
		return tmp;
	}
}