ldapmanager.java

应用系统的权限管理

package com.gmdq.user;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.http.HttpServletRequest;

import com.gmdq.connection.SybaseConn;
import com.gmdq.ldapuser.LdapTest;

public class LdapManager {
	private Connection conn;
	private SybaseConn sysbase;
	private HttpServletRequest request;
	public LdapManager()
	{
	    sysbase=new SybaseConn();
		conn=sysbase.getConnection();
		
	}
	public LdapManager(HttpServletRequest request)
	{
		this.request=request;
	    sysbase=new SybaseConn();
		conn=sysbase.getConnection();
		
	}
	public void ldap(String searchDn)
	{
		LdapTest test = new LdapTest();
		//String searchDn = "OU=国美集团,DC=gome,DC=inc";
		String ouFilter = "(objectClass=organizationalUnit)";
		String userFilter = "(&(objectClass=user)(!(objectClass=computer)))";
		List<String> all = test.getUser(searchDn, ouFilter, userFilter);
		String[] strArr=null;
		PreparedStatement stmt;
		try {
			stmt = conn.prepareStatement("INSERT INTO aduser(username,displayname,deptname) VALUES(?,?,?)" );
			for(String str:all)
			{
				
				System.out.println("&&&&&555555"+str);
				strArr=str.split("[*]");
				
				System.out.println("&&^^^^^^"+strArr[1]);
				stmt.setString(1,strArr[0]);
				stmt.setString(2, strArr[1]);
				if(strArr.length>=3)
				{
					stmt.setString(3, strArr[2]);
				}else
				{
					stmt.setString(3, "");
				}
				
				stmt.addBatch( );

			{
			
			}
			try{
				int[ ] counts = stmt.executeBatch();
			}catch (SQLException e) {
				System.out.println("试图插入同名用户");
			}
			
		} }catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally
		{
			sysbase.closeConn(conn);
		}
		
		
	}
	public void insertUserByHand(HttpServletRequest request)
	{
		
		String[] pid_batch=request.getParameterValues("pid_batch");
		String[] strArr=null;
		PreparedStatement stmt;
		try {
			stmt = conn.prepareStatement("INSERT INTO aduser(username,displayname,deptname,statu) VALUES(?,?,?,?)" );
			for(String str:pid_batch)
			{
				
				
				strArr=str.split("[*]");
				
				System.out.println("&&^^^^^^"+strArr[1]);
				stmt.setString(1,strArr[0]);
				stmt.setString(2, strArr[1]);
				if(strArr.length>=3)
				{
					stmt.setString(3, strArr[2]);
				}else
				{
					stmt.setString(3, "");
				}
				stmt.setInt(4,0);
				stmt.addBatch( );

			{
			
			}
			try{
				int[ ] counts = stmt.executeBatch();
			}catch (SQLException e) {
				System.out.println("试图插入同名用户");
			}
			
		} }catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally
		{
			sysbase.closeConn(conn);
		}
		
	}

}