mysql db路由

DBRouteConfig路由方法

    /**
     * �������ݿ�·�ɵ�����ڣ�һ��ͻ��˾����ô˷�������Ӧ�ò�ѯ�����ݿ⡣
     *
     * @param dbRoute
     * @param statement
     *
     * @return
     *
     * @throws DBRouterException
     */
    public List routingDB(DBRoute dbRoute, String statement)
            throws DBRouterException {
        List nodeNameListByNodeRule = routingDB(dbRoute);

        if ((nodeNameListByNodeRule != null) && !nodeNameListByNodeRule.isEmpty()) {
            return nodeNameListByNodeRule;
        }

        List nodeNameListByStatementRule = routingDB(statement);

        if (nodeNameListByStatementRule != null) {
            return nodeNameListByStatementRule;
        }

        return defaultNodeNameList;
    }

xml配置

<bean id="dbRouteConfig" name="dbRouteConfig" class="com.taobao.common.dao.persistence.DBRouteConfig"
		init-method="init" scope="singleton">
		<property name="allNodeNameList">
			<list>
				<value>ifdmysql</value>
				<value>aucdueMysql</value><!--Add by qingyuan.ygw -->
				<value>cmpMysql</value>
				<value>cmp</value>
				<value>mysqlsnap</value>
				<value>itemProcessMySql</value>
				<value>icmysqlsnap</value>
			</list>
		</property>
		<property name="defaultNodeNameList">
			<list>
				<value>ifdmysql</value>
				<value>aucdueMysql</value><!--Add by qingyuan.ygw -->
				<value>cmpMysql</value>
				<value>cmp</value>
				<value>itemProcessMySql</value>
				<value>icmysqlsnap</value>
			</list>
		</property>
		<property name="dbRuleMap">
			<map>
			</map>
		</property>
		<property name="configLocation">
			<value>classpath:common/sqlmap/sql-route.xml</value>
		</property>

	</bean>