老翟

beans<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-2.5.xsd
           http://www.springframework.org/schema/aop
           http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
           http://www.springframework.org/schema/tx 
           http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
	<context:annotation-config />
	<context:component-scan base-package="cc.rm" />
	<bean
		class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<value>classpath:jdbc.properties</value>
		</property>
	</bean>

	<bean id="dataSource" destroy-method="close"
		class="org.apache.commons.dbcp.BasicDataSource">
		<property name="driverClassName"
			value="${jdbc.driverClassName}" />
		<property name="url" value="${jdbc.url}" />
		<property name="username" value="${jdbc.username}" />
		<property name="password" value="${jdbc.password}" />
	</bean>

	<!--DataSource -->
	<bean id="sf"
		class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		 <property name="packagesToScan">
			<list>
				<value>cc.rm.vo</value>
				
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					org.hibernate.dialect.MySQLDialect
				</prop>
				<prop key="hibernate.show_sql">true</prop>
			</props>
		</property>
	</bean>
	
	<bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
		<property name="sessionFactory" ref="sf"></property>
	</bean>
	
	<bean id="txManager"
		class="org.springframework.orm.hibernate3.HibernateTransactionManager">
		<property name="sessionFactory" ref="sf" />
	</bean>

	<aop:config>
		<aop:pointcut id="bussinessService"
			expression="execution(public * cc.rm.*.*(..))" />
		<aop:advisor pointcut-ref="bussinessService"
			advice-ref="txAdvice" />
	</aop:config>

	<tx:advice id="txAdvice" transaction-manager="txManager">
		<tx:attributes>
			<tx:method name="*" propagation="REQUIRED"/>
		</tx:attributes>
	</tx:advice>
	
</beans>

propertiesjdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/ll
jdbc.username=root
jdbc.password=1244

web.xml<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>WEB-INF/:beans.xml,</param-value>
</context-param>

<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

interfacepackage List;

public interface IList {
	boolean isEmpty();
	int size();
	void add(ZNode newNode);
	void insert(int index , ZNode newNode) throws Exception;
	void delete(int index) throws Exception ;
	void replace(int index,Object obj) throws Exception;
	ZNode getByIndx(int index) throws Exception;
	int getIndex(ZNode node) throws Exception;
	void display() throws Exception;
}

implementpackage List;

public class ZList implements IList {

	private ZNode head = null;
	
	public ZList(){
		
	}
	
	@SuppressWarnings("null")
	@Override
	public void add(ZNode newNode) {
		// TODO Auto-generated method stub
		ZNode z = head ;
		if(!isEmpty()){
			while(z.getNext()!=null){
				z = z.getNext();
			}
			z.setNext(newNode);
		}else{
			head = newNode ;
		}
		
	}

	@Override
	public void insert(int index, ZNode newNode) throws Exception {
		// TODO Auto-generated method stub
		ZNode frontNode = getByIndx(index-1) ;
		ZNode afterNode = getByIndx(index);
		frontNode.setNext(newNode);
		newNode.setNext(afterNode);
		
	}

	@Override
	public void delete(int index) throws Exception {
		// TODO Auto-generated method stub
		ZNode frontNode = getByIndx(index-1) ;
		ZNode currentNode = getByIndx(index) ;
		ZNode afterNode = currentNode.getNext() ;
		
		frontNode.setNext(afterNode) ;
		currentNode = null ;
		
	}

	@Override
	public void replace(int index,Object obj) throws Exception {
		// TODO Auto-generated method stub
		ZNode current = getByIndx(index);
		current.setData(obj);
	}

	/**
	 * index >= 0
	 */
	@Override
	public ZNode getByIndx(int index) throws Exception {
		// TODO Auto-generated method stub
		if(isEmpty()) throw new Exception("The List is null!");
		ZNode z = head ;
		while(index>0 ){
			if(z==null) throw new Exception("the index is out of index");
			z = z.getNext();
			index--;
		}
		
		return z;
	}

	@Override
	public int getIndex(ZNode node) throws Exception {
		// TODO Auto-generated method stub
		if(isEmpty()) throw new Exception("The List is null!");
		ZNode z = head ;
		
		int index = 0 ;
		
		do{
			if(z.equals(node)) break; 
			index ++ ;
			z = z.getNext();
		}while(z!=null);
		
		return index;
	}

	@Override
	public boolean isEmpty() {
		// TODO Auto-generated method stub
		return (null == this.head) ? true:false;
	}

	@Override
	public int size() {
		// TODO Auto-generated method stub
		ZNode z = head;
		int sz = 0;
		if(null != z) {
			do{
				sz++;
			}while((z = z.getNext())!=null);
		}
		return sz;
	}

	@Override
	public void display() throws Exception {
		// TODO Auto-generated method stub
		if(isEmpty()) throw new Exception("The List is null!");
		
		ZNode z = head ;
		int index = 0 ;
		do{
			System.out
					.println("index:" + index + " " + z.getData().toString());
			index++ ;
			z = z.getNext() ;
		}while(z!= null) ;
	}
	
}

nodepackage List;

public class ZNode {
	private Object data ;
	private ZNode next ;
	
	public ZNode(Object data, ZNode next) {
		super();
		this.data = data;
		this.next = next;
	}
	public ZNode() {
		this.data = null ;
		this.next = null ;
	}
	public Object getData() {
		return data;
	}
	public void setData(Object data) {
		this.data = data;
	}
	public ZNode getNext() {
		return next;
	}
	public void setNext(ZNode next) {
		this.next = next;
	}
	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + ((data == null) ? 0 : data.hashCode());
		return result;
	}
	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		ZNode other = (ZNode) obj;
		if (data == null) {
			if (other.data != null)
				return false;
		} else if (!data.equals(other.data))
			return false;
		return true;
	}
	@Override
	public String toString() {
		// TODO Auto-generated method stub
		return "data are : " + data.toString() ;
	}
	
}

html<table id="editableTable" border="0" cellspacing="0" cellpadding="0">
	<thead>
		<tr>
			<th name="ID">ID</th>
			<th name="first">First Name</th>
			<th name="last">Last Name</th>
			<th>Phone</th>
			<th name="city">City</th>
			<th name="email">Email</th>
		</tr>
		<tr>
			<td><key>233</key> <button class="eventLink">edit</button></td>
			<td><input type="text" name="XXXX" val="YYYY"></input></td>
			<td>XXX</td>
			<td><input type="checkbox" checked name="zzTop"></input></td>
			<td><input type="checkbox" name="yyy"></input></td>
			<td><select name="yyy"><option>XXX</option><option SELECTED>YYY</option></select></td>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td><key>1</key> <button class="eventLink">edit</button></td>
			<td>Brice</td>
			<td>Burgess</td>
			<td>(800)768-5283</td>
			<td>Milwaukee</td>
			<td>b@b.com</td>
		</tr>
		<tr>
			<td><key>2</key> <button class="eventLink">edit</button></td>
			<td>Christian</td>
			<td>Bach</td>
			<td>(800)768-6288</td>
			<td>Chicago</td>
			<td>c@c.com</td>
		</tr>
		<tr>
			<td><key>3</key> <button class="eventLink">edit</button></td>
			<td>Abe</td>
			<td>Lincoln</td>
			<td>(800)223-2331</td>
			<td>Washington D.C.</td>
			<td>l@l.com</td>
		</tr>
		<tr>
			<td><key>8</key> <button class="eventLink">edit</button></td>
			<td>Sam Lightning</td>
			<td>Hopkings</td>
			<td>(800)728-1221</td>
			<td>Houston</td>
			<td>s@s.com</td>
		</tr>
		<tr>
			<td><key>15</key> <button class="eventLink">edit</button></td>
			<td>Rudyard</td>
			<td>Kipling</td>
			<td>(512)121-1280</td>
			<td>London</td>
			<td>r@r.com</td>
		</tr>
	</tbody>
</table>

js<script type="text/javascript">
$().ready(function() {	
	$("#editableTable").tableSorter({ 
		sortClassAsc: 'headerSortUp', 		// class name for ascending sorting action to header
		sortClassDesc: 'headerSortDown',	// class name for descending sorting action to header
		headerClass: 'header', 				// class name for headers (th's)
		disableHeader: 'ID' 	// DISABLE Sorting on ID
	}).tableEditor({
		EDIT_HTML: 'edit',
		SAVE_HTML: 'save',
		EVENT_LINK_SELECTOR: 'button.eventLink',
		FUNC_UPDATE: 'updateTable'
	});
	
	document.counter = 0;
});

function updateTable(o) {
	document.counter++;
	
	if ((document.counter%2) == 0) {
		// restore row
		alert('Update failed. Row restore.');
		$.tableEditor.lib.restoreRow(o.row,o.original);
	}
	else
		alert('Update Success');
		
	return true;
}
</script>

java/*
 *  RequestUtils.java
 *  
 *  This program is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 2 of the License, or
 *  (at your option) any later version.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU Library General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 *  
 *  Author: Winter Lau (javayou@gmail.com)
 *  http://dlog4j.sourceforge.net
 */
package com.liusoft.dlog4j.util;

import java.io.IOException;
import java.io.InputStream;
import java.io.PrintStream;
import java.text.MessageFormat;
import java.util.Enumeration;
import java.util.Iterator;
import java.util.Properties;

import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.liusoft.dlog4j.Globals;

/**
 * 用于Request的工具类
 * @author Winter Lau
 */
public class RequestUtils extends org.apache.struts.util.RequestUtils{

	final static Log log = LogFactory.getLog(RequestUtils.class);
	
	private static Properties header_map;
	private static String default_mobile; 
	static{
		InputStream in = RequestUtils.class.getResourceAsStream("/com/liusoft/dlog4j/util/mobile_match.properties");
		header_map = new Properties();
		try{
			header_map.load(in);
			default_mobile = header_map.getProperty("empty");
		}catch(IOException e){
			log.error("加载手机号码匹配策略文件/mobile_match.conf失败",e);
		}
	}

	public static boolean isMultipart(HttpServletRequest req) {
		return ((req.getContentType() != null) && (req.getContentType()
				.toLowerCase().startsWith("multipart")));
	}

	/**
	 * 获取FCKUpload过程中生成的会话ID
	 * @return
	 */
	public static String getDlogSessionId(HttpServletRequest req){
		//优先从Cookie中获取ssn_id值
		String ssn_id = null;
		Cookie cok = RequestUtils.getCookie(req, Globals.SESSION_ID_KEY_IN_COOKIE);
		if(cok != null){
			ssn_id = cok.getValue();
		}
		if(StringUtils.isEmpty(ssn_id)){
			//如果Cookie得不到则从服务器的会话中读取
			HttpSession ssn = req.getSession(false);
			if (ssn != null)
				ssn_id = ssn.getId();
		}
		return ssn_id;
	}
	
	/**
	 * 清除FCKUpload过程中生成的Cookie
	 * @param req
	 * @param res
	 */
	public static void clearDlogSessionId(HttpServletRequest req, HttpServletResponse res){
		Cookie cok = RequestUtils.getCookie(req, Globals.SESSION_ID_KEY_IN_COOKIE);
		if(cok != null){
			cok.setMaxAge(0);
			res.addCookie(cok);
		}
	}
	
	/**
	 * 获取COOKIE
	 * 
	 * @param name
	 */
	public static Cookie getCookie(HttpServletRequest request, String name) {
		Cookie[] cookies = request.getCookies();
		if(cookies == null)
			return null;
		for (int i = 0; i < cookies.length; i++) {
			if (name.equals(cookies[i].getName())) {
				return cookies[i];
			}
		}
		return null;
	}

	/**
	 * 设置COOKIE
	 * 
	 * @param name
	 * @param value
	 * @param maxAge
	 */
	public static void setCookie(HttpServletRequest request, HttpServletResponse response, String name,
			String value, int maxAge) {
		Cookie cookie = new Cookie(name, value);
		cookie.setMaxAge(maxAge);
		String serverName = request.getServerName();
		String domain = getDomainOfServerName(serverName);
		if(domain!=null && domain.indexOf('.')!=-1){
			cookie.setDomain('.' + domain);
		}
		cookie.setPath("/");
		response.addCookie(cookie);
	}
	
	/**
	 * 获取用户访问URL中的根域名
	 * 例如: www.dlog.cn -> dlog.cn
	 * @param req
	 * @return
	 */
	public static String getDomainOfServerName(String host){
		if(StringUtils.isIPAddr(host))
			return null;
		String[] names = StringUtils.split(host, '.');
		int len = names.length;
		if(len>=2)
			return names[len-2]+'.'+names[len-1];
		return host;
	}
	
	public static void main(String[] args){
		String host = "127.0.0.1";
		System.out.println("DOMAIN: " + getDomainOfServerName(host));		
		host = "dlog.cn";
		System.out.println("DOMAIN: " + getDomainOfServerName(host));		
		host = "abc.mail.dlog.cn";
		System.out.println("DOMAIN: " + getDomainOfServerName(host));		
	}

	/**
	 * 从URL地址中解析出URL前缀，例如
	 * http://wap.mo168.com:8081/index.jsp -> http://wap.mo168.com:8081
	 * @param req
	 * @return
	 */
	public static String getUrlPrefix(HttpServletRequest req){
		StringBuffer url = new StringBuffer(req.getScheme());
		url.append("://");
		url.append(req.getServerName());
		int port = req.getServerPort();
		if(port!=80){
			url.append(":");
			url.append(port);
		}
		return url.toString();
	}
	
	/**
	 * 获取访问的URL全路径
	 * @param req
	 * @return
	 */
	public static String getRequestURL(HttpServletRequest req){
		StringBuffer url = new StringBuffer(req.getRequestURI());
		String param = req.getQueryString();
		if(param!=null){
			url.append('?');
			url.append(param);
		}
		String path = url.toString();
		return path.substring(req.getContextPath().length());
	}

	
	/**
	 * 打印所有的头信息
	 * @param out
	 * @param req
	 */
	public static void dumpHeaders(PrintStream out, HttpServletRequest req){
		Enumeration names = req.getHeaderNames();
		while(names.hasMoreElements()){
			String name = (String)names.nextElement();
			out.println(name+"="+req.getHeader(name));
		}
	}
	/**
	 * 从请求中解析手机号码
	 * @param req
	 * @return
	 */
	public static String getRequestMobile(HttpServletRequest req){
		String mobile = default_mobile;
		Iterator keys = header_map.keySet().iterator();
		while(keys.hasNext()){
			String header = (String)keys.next();
			String value = getHeader(req,header);
			if(value!=null){
				String pattern = (String)header_map.get(header);
				MessageFormat mf = new MessageFormat(pattern);
				try{
					Object[] vs = mf.parse(value);
					mobile = (String)vs[0];
					if(mobile.startsWith("86"))
						mobile = mobile.substring(2);
					break;
				}catch(Exception e){
					log.warn("解析header失败",e);
					dumpHeaders(req, System.err);
					continue;
				}
			}
		}
		return mobile;
	}
	
	/**
	 * 获取header信息，名字大小写无关
	 * @param req
	 * @param name
	 * @return
	 */
	public static String getHeader(HttpServletRequest req, String name){
		String value = req.getHeader(name);
		if(value!=null)
			return value;
		Enumeration names = req.getHeaderNames();
		while(names.hasMoreElements()){
			String n = (String)names.nextElement();
			if(n.equalsIgnoreCase(name)){
				return req.getHeader(n);
			}
		}
		return null;
	}
	
	/**
	 * 打印所有头信息
	 * @param req
	 * @param out
	 */
	public static void dumpHeaders(HttpServletRequest req, PrintStream out){
		Enumeration hds = req.getHeaderNames();
		out.println("=============== HEADERS ===============");
		while(hds.hasMoreElements()){
			String name = (String)hds.nextElement();
			out.println(name+"="+req.getHeader(name));
		}
	}

	/**
	 * 判断手机是否支持某种类型的格式
	 * @param req
	 * @param contentType
	 * @return
	 */
	public static boolean support(HttpServletRequest req, String contentType){
		String accept = getHeader(req, "accept");
		if(accept!=null){
			accept = accept.toLowerCase();
			return accept.indexOf(contentType.toLowerCase())!=-1;
		}
		return false;
	}
	
	/**
	 * 判断浏览器是否与Mozilla兼容
	 * @param req
	 * @return
	 */
	public static boolean isMozillaCompatible(HttpServletRequest req){
		String user_agent = req.getHeader("user-agent");
		return user_agent==null || user_agent.indexOf("Mozilla")!=-1;
	}

	/**
	 * 获取浏览器提交的整形参数
	 * @param param
	 * @param defaultValue
	 * @return
	 */
	public static int getParam(HttpServletRequest req, String param, int defaultValue){
		try{
			String value = req.getParameter(param);
			int idx = value.indexOf('#');
			if(idx!=-1)
				value = value.substring(0,idx);
			return Integer.parseInt(value);
		}catch(Exception e){}
		return defaultValue;
	}
	/**
	 * 获取浏览器提交的字符串参数
	 * @param param
	 * @param defaultValue
	 * @return
	 */
	public static String getParam(HttpServletRequest req, String param, String defaultValue){
		String value = req.getParameter(param);
		return (StringUtils.isEmpty(value))?defaultValue:value;
	}

}

java/*
 *  SiteAction.java
 *  
 *  This program is free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 2 of the License, or
 *  (at your option) any later version.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU Library General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program; if not, write to the Free Software
 *  Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 *  
 *  Author: Winter Lau
 *  http://dlog4j.sourceforge.net
 */
package com.liusoft.dlog4j;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletContext;

import org.apache.commons.lang.StringUtils;

/**
 * DLOG在安全方面的一些处理方法 
 * 敏感词汇表：/WEB-INF/conf/illegal_glossary.dat
 * 
 * @author Winter Lau
 */
public class DLOGSecurityManager {

	/**
	 * 初始化
	 * @param sc
	 * @throws IOException
	 * 
	 * @see com.liusoft.dlog4j.servlet.DLOG_ActionServlet#init()
	 */
	public static void init(ServletContext sc) throws IOException {
		IllegalGlossary.init(sc);
	}
	
	public static void destroy(){
		IllegalGlossary.destroy();
	}
	
	/**
	 * 敏感字汇
	 * @author Winter Lau
	 */
	public static class IllegalGlossary {

		private final static String file_glossary = "/WEB-INF/conf/illegal_glossary.dat";
		
		private static List glossary = null;
		
		public static void init(ServletContext sc) throws IOException {
			glossary = new ArrayList(1000);
			if(sc!=null)
				loadIllegalGlossary(sc);
		}

		public static void destroy(){
			if(glossary!=null)
				glossary.clear();
		}
		
		/**
		 * 加载敏感词汇表
		 * @param sc
		 * @throws IOException 
		 */
		private synchronized static void loadIllegalGlossary(ServletContext sc) throws IOException {
			InputStream in = sc.getResourceAsStream(file_glossary);
			BufferedReader reader = null;
			try{
				reader = new BufferedReader(new InputStreamReader(in));
				do{
					String line = reader.readLine();
					if(line==null)
						break;
					glossary.add(line.trim());
				}while(true);
			}finally{
				in.close();
			}
		}

		/**
		 * 自动将敏感词汇用XXX替换
		 * 
		 * @param content
		 * @return
		 */
		public static String autoGlossaryFiltrate(String content) {
			if(StringUtils.isEmpty(content))
				return content;
			for (int i = 0; i < glossary.size(); i++) {
				String word = (String)glossary.get(i);
				content = StringUtils.replace(content, word, StringUtils
						.repeat("X", word.length()));
			}
			return content;
		}
		
		/**
		 * 判断是否存在非法内容
		 * @param content
		 * @return
		 */
		public static boolean existIllegalWord(String content){
			if(StringUtils.isEmpty(content))
				return false;
			for (int i = 0; i < glossary.size(); i++) {
				String word = (String) glossary.get(i);
				if(content.indexOf(word)>=0)
					return true;
			}
			return false;
		}
		
		/**
		 * 删除内容中存在的关键字
		 * @param content
		 * @return
		 */
		public static String deleteIllegalWord(String content){
			if(StringUtils.isEmpty(content))
				return content;
			for (int i = 0; i < glossary.size(); i++) {
				String word = (String) glossary.get(i);
				content = StringUtils.remove(content, word);
			}
			return content;
		}
		
	}

	public static void main(String[] args) throws IOException{
		init(null);
		String text = "中华人民共和国国家主席毛泽东，我们叫他毛主席";
		System.out.println(IllegalGlossary.autoGlossaryFiltrate(text));
	}
}

sqlDROP DATABASE IF EXISTS `local` ; 

CREATE DATABASE `local`; 

use `local` ; 

DROP TABLE IF EXISTS actionmanager; 

CREATE TABLE actionmanager(
    actionid INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
    actionName VARCHAR(255) NOT NULL ,
    action VARCHAR(255) NOT NULL,
    createDate DATE,
    viewmode INT DEFAULT 0
    #index inx(`action`)
)type=InnoDB; 

DROP TABLE IF EXISTS actioncolumn ; 

CREATE TABLE actioncolumn(
    actioncolumnid INT AUTO_INCREMENT NOT NULL PRIMARY KEY ,
    actioncolumnname VARCHAR(255) NOT NULL
)type=InnoDB; 

DROP TABLE IF EXISTS groupmanager; 

CREATE TABLE groupmanager(
    groupid INT AUTO_INCREMENT NOT NULL PRIMARY KEY ,
    groupname VARCHAR(255) NOT NULL,
    groupinfo VARCHAR(255) DEFAULT NULL,
    masterid INT NOT NULL,    #who created this group
    mastername VARCHAR(255),
    createdate DATE 
)type=InnoDB; 

DROP TABLE IF EXISTS master; 

CREATE TABLE master(
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL ,
    password VARCHAR(255) NOT NULL ,
    sex VARCHAR(255) NOT NULL ,
    position VARCHAR(255) NOT NULL,
    masterid INT ,             #whoe created this master    
    mastername VARCHAR(255),
    createdate DATE
)type=InnoDB; 

DROP TABLE IF EXISTS  actiongroup ; 

CREATE TABLE actiongroup(
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    `action` VARCHAR(255) NOT NULL, 
    groupid INT NOT NULL ,
    masterid int NOT NULL,
    mastername VARCHAR(255) NOT NULL ,
    createdate DATE,
    index inx_ag(`action`)
)type=InnoDB; 

DROP TABLE IF EXISTS mastergroup ; 

CREATE TABLE mastergroup(
    id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    masterid INT NOT NULL ,
    groupid INT NOT NULL ,
    masterid2 INT NOT NULL ,  # who created or modified this mastergroup 
    creatDate DATE 
)type=InnoDB ; 

##############action link group ###################### 

CREATE INDEX idx_actionmanager_action ON actionmanager(`action`); 
CREATE INDEX idx_groupmanager_groupid ON groupmanager(`groupid`); 

ALTER TABLE actiongroup 
ADD CONSTRAINT  fk_action
FOREIGN KEY (action) REFERENCES actionmanager(`action`) 
ON DELETE CASCADE ON UPDATE CASCADE; 

ALTER TABLE actiongroup 
ADD CONSTRAINT  fk_groupid
FOREIGN KEY (groupid) REFERENCES groupmanager(`groupid`) 
ON DELETE CASCADE ON UPDATE CASCADE; 

##############action link  master###################### 

CREATE INDEX idx_master_id ON master(`id`); 

ALTER TABLE mastergroup 
ADD CONSTRAINT  fk_masterg_mid
FOREIGN KEY (masterid) REFERENCES master(`id`) 
ON DELETE CASCADE ON UPDATE CASCADE; 

ALTER TABLE mastergroup 
ADD CONSTRAINT  fk_masterg_gid
FOREIGN KEY (groupid) REFERENCES groupmanager(`groupid`) 
ON DELETE CASCADE ON UPDATE CASCADE; 

web.xml// Import required java libraries
import java.io.*;
import java.util.*;
 
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
 
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUploadException;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.apache.commons.io.output.*;

public class UploadServlet extends HttpServlet {
   
   private boolean isMultipart;
   private String filePath;
   private int maxFileSize = 50 * 1024;
   private int maxMemSize = 4 * 1024;
   private File file ;

   public void init( ){
      // Get the file location where it would be stored.
      filePath = 
             getServletContext().getInitParameter("file-upload"); 
   }
   public void doPost(HttpServletRequest request, 
               HttpServletResponse response)
              throws ServletException, java.io.IOException {
      // Check that we have a file upload request
      isMultipart = ServletFileUpload.isMultipartContent(request);
      response.setContentType("text/html");
      java.io.PrintWriter out = response.getWriter( );
      if( !isMultipart ){
         out.println("<html>");
         out.println("<head>");
         out.println("<title>Servlet upload</title>");  
         out.println("</head>");
         out.println("<body>");
         out.println("<p>No file uploaded</p>"); 
         out.println("</body>");
         out.println("</html>");
         return;
      }
      DiskFileItemFactory factory = new DiskFileItemFactory();
      // maximum size that will be stored in memory
      factory.setSizeThreshold(maxMemSize);
      // Location to save data that is larger than maxMemSize.
      factory.setRepository(new File("c:\\temp"));

      // Create a new file upload handler
      ServletFileUpload upload = new ServletFileUpload(factory);
      // maximum file size to be uploaded.
      upload.setSizeMax( maxFileSize );

      try{ 
      // Parse the request to get file items.
      List fileItems = upload.parseRequest(request);
	
      // Process the uploaded file items
      Iterator i = fileItems.iterator();

      out.println("<html>");
      out.println("<head>");
      out.println("<title>Servlet upload</title>");  
      out.println("</head>");
      out.println("<body>");
      while ( i.hasNext () ) 
      {
         FileItem fi = (FileItem)i.next();
         if ( !fi.isFormField () )	
         {
            // Get the uploaded file parameters
            String fieldName = fi.getFieldName();
            String fileName = fi.getName();
            String contentType = fi.getContentType();
            boolean isInMemory = fi.isInMemory();
            long sizeInBytes = fi.getSize();
            // Write the file
            if( fileName.lastIndexOf("\\") >= 0 ){
               file = new File( filePath + 
               fileName.substring( fileName.lastIndexOf("\\"))) ;
            }else{
               file = new File( filePath + 
               fileName.substring(fileName.lastIndexOf("\\")+1)) ;
            }
            fi.write( file ) ;
            out.println("Uploaded Filename: " + fileName + "<br>");
         }
      }
      out.println("</body>");
      out.println("</html>");
   }catch(Exception ex) {
       System.out.println(ex);
   }
   }
   public void doGet(HttpServletRequest request, 
                       HttpServletResponse response)
        throws ServletException, java.io.IOException {
        
        throw new ServletException("GET method used with " +
                getClass( ).getName( )+": POST method required.");
   } 
}

web.xml<web-app>
....
<context-param> 
    <description>Location to store uploaded file</description> 
    <param-name>file-upload</param-name> 
    <param-value>
         c:\apache-tomcat-5.5.29\webapps\data\
     </param-value> 
</context-param>
....
</web-app>

web.xml<servlet>
   <servlet-name>UploadServlet</servlet-name>
   <servlet-class>UploadServlet</servlet-class>
</servlet>

<servlet-mapping>
   <servlet-name>UploadServlet</servlet-name>
   <url-pattern>/UploadServlet</url-pattern>
</servlet-mapping>

serpublic class Test implements Serializable {

	private static final long serialVersionUID = 1L;

	public static int staticVar = 5;

	public static void main(String[] args) {
		try {
			//初始时staticVar为5
			ObjectOutputStream out = new ObjectOutputStream(
					new FileOutputStream("result.obj"));
			out.writeObject(new Test());
			out.close();

			//序列化后修改为10
			Test.staticVar = 10;

			ObjectInputStream oin = new ObjectInputStream(new FileInputStream(
					"result.obj"));
			Test t = (Test) oin.readObject();
			oin.close();
			
			//再读取，通过t.staticVar打印新的值
			System.out.println(t.staticVar);//10
			
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
}

Parentimport java.io.Serializable;


public class Parent implements Serializable {
	
	private static final long serialVersionUID = 1L;
	
	public int pi = 2;
	
	public String pstr ="pstr";
	
	public  transient String ts  ; 
	
}

Son and mainimport java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;
import java.io.Serializable;

public class Son extends Parent implements Serializable {

	private static final long serialVersionUID = 1L;

	public int si = 1;
	public String sstr = " sstr";

	public static void main(String[] args) throws FileNotFoundException, IOException, ClassNotFoundException {
		String path = "d:" + File.separator + "son.dll";
		Son s = new Son();
		s.si = 2;
		s.pi = 2;
		s.ts = "ts"; // ts在父类中的定义使用transient关键字

		ObjectOutputStream op = null;
		ObjectInputStream oi = null;

		op = new ObjectOutputStream(new FileOutputStream(new File(path)));
		op.writeObject(s);
		op.close();
		oi = new ObjectInputStream(new FileInputStream(path));
		Son s1 = (Son) oi.readObject();

		System.out.println("父类中的String pstr:" + s1.pstr);
		System.out.println("父类中的int pi:" + s1.pi);
		System.out.println("子类中的int si:" + s1.si);
		System.out.println("父类中的transient String ts :" + s1.ts);//

	}
}

testList<String> ls = new ArrayList<String>();
List<Boolean> ls1 = new ArrayList<Boolean>();
System.out.println(ls==ls1) ;
//true;

testimport java.util.* ;
import java.lang.* ;

public class Fanx {
	
	public static void main (String args[]) {
		ArrayList<Integer> ls = new ArrayList<Integer>();
		try{
			ls.getClass().getMethod("add", Object.class).invoke(ls,"abc") ;
		}catch(Exception e){
			System.out.println(e.getMessage());
		}
		
		System.out.println(ls.get(0));
	}
}//out:abc

testpublic static void printCollection(Collection<?> coll) {
//可以传Collection<String>,Collection<Integer>,Collection<Boolean>等等，但在此方法内不能使用诸如coll.add(“Strin”)这样具有类型信息的方法
for(Object obj:coll){
	System.out.println(obj);
}//coll.add(“str”); 报错
}

testpublic static void printCollection1(Collection<? extends Number> coll) {
		//
		for(Object obj:coll){
			System.out.println(obj);
		}
}
//printCollection1(new ArrayList<Integer>()) ;//不报错
//printCollection1(new ArrayList<String>()) ; //报错，传入泛型参数必须为Number的子类

testpublic static void printCollection2(Collection<? super Number> coll) {
		//
		for(Object obj:coll){
			System.out.println(obj);
		}
	}
//printCollection1(new ArrayList<Integer>()) ;//不报错
//printCollection1(new ArrayList<String>()) ; //报错，传的参数化必须是以Number为父类

testpublic <T> T swap(T[] t,int i,int j){
		T temp = t[i] ;
		t[i] = t[j] ;
		t[j] = t[i] ;
		return (T) t ;
}

testpublic class Dao<T> {
	public <T> T getEntity(int id){
		return null;
	}
}

testimport java.lang.reflect.Method;
import java.lang.reflect.Type;
import java.util.Date;
import java.util.Map;
import java.util.Vector;

//假如我们要想获得 Vector<Date> v = new Vector<Date>(); v的实际类型参数
//我们必须写一个如applyRef的方法
public class Dao {
	
	public void applyRef1(Map<String,Integer> map,Vector<Date> v){
		
	}
	
	public static void main(String[] args) {
		try {
			Method method = new Dao().getClass().getMethod("applyRef1", Map.class,Vector.class) ;
			
			Type[] pType = method.getParameterTypes();
			
			Type[] neiType = method.getGenericParameterTypes();
			
			System.out.println(pType[0]) ;
			System.out.println(pType[1]) ;
			
			System.out.println(neiType[0]) ;
			System.out.println(neiType[1]) ;
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

Combinationsimport java.io.File;
import java.io.Serializable;


public class Combinations implements Serializable{
	/**
	 * 
	 */
	private static final long serialVersionUID = 6509436857839528414L;
	
	private int min;
	private int max;
	private char[] chars;// 字符数组
	private int charLen;// 字符串长度

	private String path ;
	private String trueStr ;
	private IOUtil iou;
	

	public Combinations() {
		this.min = 1;
		this.max = trueStr.length() ;
		this.charLen = trueStr.length();
		this.chars = trueStr.toCharArray();
	}


	public Combinations(String str, int min, int max, String path) {
		this.min = min;
		this.max = max;
		this.trueStr = str ;
		this.charLen = str.length();
		this.chars = str.toCharArray();
		iou = IOUtil.getInstence(path);
	}

	public void combination() {
		if (min > max) {
			int t = max;
			max = min;
			min = t;
		}
		for (int i = min; i <= max; i++) {
			combination(new StringBuffer(""), i);
		}
	}

	public void combination(StringBuffer str, int length) {
		if (length < 1) {
			System.out.println("长度小于1");
		}
		
		if (length == 1) {
			for (int i = 0; i < charLen; i++) {
				StringBuffer result = new StringBuffer(str);
				result.append(chars[i]);
				iou.put(result.toString(), 
						MD5Util.getMD5Str(result.toString()));
			}
		}

		if (length > 1) {
			for (int i = 0; i < charLen; i++) {
				StringBuffer temp = new StringBuffer(str);
				 combination(temp.append(chars[i]), length - 1);
			}
		}

	}
	
	/**
	 *setter getter  
	 */
	public IOUtil getIou() {
		return iou;
	}

	public void setIou(IOUtil iou) {
		this.iou = iou;
	}

	public int getMin() {
		return min;
	}

	public void setMin(int min) {
		this.min = min;
	}

	public int getMax() {
		return max;
	}


	public void setMax(int max) {
		this.max = max;
	}


	public char[] getChars() {
		return chars;
	}


	public void setChars(char[] chars) {
		this.chars = chars;
	}


	public int getCharLen() {
		return charLen;
	}


	public void setCharLen(int charLen) {
		this.charLen = charLen;
	}


	public String getPath() {
		return path;
	}


	public void setPath(String path) {
		this.path = path;
	}


	public String getTrueStr() {
		return trueStr;
	}


	public void setTrueStr(String trueStr) {
		this.trueStr = trueStr;
	}


	public static void main(String[] args) {
		String path = "F:"+File.separator+"md5"
						+File.separator+"md5.txt";
		Combinations ct = new Combinations("123456",1,4,path);
		ct.combination() ;
		ct.getIou().close() ;
	}


}

md5Utilimport java.io.UnsupportedEncodingException;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;


public class MD5Util {
	/**
	 * MD5 加密
	 */
	public static String getMD5Str(String str) {
		MessageDigest messageDigest = null;

		try {
			messageDigest = MessageDigest.getInstance("MD5");
			messageDigest.reset();
			messageDigest.update(str.getBytes("UTF-8"));
		} catch (NoSuchAlgorithmException e) {
			System.out.println("NoSuchAlgorithmException caught!");
			System.exit(-1);
		} catch (UnsupportedEncodingException e) {
			e.printStackTrace();
		}

		byte[] byteArray = messageDigest.digest();

		StringBuffer md5StrBuff = new StringBuffer();

		for (int i = 0; i < byteArray.length; i++) {
			if (Integer.toHexString(0xFF & byteArray[i]).length() == 1)
				md5StrBuff.append("0").append(
						Integer.toHexString(0xFF & byteArray[i]));
			else
				md5StrBuff.append(Integer.toHexString(0xFF & byteArray[i]));
		}

		return md5StrBuff.toString();
	}

}

md5Utilimport java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;
import java.io.Serializable;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

public class IOUtil implements Serializable {
	/**
	 * 
	 */
	private static final long serialVersionUID = 1611785226109373473L;
	
	/*
	 * 接收key 和 value，然后写入一个map，计数器count++如果count>30，IOWrite进入flush；
	 * 判断文件是否大于30MB，则新建另一文件将map清空，将count设置为0；
	 */
	private String sourcePath;
	private String newPath;
	private int MAXSIZE = 30000;
	private int fileCount = 0; // 文件计数器
	private PrintWriter pw = null;
	private List<String> list = new ArrayList<String>();
	private static IOUtil instance = new IOUtil();

	private IOUtil() {
	}

	public static IOUtil getInstence(String path) {
		if (null == instance) {
			instance = new IOUtil();
		}
		instance.setSourcePath(path);
		instance.setNewPath(path);
		return instance;
	}

	public void put(String key, String value) {
		//判断path中的文件
		File file = new File(newPath) ;
		if(!file.exists()){
			try {
				file.createNewFile();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}else{
		}
		
		
		try {
			pw = new PrintWriter(new FileWriter(file));
		} catch (IOException e) {
			System.out.println("找不到文件" + e.getMessage());
		}
		
		if (list.size() <= MAXSIZE) {
			list.add(key + "  " + value);
		} else {
			Iterator<String> it = list.iterator();
			while (it.hasNext()) {
				pw.println(it.next());
			}
			// 刷新
			pw.flush();
			list.clear();
			this.fileCount++;
			this.newPath = this.sourcePath.substring(0, this.sourcePath
					.lastIndexOf('.'))
					+ "_"
					+ this.fileCount
					+ this.sourcePath.substring(this.sourcePath
							.lastIndexOf('.'));

		}
	}

	@SuppressWarnings("unchecked")
	public void close() {
		Iterator itor = null;
		if (list.size() > 0 && this.pw != null) {
			itor = list.iterator();
			while (itor.hasNext()) {
				pw.println(itor.next());
			}
			pw.close();
		}
		itor = null;
		pw = null;
	}

	/*******************
	 * getter setter
	 *******************/
	public String getSourcePath() {
		return sourcePath;
	}

	public void setSourcePath(String sourcePath) {
		this.sourcePath = sourcePath;
	}

	public String getNewPath() {
		return newPath;
	}

	public void setNewPath(String newPath) {
		this.newPath = newPath;
	}

	public PrintWriter getPw() {
		return pw;
	}

	public void setPw(PrintWriter pw) {
		this.pw = pw;
	}

}

Bark，狗叫声类import java.util.Collection;
import java.util.List;


public class Bark {
	private String sound ;

	private DogDoor dogDoor ;
	
	public Bark(DogDoor dogDoor){
		this.dogDoor = dogDoor ;
	}
	public Bark(String sound) {
		this.sound = sound ;
	}
	public Bark(DogDoor dogDoor,String sound) {
		this(dogDoor) ;
		this.sound = sound ;
	}

	
	public boolean equals(Bark bark) {
		if(bark!=null && bark.sound.equals(this.sound)){
			return true ;
		}
		return false ;
	}
	
	public String getSound() {
		return sound;
	}

	public void setSound(String sound) {
		this.sound = sound;
	}
	
	public Bark() {} 
	
}

BarkRecognizer，狗叫识别器import java.util.Collection;
import java.util.Iterator;


public class BarkRecognizer {
	private DogDoor dogDoor ;

	public BarkRecognizer(DogDoor dogDoor) {
		super();
		this.dogDoor = dogDoor;
	}
	
	public void recognizer(Bark bark) {
		Collection barks = dogDoor.getAllowedBarks() ;
		Iterator it = barks.iterator() ;
		while(it.hasNext()){
			if(bark.equals((Bark)it.next()) ){
				dogDoor.open() ;
				System.out.println("the door opens");
				break ;
			}
		}
		
		System.out.println(bark.getSound() + "is not bruce");
		
//		if(barks != null && barks.size() >=1){
//			 if(barks.contains(bark)){
//				 dogDoor.open() ;
//			 }
//		}
	}
	
	public BarkRecognizer() {}
}

狗门import java.util.LinkedList;
import java.util.List;
import java.util.Timer;
import java.util.TimerTask;

public class DogDoor {
	
	private boolean open ;
	List barks = new LinkedList();
	
	public void open() {
		if(!open){
			this.open = true ;
		}
		final Timer timer = new Timer() ;
		timer.schedule(new TimerTask(){
			public void run() {
				close() ;
				timer.cancel() ;
			}
		},5000);
	}
	
	public void close() {
		this.open = false ;
		System.out.println("the door close");
	}
	
	public void addAllowedBark(Bark bark) {
		if(bark!=null){
			this.barks.add(bark) ;
		}
	}
	
	public List getAllowedBarks() {
		return this.barks ;
	}
	
	public boolean isOpen() {
		return open ;
	}
	
}	

遥控器
public class Remote {
	private DogDoor dogDoor ;

	public Remote(DogDoor dogDoor) {
		super();
		this.dogDoor = dogDoor;
	}

	public void pressButton() {
		dogDoor.open() ;
	}
	
	public Remote() {} ;
}

测试类import org.junit.Test;



public class TestDogDoor {
	@Test
	public void dogDoorTest() {
		DogDoor door = new DogDoor() ;
		door.addAllowedBark(new Bark("rowlf")) ;
		door.addAllowedBark(new Bark("roooowlf")) ;
		door.addAllowedBark(new Bark("woof")) ;
		door.addAllowedBark(new Bark("rawlf")) ;
		
		BarkRecognizer recognizer = new BarkRecognizer(door) ;
		
		Remote remote = new Remote(door);

		System.out.println("bruce starts barkings") ;
		
		recognizer.recognizer(new Bark("rowlf")) ;
		
		System.out.println("bruce has gone outside") ;
		
		try{
			Thread.currentThread().sleep(1000) ;
		}catch(InterruptedException e){
			System.out.println("error") ;
		}
		
		System.out.println("bruce' all done") ;
		System.out.println("but he's stuck outside!") ;
		Bark smallDogBark = new Bark("yip") ;
		System.out.println("a small dog starts barking");
		recognizer.recognizer(smallDogBark) ;
		
		try{
			Thread.currentThread().sleep(1000) ;
		}catch(InterruptedException e){
			System.out.println("error") ;
		}
		System.out.println("bruce starts barking");
		recognizer.recognizer(new Bark("woof")) ;
		
		System.out.println("bruce 'back inside");
		
	}
}

spring配置文件<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:tx="http://www.springframework.org/schema/tx"
    xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-2.5.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
    <context:annotation-config />
    <context:component-scan base-package="cc.apl330" />

<bean
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <value>classpath:jdbc.properties</value>
        </property>
    </bean> 

    <bean id="dataSource" destroy-method="close"
        class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName"
            value="${jdbc.driverClassName}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
    </bean> 

    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!-- 
        <property name="annotatedClasses">
            <list>
                <value>com.bjsxt.model.User</value>
                <value>com.bjsxt.model.Log</value>
            </list>
        </property>
         -->
         <property name="packagesToScan">
            <list>
                <value>cc.apl330.model</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">
                    org.hibernate.dialect.MySQLDialect
                </prop>
                <prop key="hibernate.show_sql">true</prop>
            </props>
        </property>
    </bean>
    <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>

</beans>

AOP类package cc.apl330.aspect;

public class UserAspect {
	public void before() {
		System.out.println("method before!");
	}
}

数据库操作package cc.apl330.dao;

import cc.apl330.model.User;

public interface IDAO {
	public void save(User user) ;
}

数据库操作package cc.apl330.dao;

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

import javax.sql.DataSource;

import cc.apl330.model.User;

public class UserDAO implements IDAO {

	private DataSource dataSource ;
	
	public void save(User user) {
		int id = user.getId(); 
		String name = user.getName() ;
		String sql = "INSERT INTO USER(_id,_name) VALUE(?,?)" ;
		Connection conn = null ;
		PreparedStatement ps = null ;
		try {
			conn = dataSource.getConnection() ;
			ps = conn.prepareStatement(sql) ;
			ps.setInt(1, id) ;
			ps.setString(2, name) ;
			ps.executeUpdate() ;
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				ps.close() ;
				conn.close() ;
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

	public DataSource getDataSource() {
		return dataSource;
	}

	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
	}
	
}

业务层package cc.apl330.service;

import cc.apl330.dao.IDAO;
import cc.apl330.dao.UserDAO;
import cc.apl330.model.User;

public class UserService {
	private UserDAO userdao = null ;

	public void add(User user) {
		userdao.save(user) ;
	}
	
	public UserDAO getUserdao() {
		return userdao;
	}

	public void setUserdao(UserDAO userdao) {
		this.userdao = userdao;
	}
	
}

测试类package cc.apl330.service;

import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import cc.apl330.model.User;


public class UserServiceTest {
	@Test
	public void save() {
		ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext("beans.xml") ;
		UserService userService = (UserService) ctx.getBean("userService");
		User user = new User() ;
		user.setName("apl330") ;
		userService.add(user);
	}
}

sping配置文件<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context-2.5.xsd
           http://www.springframework.org/schema/aop
           http://www.springframework.org/schema/aop/spring-aop-2.5.xsd">
       <bean id="dao" class="cc.apl330.dao.UserDAO"  >
       			<property name="dataSource" ref="dataSource"></property>
       </bean>
       <bean id="user" class="cc.apl330.model.User" scope="prototype"></bean>
	  <bean id="userService" class="cc.apl330.service.UserService">
	  		<property name="userdao" ref="dao"></property>
	  </bean>
	  <bean id="addbefore" class="cc.apl330.aspect.UserAspect"></bean>
	  <aop:config>
	  	<aop:pointcut 
				  	expression="execution(public * cc.apl330.service.*.add(..))" 
				  	id="userpoincut"/>
			<aop:aspect id="useraspect" ref="addbefore" >
			<aop:before method="before" pointcut-ref="userpoincut"/>
		</aop:aspect>
	  </aop:config>
	  
	  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
	  	<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
	  	<property name="url" value="jdbc:mysql://localhost:3306/spring"></property>
	  	<property name="username" value="root"></property>
	  	<property name="password" value="359848184"></property>
	  </bean>	  
</beans>

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse; 

public class SimpleHello extends HttpServlet { 

    @Override
    public void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws ServletException, IOException {
        PrintWriter out = resp.getWriter() ;
        out.println("hello world");
        out.close() ;
    }
} 

 <servlet>
      <servlet-name>SimpleHello</servlet-name>
      <servlet-class>cc.apl330.SimpleHello</servlet-class>
  </servlet>
  <servlet-mapping>
      <servlet-name>SimpleHello</servlet-name>
      <url-pattern>/hello</url-pattern>
  </servlet-mapping>

package cc.apl330;

public class Citys_Arr {

	private String[] citys = {"桂林","崇左"} ;
	
	private String[][] zone = {
			{"平乐","临桂","荔浦","二塘"},
			{"龙州","天等","花山","乐一"}
			} ;
	
	public String[] getCitys() {
		return citys;
	}

	public void setCitys(String[] citys) {
		this.citys = citys;
	}

	public String[][] getZone() {
		return zone;
	}

	public void setZone(String[][] zone) {
		this.zone = zone;
	}
	
}

public class Person{
	
	
	public static void main(String[] args) {
		Person p1 = new Person("p1","femail",15) ;
		Person p2 = new Person("p","mail",  20) ;
		Person p3 = new Person("p","mail",  20) ;
		System.out.println(p1.equals(p2)) ;
		System.out.println(p3.equals(p2)) ;
	}
	
	public Person()  {} ;
	
    public Person(String name, String sex, int age) {
		super();
		this.name = name;
		this.sex = sex;
		this.age = age;
	}

    
    
	public boolean equals(Object otherObject) {
		//检测两个引用是否指向同一对象
		if( this == otherObject ) return true ;
		//检测otherObject是否为空
		if( null == otherObject) return false ;
		//检测是否为同一个类
		if( getClass() != otherObject.getClass() ) return false ;
		//将otherObject转成Person类
		Person person = (Person)otherObject ;
		return this.getName().equals(person.getName()) 
				&& this.getSex().equals(person.getSex()) 
				&& this.getAge() == person.getAge() ;
		
	}


	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getSex() {
		return sex;
	}
	public void setSex(String sex) {
		this.sex = sex;
	}
	public int getAge() {
		return age;
	}
	public void setAge(int age) {
		this.age = age;
	}
	
	public String name = null;
	public String sex  = null ;
	public int    age  = 0 ;
	
}

次序为:

1、static块内代码

2、自上而下的运行代码

3、在try{}catch(){}finally{}内，在try{}内遇到return关键字的时候，就马上跳到finally块内执行。

4、执行完毕finally{}块后就执行刚才的return语句

注意：finally内有return后，方法的其他地方就不能存在return。

public class Main {

	static{
		System.out.println("static");
	}
	
	public int test(){
		try{
			System.out.println("try") ;
			return 1 ;
		}catch(Exception e){
			System.out.println(e.getMessage()) ;
		}finally{
			System.out.println("finally") ;
		}
		return 3 ;
	}
	
	public static void main(String[] args) {
	    int i = new Main().test() ;
	    System.out.println("test:" + i );
	}
}