亚洲AV综合永久无码精品天堂,亚洲国产成人综合,黑人精品videos亚洲人

2011年3月25日

JSTL的使用

1、在jsp文件的頭部加入

<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt"%>

2、<c:froEach/>的使用

<%
2

OperationDAO opDao = new OperationDAOImpl();
3

List<Operation> ops = opDao.getAll_();
4

MenuDAO meDao = new MenuDAOImpl();
5

List<Menu> mes = meDao.getAll_Lazy(1) ;
6

%>
7

<table id="demoTable" border="1">
8

<thead>
9

<th>id</th>
10

<th>顯示名稱</th>
11

<th>鏈接</th>
12

<th>所屬菜單</th>
13

<th>是否可見</th>
14

<th>操作</th>
15

</thead>
16

<tbody>
17

<c:forEach var="op" items="<%=ops %>">
18

<tr id="${op.op_Id}"
19

class="{op_Id:${op.op_Id},op_displayName:'${op.op_displayName}',op_link:'${op.op_link }',me_name:'${op.menu.me_displayName}',viewMode:'${op.viewMode}'}">
20

<td class="op_Id">${op.op_Id}</td>
21

<td class="op_displayName">${op.op_displayName}</td>
22

<td class="op_link">${op.op_link }</td>
23

<td class="me_name">${op.menu.me_displayName}</td>
24

<td class="viewMode">viewMode:${op.viewMode}</td>
25

<td><a class="editRecord" href="anotherPage.html">Edit</a> |
26

<a class="deleteRecord" href="anotherPage.html">Delete</a></td>
27

</tr>
28

</c:forEach>
29

</tbody>
30

</table>

posted @ 2011-05-08 23:16 jack zhai 閱讀(212) | 評(píng)論 (0) | 編輯收藏

spring的一般配置

beans.xml

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>

jdbc.properties

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

在web.xml里加入

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>

posted @ 2011-05-01 14:26 jack zhai 閱讀(231) | 評(píng)論 (0) | 編輯收藏

powerdesigner反向生成物理模型

需要先安裝ODBC，才可以使用ODBC連接方式連接數(shù)據(jù)庫

下載地址：mysql-connector-odbc-5.1.8-win32.msi

posted @ 2011-04-29 13:13 jack zhai 閱讀(454) | 評(píng)論 (0) | 編輯收藏

使用SchemaExport自動(dòng)生成表結(jié)構(gòu)

new SchemaExport(new AnnotationConfiguration().configure()).create(false, true);

posted @ 2011-04-29 08:09 jack zhai 閱讀(332) | 評(píng)論 (0) | 編輯收藏

<?xml version='1.0' encoding='gb2312'?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        
        <property name="show_sql">true</property>
        
        <property name="connection.url">jdbc:mysql://localhost:3306/Test</property>
        
        <property name="connection.username">sa</property>
        
        <property name="connection.password">sa</property>
        
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        
        <property name="connection.pool_size">1</property>
        
        <property name="current_session_context_class">thread</property>
        
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        
        <property name="hbm2ddl.auto">create</property>
        <mapping resource="events/User.hbm.xml"/>
        <mapping resource="events/Student.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

posted @ 2011-04-28 18:25 jack zhai 閱讀(298) | 評(píng)論 (0) | 編輯收藏

鏈表-java實(shí)現(xiàn)

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() ;
	}
	
}

posted @ 2011-04-26 05:57 jack zhai 閱讀(270) | 評(píng)論 (0) | 編輯收藏

Velocity配置

一、web.xml中的配置

<web-app>
2

<servlet>
3

<servlet-name>velocity</servlet-name>
4

<servlet-class>org.apache.velocity.tools.view.VelocityViewServlet</servlet-class>
5

</servlet>
6

<servlet-mapping>
7

<servlet-name>velocity</servlet-name>
8

<url-pattern>*.vm</url-pattern>
9

</servlet-mapping>
10

<welcome-file-list>
11

<welcome-file>index.vm</welcome-file>
12

</welcome-file-list>
13

</web-app>

二、可選配置tools.xml

<tools>

</toolbox>

</toolbox>

</tools>

posted @ 2011-04-14 08:45 jack zhai 閱讀(2607) | 評(píng)論 (0) | 編輯收藏

數(shù)據(jù)庫設(shè)計(jì)學(xué)習(xí)筆記

一、設(shè)計(jì)過程包含五個(gè)主要步驟。

第 1 步：確定實(shí)體和關(guān)系

第 2 步：確定所需數(shù)據(jù)

第 3 步：規(guī)范化數(shù)據(jù)

第 4 步：解析關(guān)系

第 5 步：驗(yàn)證設(shè)計(jì)

二、閱讀別人的概念模型圖：
不管是從左到右讀取還是從右到左讀取，下面的規(guī)則都會(huì)使讀取這些圖示變得容易：讀取 (1) 第一個(gè)實(shí)體的名稱，(2) 第一個(gè)實(shí)體 旁邊的角色，(3) 到第二個(gè)實(shí)體 的連接的基數(shù)，(4) 第二個(gè)實(shí)體的名稱。

三、確定所需數(shù)據(jù)（實(shí)體屬性的設(shè)計(jì)）需要注意的：

確定支持?jǐn)?shù)據(jù)時(shí)，一定要參考前面確定的活動(dòng)以了解將如何訪問這些數(shù)據(jù)。

例如，在某些情況下可能需要按雇員的名字列出雇員，而在另一些情況下可能需要按姓氏列出。要滿足這兩種需要，應(yīng)創(chuàng)建一個(gè) First Name 屬性和一個(gè) Last Name 屬性，而不應(yīng)創(chuàng)建一個(gè)既包含名字又包含姓氏的屬性。將姓氏和名字分開后，以后可以創(chuàng)建兩個(gè)索引，分別適用于這兩項(xiàng)任務(wù)。

請(qǐng)選擇一致的名稱。使用一致的名稱可以使數(shù)據(jù)庫便于維護(hù)，并且便于閱讀報(bào)告和輸出窗口。

例如，如果一個(gè)屬性使用了縮略名稱，如 Emp_status，則另一個(gè)屬性不應(yīng)使用完整名稱，如 Employee_ID。應(yīng)使名稱保持一致，如 Emp_status 和 Emp_ID。

在這個(gè)階段，數(shù)據(jù)是否與正確的實(shí)體相關(guān)聯(lián)并不十分重要。您可以根據(jù)自己的判斷進(jìn)行設(shè)計(jì)。在下一節(jié)中，將對(duì)設(shè)計(jì)進(jìn)行測(cè)試，檢查您的判斷是否正確。

四、規(guī)范化是指一系列測(cè)試，通過這些測(cè)試可以消除冗余的數(shù)據(jù)，并確保數(shù)據(jù)與正確的實(shí)體或關(guān)系相關(guān)聯(lián)。共有五項(xiàng)測(cè)試。本節(jié)介紹其中前三項(xiàng)測(cè)試。這三項(xiàng)測(cè)試最重要，因此也最常使用。

五、范式：

數(shù)據(jù)規(guī)范化包括幾項(xiàng)測(cè)試。數(shù)據(jù)在通過了第一項(xiàng)測(cè)試后，我們認(rèn)為它滿足第一范式；通過了第二項(xiàng)測(cè)試后，它滿足第二范式；通過了第三項(xiàng)測(cè)試后，則滿足第三范式。

六、標(biāo)識(shí)符是唯一地標(biāo)識(shí)實(shí)體中各行的一組屬性，至少由一個(gè)屬性組成。

七、解析關(guān)系：
執(zhí)行完規(guī)范化過程后，設(shè)計(jì)幾乎就完成了。唯一還需要做的事情就是生成與概念數(shù)據(jù)模型相對(duì)應(yīng)的物理數(shù)據(jù)模型。這個(gè)過程也稱作解析關(guān)系，因?yàn)槠渲猩婕暗拇罅抗ぷ骶褪菍⒏拍钅Ｐ椭械年P(guān)系轉(zhuǎn)換為相應(yīng)的表和外鍵關(guān)系。

八、概念數(shù)據(jù)模型可以簡(jiǎn)化設(shè)計(jì)過程，因?yàn)樗鼘⒋罅考?xì)節(jié)隱藏起來。例如，多對(duì)多關(guān)系總會(huì)生成一個(gè)額外的表和兩個(gè)外鍵引用。在概念數(shù)據(jù)模型中，通常可以用一個(gè)連接來標(biāo)識(shí)這類結(jié)構(gòu)。

九、域（用戶定義的數(shù)據(jù)類型）

十、數(shù)據(jù)庫對(duì)象的定義構(gòu)成了數(shù)據(jù)庫模式：您可以將模式看做一個(gè)空數(shù)據(jù)庫。（是否可以理解成C#的命名空間或java里的包概念）

十一、

posted @ 2011-04-11 08:44 jack zhai 閱讀(246) | 評(píng)論 (0) | 編輯收藏

JQuery插件：TableEditor試用

這個(gè)插件在JQuery1.5.1版下無法使用。

項(xiàng)目地址：http://dev.iceburg.net/jquery/tableEditor/demo.php

html文件：

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文件

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>

posted @ 2011-04-09 06:27 jack zhai 閱讀(2758) | 評(píng)論 (1) | 編輯收藏

用于Request的工具類 from DLOG4J

從DLOG4J讀到的Request的工具類：

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("加載手機(jī)號(hào)碼匹配策略文件/mobile_match.conf失敗",e);
		}
	}

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

	/**
	 * 獲取FCKUpload過程中生成的會(huì)話ID
	 * @return
	 */
	public static String getDlogSessionId(HttpServletRequest req){
		//優(yōu)先從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得不到則從服務(wù)器的會(huì)話中讀取
			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;
	}

	/**
	 * 設(shè)置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));
		}
	}
	/**
	 * 從請(qǐng)求中解析手機(jī)號(hào)碼
	 * @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信息，名字大小寫無關(guān)
	 * @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));
		}
	}

	/**
	 * 判斷手機(jī)是否支持某種類型的格式
	 * @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;
	}

	/**
	 * 獲取瀏覽器提交的整形參數(shù)
	 * @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;
	}
	/**
	 * 獲取瀏覽器提交的字符串參數(shù)
	 * @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;
	}

}

posted @ 2011-03-31 08:33 jack zhai 閱讀(444) | 評(píng)論 (0) | 編輯收藏

過濾敏感詞匯類

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();
			}
		}

		/**
		 * 自動(dòng)將敏感詞匯用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;
		}
		
		/**
		 * 判斷是否存在非法內(nèi)容
		 * @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;
		}
		
		/**
		 * 刪除內(nèi)容中存在的關(guān)鍵字
		 * @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 = "中華人民共和國(guó)國(guó)家主席毛澤東，我們叫他毛主席";
		System.out.println(IllegalGlossary.autoGlossaryFiltrate(text));
	}
}

這個(gè)類，是從DLOG4J上學(xué)到的。

posted @ 2011-03-31 08:16 jack zhai 閱讀(839) | 評(píng)論 (3) | 編輯收藏

權(quán)限管理系統(tǒng) sql

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;

posted @ 2011-03-30 13:25 jack zhai 閱讀(317) | 評(píng)論 (0) | 編輯收藏

sqlserver 基礎(chǔ)

  1 --創(chuàng)建表
  2     if exists(select * from sysobjects where name='user' and type='U') drop table [user] ;
  3     create table [user](
  4     id int identity(1,1) , --自增字段
  5     name varchar(50) ,
  6     pwd varchar(50) ,
  7     constraint pk_user_id primary key(id) --主鍵
  8     --constraint pk_user_id primary key(id,[name])
  9     );
10
11 -- 變量的聲明,sql里面聲明變量時(shí)必須在變量前加@符號(hào)
12     DECLARE @I INT
13
14 -- 變量的賦值，變量賦值時(shí)變量前必須加set
15     SET @I = 30
16
17 -- 聲明多個(gè)變量
18     DECLARE @s varchar(10),@a INT
19
20 -- Sql 里if語句
21     IF 條件 BEGIN
22         執(zhí)行語句
23     END
24     ELSE BEGIN
25         執(zhí)行語句
26     END
27
28     DECLARE @d INT
29     set @d = 1
30
31     IF @d = 1 BEGIN
32
33     -- 打印
34         PRINT '正確'
35     END
36     ELSE BEGIN
37         PRINT '錯(cuò)誤'
38     END
39
40
41 -- Sql 里的多條件選擇語句.
42     DECLARE @iRet INT, @PKDisp VARCHAR(20)
43     SET @iRet = 1
44     Select @iRet =
45     CASE
46         WHEN @PKDisp = '一' THEN 1
47         WHEN @PKDisp = '二' THEN 2
48         WHEN @PKDisp = '三' THEN 3
49         WHEN @PKDisp = '四' THEN 4
50         WHEN @PKDisp = '五' THEN 5
51         ELSE 100
52     END
53
54 -- 循環(huán)語句
55     WHILE 條件 BEGIN
56         執(zhí)行語句
57     END
58
59     DECLARE @i INT
60     SET @i = 1
61     WHILE @i<1000000 BEGIN
62         set @i=@i+1
63     END
64     -- 打印
65     PRINT @i
66
67
68 -- TRUNCATE 刪除表中的所有行，而不記錄單個(gè)行刪除操作，不能帶條件
69
70     /*
71     TRUNCATE TABLE 在功能上與不帶 Where 子句的 Delete 語句相同：二者均刪除表中的全部行
72
73 。但 TRUNCATE TABLE 比 Delete 速度快，且使用的系統(tǒng)和事務(wù)日志資源少。
74     Delete 語句每次刪除一行，并在事務(wù)日志中為所刪除的每行記錄一項(xiàng)。TRUNCATE TABLE 通過
75
76 釋放存儲(chǔ)表數(shù)據(jù)所用的數(shù)據(jù)頁來刪除數(shù)據(jù)，并且只在事務(wù)日志中記錄頁的釋放。
77     TRUNCATE TABLE 刪除表中的所有行，但表結(jié)構(gòu)及其列、約束、索引等保持不變。新行標(biāo)識(shí)所用
78
79 的計(jì)數(shù)值重置為該列的種子。如果想保留標(biāo)識(shí)計(jì)數(shù)值，請(qǐng)改用 Delete。如果要?jiǎng)h除表定義及其數(shù)據(jù)，請(qǐng)
80
81 使用 Drop TABLE 語句。
82     對(duì)于由 FOREIGN KEY 約束引用的表，不能使用 TRUNCATE TABLE，而應(yīng)使用不帶 Where 子句的
83
84 Delete 語句。由于 TRUNCATE TABLE 不記錄在日志中，所以它不能激活觸發(fā)器。
85     TRUNCATE TABLE 不能用于參與了索引視圖的表。
86     示例
87         下例刪除 authors 表中的所有數(shù)據(jù)。*/
88
89         TRUNCATE TABLE authors
90
91
92 -- Select INTO 從一個(gè)查詢的計(jì)算結(jié)果中創(chuàng)建一個(gè)新表。數(shù)據(jù)并不返回給客戶端，這一點(diǎn)和普通的
93 -- Select 不同。新表的字段具有和 Select 的輸出字段相關(guān)聯(lián)（相同）的名字和數(shù)據(jù)類型。
94
95         select * into NewTable
96             from Uname
97
98
99 -- Insert INTO Select
100         -- 表ABC必須存在
101         -- 把表Uname里面的字段Username復(fù)制到表ABC
102         Insert INTO ABC Select Username FROM Uname
103
104 -- 創(chuàng)建臨時(shí)表
105         Create TABLE #temp(
106             UID int identity(1, 1) PRIMARY KEY,
107             UserName varchar(16),
108             Pwd varchar(50),
109             Age smallint,
110             Sex varchar(6)
111         )
112         -- 打開臨時(shí)表
113         Select * from #temp
114
115 -- 存儲(chǔ)過程
116         -- 要?jiǎng)?chuàng)建存儲(chǔ)過程的數(shù)據(jù)庫
117         Use Test
118         -- 判斷要?jiǎng)?chuàng)建的存儲(chǔ)過程名是否存在
119             if Exists(Select name From sysobjects Where name='csp_AddInfo' And
120
121 type='P')
122             -- 刪除存儲(chǔ)過程
123             Drop Procedure dbo.csp_AddInfo
124         Go
125
126
127         -- 創(chuàng)建存儲(chǔ)過程
128         Create Proc dbo.csp_AddInfo
129         -- 存儲(chǔ)過程參數(shù)
130         @UserName varchar(16),
131         @Pwd varchar(50),
132         @Age smallint,
133         @Sex varchar(6)
134         AS
135         -- 存儲(chǔ)過程語句體
136         insert into Uname (UserName,Pwd,Age,Sex)
137             values (@UserName,@Pwd,@Age,@Sex)
138         RETURN
139         -- 執(zhí)行
140         GO
141
142         -- 執(zhí)行存儲(chǔ)過程
143         EXEC csp_AddInfo 'Junn.A','123456',20,'男';
144 修改自：http://blog.csdn.net/mx1029/archive/2007/07/06/1680910.aspx

posted @ 2011-03-25 16:31 jack zhai 閱讀(208) | 評(píng)論 (0) | 編輯收藏

老翟

JSTL的使用

spring的一般配置

powerdesigner反向生成物理模型

使用SchemaExport自動(dòng)生成表結(jié)構(gòu)

hibernate配置模板

鏈表-java實(shí)現(xiàn)

Velocity配置

數(shù)據(jù)庫設(shè)計(jì)學(xué)習(xí)筆記

JQuery插件：TableEditor試用

用于Request的工具類 from DLOG4J

過濾敏感詞匯類

權(quán)限管理系統(tǒng) sql

sqlserver 基礎(chǔ)

導(dǎo)航

常用鏈接

留言簿

隨筆分類

隨筆檔案

相冊(cè)

搜索

最新評(píng)論

閱讀排行榜

評(píng)論排行榜