operatordao.java

新东方软件开发项目

package com.mobile.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Iterator;

import com.mobile.bean.Operator;


public class OperatorDAO {
	
	
	public ArrayList SelectOperators(String id,String name)
	{
		Connection con=null;
		PreparedStatement pstmt=null;
		ArrayList operators=null;
		try {
			con = ConnectionMgr.getConnection();
			  String sql="select * from TOperator where 1=1";
	    	   if(name!=null && !name.trim().equals("")){
	    		   sql = sql + "and upper(Operator_Name) like '%"+name.toUpperCase()+"%'";
	    	   }
	    	   if(id!=null && !id.trim().equals("")){
	    		   sql = sql + " and upper(Operator_ID) like '%"+id.toUpperCase()+"%'";
	    	   }
			pstmt = con.prepareStatement(sql);
			operators = new ArrayList();
			
				ResultSet rs = pstmt.executeQuery();
				Operator operator = null;
			  int i=1;
				for (; rs.next(); operators.add(operator))
				{
					if(i>=6){
						break;
					}
					
					operator = new Operator();
					operator.setOperator_ID(rs.getString(1));
					operator.setOperator_Name(rs.getString(2));
					operator.setOperator_Pwd(rs.getString(3));
					operator.setIs_Admin(rs.getString(4));
					i++;	
					
		}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
			return operators;
	}
	
	
	
	
	
	
	
	
	public boolean editOperator(Operator operator)
	{
	
		PreparedStatement pstmt;
		boolean succ=false;
		Connection con=null;
		try {
			con = ConnectionMgr.getConnection();
			pstmt = con.prepareStatement("update TOperator set Operator_Name=?,Operator_Pwd=?,Is_Admin=? where Operator_ID=?");
			pstmt.setString(1, operator.getOperator_Name());
			pstmt.setString(2, operator.getOperator_Pwd());
			pstmt.setString(3, operator.getIs_Admin());
			pstmt.setString(4, operator.getOperator_ID());
			
		
		if (pstmt.executeUpdate() != 0)
			succ = true;
		 System.out.println("nnnnnnnnnnnnnnnnnnnnnnnnnn");
		

		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	return succ;
		
			
	
	}
	
	
	public boolean createOperator(Operator operator)
	{
		boolean succ;
		PreparedStatement pstmt=null;
		succ = false;
		Connection con=null;
		try {
			System.out.println(operator.getOperator_ID());
			System.out.println(operator.getOperator_Name());
			System.out.println(operator.getOperator_Pwd());
			System.out.println(operator.getIs_Admin());
			con = ConnectionMgr.getConnection();
			pstmt = con.prepareStatement("insert into TOperator values(?,?,?,?)");
			pstmt.setString(1, operator.getOperator_ID());
			pstmt.setString(2, operator.getOperator_Name());
			pstmt.setString(3, operator.getOperator_Pwd());
			pstmt.setString(4, operator.getIs_Admin());
			 System.out.println("nnnnnnnnnnnnnnnnnnnsssssssssssssssssssnnnnnnn");
			if (pstmt.executeUpdate() != 0)
				succ = true;
			 System.out.println("nnnnnnnnnnnnnnnnnnnnnnnnnn");
			
	
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return succ;
		
	}
	
	public boolean deleteOperator(String[] ss)
	{
		boolean succ;
		PreparedStatement pstmt=null;
		succ = false;
		Connection con=null;
		try {
			
			con = ConnectionMgr.getConnection();
			String ids="";
			
			for(int i = 0;i<ss.length;i++){
				ids=ids+",'"+ss[i]+"'";
				System.out.println(ids);
			}
			ids=ids.substring(2,ids.length());
			System.out.println(ids);
			String sql="delete from TOperator where Operator_ID in ('"+ ids+ ")";
			pstmt = con.prepareStatement(sql);
			System.out.println(sql);
		
			 System.out.println("nnnnnnnnnnnnnnnnnnnsssssssssssssssssssnnnnnnn");
			if (pstmt.executeUpdate() != 0)
				succ = true;
			 System.out.println("nnnnnnnnnnnnnnnnnnnnnnnnnn");
			
	
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return succ;
		
	}

	
	

	public ArrayList getAllOperators(int start,int end)
	{
		Connection con=null;
		PreparedStatement pstmt=null;
		ArrayList operators=null;
		try {
			con = ConnectionMgr.getConnection();
			
			pstmt = con.prepareStatement("select * from TOperator");
			operators = new ArrayList();
			
				ResultSet rs = pstmt.executeQuery();
				Operator operator = null;
				int i=start;
				for (; rs.next(); operators.add(operator))
				{
					if(i>=end){
						break;
					}
					System.out.println(rs.getString(1));
					System.out.println("bbbbbbbbbbbbbbb");
					operator = new Operator();
					operator.setOperator_ID(rs.getString(1));
					operator.setOperator_Name(rs.getString(2));
					operator.setOperator_Pwd(rs.getString(3));
					operator.setIs_Admin(rs.getString(4));
					i++;	
					
		}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
			return operators;
	}
	
	public Operator getOperators(String operater_id)
	{
		Connection con=null;
		PreparedStatement pstmt=null;
		//boolean fag=true;
	    Operator fag=null;
		try {
			con = ConnectionMgr.getConnection();
			
			pstmt = con.prepareStatement("select * from TOperator where Operator_ID= '"+operater_id+"'");
			
			
				ResultSet rs = pstmt.executeQuery();
				
			while(rs.next())
				{
				   fag=new Operator();
				   fag.setOperator_ID(rs.getString(1));
                    System.out.println(fag.getOperator_ID()+"------------------------");
				   fag.setOperator_Name(rs.getString(2)); 
				   fag.setOperator_Pwd(rs.getString(3));
				   fag.setIs_Admin(rs.getString(4));
				   
						
		}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
			return fag;
	}
	
	public int findCount(){
		Connection con = null;
		Statement st = null;
		ResultSet rs = null;
		int count = 0;
		try{
			con = ConnectionMgr.getConnection();
			st = con.createStatement();
			
			rs = st.executeQuery("select COUNT(*) from TOperator");
			
			if(rs.next()){
				count = rs.getInt(1);
			}
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			ConnectionMgr.closeResource(con, st, rs);
		}
		return count;
	}
	
}