2008年4月1日随笔档案 - Skynet

hbn-annotations学习-不求人(ant junit环境配置)

学习就从官方的测试开始，但不知道怎么回事官方的测试有问题，这我就把我配置的简单junit环境共享给大家把！
1.下载 hibernate-annotations-3.4.0.GA 并解压 ,cd 到解压后目录下
2. $>ant junit （天知道，怎么官方出的东西测试不能通过！！）
   不要急，我们来看错误 (错误提示有删减)
     错误-1：$>build.xml:95: ./jdbc not found.
     解决办法-1： $>mkdir ./jdbc
3. $>ant junit
     错误-2：
      ./build.xml:124: The following error occurred while executing this line:
      ./build.xml:126: The following error occurred while executing this line:
      ./common-build.xml:349: .\src\filters\hsqldb.filter as it doesn't exist.
     解决办法-2：
       $>mkdir ./src/filters ;
       $>echo "" > ./src/filters/hsqldb.filter;
4. $>ant junit
     错误-3：
       ./build.xml:124: The following error occurred while executing this line:
       ./build.xml:126: The following error occurred while executing this line:
       ./common-build.xml:351: .\src\test-resources not found.
      $>mkdir ./src/test-resources ;
5. $>ant junit
     错误-4：没有ant 错误了！，但测试都为错误，那我们就看看第一个测试吧，找下原因！
         test-resources:
          [mkdir] Created dir: hibernate-anntations-3.4.0.GA\build\test-reports\hsqldb
          [echo] Running against db: hsqldb
          [junit] Running org.hibernate.test.annotations.ConfigurationTest
          [junit] Tests run: 7, Failures: 0, Errors: 6, Time elapsed: 1.218 sec
          .............
     $>find . -name "ConfigurationTest.java" #pwd /hibernate-anntations-3.4.0.GA
        ./test/org/hibernate/test/annotations/configuration/ConfigurationTest.java
        ./test/org/hibernate/test/annotations/ConfigurationTest.java
      根据路径 org.hibernate.test.annotations.ConfigurationTest
      gvim ./test/org/hibernate/test/annotations/ConfigurationTest.java
      发现第20行: cfg.configure( "org/hibernate/test/annotations/hibernate.cfg.xml" );
      感觉应该没有配置 jdbc
      gvim ./test/org/hibernate/test/annotations/hibernate.cfg.xml #果然没配置
      我这就放个我的简单配置上来(使用 hbm hsqldb 内存数据库测试 )：

<!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="hibernate.dialect">org.hibernate.dialect.HSQLDialect</property>
        <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
        <property name="connection.url">jdbc:hsqldb:mem:hbn_ann</property>
        <property name="connection.username">sa</property>
        <property name="connection.password"></property>

        <mapping resource="org/hibernate/test/annotations/Boat.hbm.xml"/>
        <mapping package="org.hibernate.test.annotations"/>
        <mapping class="org.hibernate.test.annotations.Plane"/>
  </session-factory>
</hibernate-configuration>

      我这就是要hsqldb吧，既然上面错误1有 jdbc 文件夹，那就是放 jdbc jar 的地方
      $> cp ../hsqldb.jar ./jdbc

6. $>ant junit
     呵呵测试第一个正确了！（目前配置后，测试环境并不是全部都正确，比如第2个测试）
     其他测试错误日志在    .\build\test-reports\hsqldb ...
     比如第2个错误异常部分
      org.hibernate.HibernateException: The dialect was not set. Set the property hibernate.dialect.
    at org.hibernate.dialect.Dialect.instantiateDialect(Dialect.java:256)
    at org.hibernate.dialect.Dialect.getDialect(Dialect.java:234)
        ........ 大家一边学习，一边配置测试环境吧。
    错误日记都会在 build\test-reports\hsqldb下

posted @ 2009-04-14 11:30 G_G 阅读(1664) | 评论 (0) | 编辑收藏

html css 切割图片显示

参考：
http://tech.ddvip.com/2008-12/122835390597191.html

页面可以直接运行：

<html>
<head>

<style type="text/css">

.box1 {
float:left;
width:21px;
height:21px;
position:relative;
background: #F3F2E2 url(http://mp3.youdao.com/images/mbox_bg.gif) no-repeat;
}
.box1 {
background-position: 0px -60px;
}

</style>

</head>

<body>

    <div class="box1"
        onmouseover="this.style.backgroundPosition='0px -81px' "
        onmouseout="this.style.backgroundPosition='0px -102px' "
    >
    </div>

</body>

</html>

posted @ 2009-02-24 16:46 G_G 阅读(1984) | 评论 (0) | 编辑收藏

javascript 基础总结（面向对象）

javascript 学习

javascript 大体上可分为3个不同部分组成：核心（ECMAscript）,文本对象(DOM),浏览器对象(BOM)

核心（ECMAscript）：关键字，语句，运算符，对象
文本对象(DOM)：DOM将把整个页面规划成由节点层级构成的文档.

解析遵循 W3C html dom 标准：
W3C dom 参考特别关注 DOM Node 说明

BOM 浏览器对象. cookie,弹出新浏览器，浏览器设置大小

核心（ECMAscript）Global 内置对象；
方法： parseInt(),isNan(),encodeURI()...等都为此对象方法
特别注意 eval();动态语言的象征比如：eval("alert('hi')"); 但这个方法很邪恶（安全方面）
文本对象(DOM)说明：

<bookstore>
 <book category="cooking">
 <title lang="en">Everyday Italian</title> 
 <author>Giada De Laurentiis</author> 
 <year>2005</year> 
 <price>30.00</price> 
 </book>
</bookstore>

DOM node tree

Node tree

1. ECMAscript基础

$ 变量弱类型 ; 匈牙利类型标示 : var iOuouValue=100;

$ 结束行分号有无都可以; 但再 onsubmit="javascript:function();return false;"

$ 关键字 ; 提别注意

"constructor" bean.constructor

//print bean function(){

....

}

"typeof" var test=1; alert(typeof testX); //output "undefined"

"NaN" - not a number -> isNan("blue"); //output "true" ->isNan("123"); //output "false"

$ 对象; var o = new Object(); var a = {}

这里特别说明下我们普通写的一个 function 就是一个 object

这 var a = {name:"刘凯毅"} 等同与 var a = function(){this.name="刘凯毅"};

来个 {name:"test",pass:"123456",addr:"bj"} //这是什么？！ json

当 var str = '{name:"test",pass:"123456",addr:"bj"}'

var objectBean = eval(str); //这里就是对象 objectBea.name 使用了

域概念：

<SCRIPT type=text/javascript>
var sMessage = 'Hello';
function setSomething() {
sColor = 'red';
sMessage = 'Hello World!';
}
setSomething();
alert(sMessage); //Hello World!
alert(sColor); //red
</SCRIPT>

<SCRIPT type=text/javascript>
var sMessage = 'Hello';
function setSomething() {
var sColor = 'red';
sMessage = 'Hello World!';
}
setSomething();
alert(sMessage); //Hello World!
alert(sColor); // 什么都没有
</SCRIPT>

<SCRIPT type=text/javascript>
var sMessage = 'Hello';
function setSomething() {
var sColor = 'red';
var sMessage = 'Hello World!';
}
setSomething();
alert(sMessage); //Hello
alert(sColor); // 什么都没有
</SCRIPT>

为面向对象做基础：object prototype 类型的对象应用。参考

// 最简单的继承
Object.prototype.inObj = 1;

function A()
{
    this.inA = 2;
}

A.prototype.inAProto = 3;

B.prototype = new A;            // Hook up A into B's prototype chain
B.prototype.constructor = B;
function B()
{
    this.inB = 4;
}

B.prototype.inBProto = 5;

x = new B;
document.write(x.inObj + ', ' + x.inA + ', ' + x.inAProto + ', ' + x.inB + ', ' + x.inBProto);

//1, 2, 3, 4, 5
//增加点信心 http://www.json.org/json.js

Object.prototype.toJSONString = function (filter) {
 return JSON.stringify(this, filter);
};
后我们就可以使用 bean.toJSONString()不是吗？

$ arguments ;

function getFun(){alert(arguments.length);} ;

getFun("xx") //output 1

getFun("xx",23) //output 2

$ 语句 ;特殊说明下 for

for(var i=0i<iCount;i++) 或 for( attr in object ) ;

如果无聊你可以 for( sProp in window ){alert(sProp+"你丫点啊！");} //看看 javascript 的反射

面向对象：

var bean = new Bean();

1.工厂方法

function getAttr(){

alert(this.attr)

}

function Bean(tattr){

var bean = new Object;

bean.attr = tattr;

bean.getAttr = getAttr;

return bean ;

}

根本就是山寨版面向对象

2.构造

function Bean(tattr){

this.attr = tattr ;

bean.getAttr = function(){

alert(this.attr);

}

其上 2 总再Bean 对象创建时，方法会 “重复生成函数”！

3.原型模式

function Bean(){}

Bean.prototype.attr = "";

Bean.prototype.getAttr=function(){alert(this.attr);}

解决 “重复生成函数” 问题，但新的问题 Bean.prototype.getArray = new Array();

其 new 对象 bean1 和 bean2 都会共享 new Array 空间(是我们不想看到的)

4.混合模型 :) 哈哈

function Bean(){

this.attr= "";

this.getArray=new Array;

}

Bean.prototype.getAttr=function(){alert(this.attr);}

5.动态原型（注意下面开始，就是真正的面向对象！！！）

function Bean(){

this.attr= "";
this.getArray=new Array;

//classload 加载时

if(typeof Bean._initialized == "undefined" ){

Bean.prototype.getAttr=function(){alert(this.attr);};

Bean._initialized= true ;

}

/****************************************************************/

对象继承

1.对象冒充！！(可支持多继承，山寨很强大)

function classA(sstr){

this.color = sstr ;

this.sayColor = function(){

alert(this.color);

};

}

function classC(){}

function classB(){

this.newMethod =ClassA ;

this.newMethod();

delete this.newMethod ;

this.newMethod =ClassC ;

this.newMethod();

delete this.newMethod ;

this.arrt = "google";

}

2.call() apply() 也山寨,

function classA(sstr){

this.color = sstr ;

this.sayColor = function(str){

alert(str+this.color);

};

}

function classB(){

// this.newMethod =ClassA ;

// this.newMethod();

// delete this.newMethod ;

classA.call(this,"red");

//classA.apply(this,new Array("red"))

this.arrt = "baidu";

}

3.正统的继承 原型链 (但不支持多继承)
    function classA(){this.oo="test";}
    classA.prototype.color = "red";
    function classB(){}
    classB.prototype = new classA ;
    classB.prototype.sayName = function(){
        alert( this.color );
   }
   var bb = new classB ;
   bb.sayName(); // output red
   alert(bb.oo); // output test

   alert( bb instanceof classA); //output true
   alert( bb instanceof classB); //output true
4.如果你要多继承！！并且还支持 instanceof
        混合方式：
        function classA(){}
        function classB(){}
        function classC(){
            classA.call(this);
            classC.call(this);
       }
        classC.prototype = new classA ;//注意这 instanceof 只能对 A有用

posted @ 2009-02-12 11:56 G_G 阅读(1830) | 评论 (2) | 编辑收藏

linux flash 安装

下载：flash-plugin-10.0.15.3-release.i386.rpm

rpm -ivh flash-plugin-10.0.15.3-release.i386.rpm

posted @ 2009-01-12 23:39 G_G 阅读(737) | 评论 (0) | 编辑收藏

tomcat 调试

tomcat > server.xml

      <Host name="localhost" appBase="webapps"
       unpackWARs="true" autoDeploy="true"
       xmlValidation="false" xmlNamespaceAware="false">

<Context docBase="D:/workspace/meganotes/mn_mod_admin/target/mn_mod_admin/" path="/" />

。。。。

关键：在Context上不要加reloadable和debug属性
然后使用eclipse tomcat 调试
ok

posted @ 2008-12-26 17:52 G_G 阅读(526) | 评论 (0) | 编辑收藏

强大的 ant scp 和 sshexec

<? xml version="1.0" encoding="UTF-8" ?>
< project name ="ssh" >
     < property file ="ssh.properties" />
     < tstamp >
         < format property ="TODAY" pattern ="yyyyMMddHHmm" />
     </ tstamp >
     < property name ="ssh.path" value ="/data/meganotes/shell/" />

     < target name ="shell/ 文件上载/覆盖" >
         < input addproperty ="scp_coverage_shell_file"
            message ="输入（ssh/ 下文件名 \n\r 上载或覆盖到服务器 218 ${ssh.path} )：" >
         </ input >
         < input
             message ="请确定是否使用 ssh/${scp_coverage_shell_file} 覆盖服务器中 ${ssh.host}:${ssh.path}${scp_coverage_shell_file} (y,n)"
            validargs ="y,n" addproperty ="do.coverage" defaultvalue ="n" />
         < condition property ="do.abort" >
             < equals arg1 ="n" arg2 ="${do.coverage}" />
         </ condition >
         < fail if ="do.abort" > 退出 </ fail >

         < sshexec host ="${ssh.host}" username ="${ssh.myName}"
            password ="${ssh.myPass}" trust ="true"
            command ="
                    mkdir -p ${ssh.path}backup/${TODAY} ;
                    if [ -f ${ssh.path}${scp_coverage_shell_file}   ] ;
                    then
                        cp ${ssh.path}${scp_coverage_shell_file} ${ssh.path}backup/${TODAY}/ ;
                    fi ;
        " >
         </ sshexec >
         < scp file ="ssh/${scp_coverage_shell_file}"
            todir ="${ssh.myName}:${ssh.myPass}@${ssh.host}:${ssh.path}"
            trust ="true" verbose ="true" />

         < sshexec host ="${ssh.host}" username ="${ssh.myName}"
            password ="${ssh.myPass}" trust ="true"
            command ="chmod 777 ${ssh.path}${scp_coverage_shell_file}" >
         </ sshexec >
     </ target >

     < target name ="shell/ 文件查看" >
         < input addproperty ="show_shell_file" message ="输入查看文件名（*sh）："
            defaultvalue ="*" >
         </ input >
         < sshexec host ="${ssh.host}" username ="${ssh.myName}"
            password ="${ssh.myPass}" trust ="true"
            command ="ls  /data/meganotes/shell/${show_shell_file}" >
         </ sshexec >
     </ target >

     < target name ="shell/ 文件拷贝" >
         < input addproperty ="scp_shell_file"
            message ="输入 /data/meganotes/shell/ 下需要文件名（cp 到 ssh 下）：" >
         </ input >
         < scp
             file ="${ssh.myName}:${ssh.myPass}@${ssh.host}:/data/meganotes/shell/${scp_shell_file}"
            todir ="ssh" trust ="true" verbose ="true" />
     </ target >

     < target name ="admin-mvn组合操作" >
         < exec executable ="cmd" >
             < arg value ="/c" />
             < arg value ="${basedir}/sh/mvn/meganotes_mvn_clear.bat" />
         </ exec >
         < exec executable ="cmd" >
             < arg value ="/c" />
             < arg value ="${basedir}/sh/mvn/meganotes_mvn_install.bat" />
         </ exec >
         < exec executable ="cmd" >
             < arg value ="/c" />
             < arg value ="${basedir}/sh/mvn/mn_mod_admin_mvn_intall.bat" />
         </ exec >
     </ target >

     < target name ="admin-tomcat日志" >
         < sshexec host ="${ssh.host}" username ="${ssh.myName}"
            password ="${ssh.myPass}" trust ="true" command ="${ssh.adminRunLog}" >
         </ sshexec >
     </ target >

     < target name ="schedule-tomcat日志" >
         < sshexec host ="${ssh.host}" username ="${ssh.myName}"
            password ="${ssh.myPass}" trust ="true"
            command ="${ssh.scheduleRunLog}" >
         </ sshexec >
     </ target >
     < target name ="查找2008/下Mp3没转128-64文件夹" >
         < sshexec host ="${ssh.host}" username ="${ssh.myName}"
            password ="${ssh.myPass}" trust ="true" command ="${ssh.64k}" >
         </ sshexec >
         < sshexec host ="${ssh.host}" username ="${ssh.myName}"
            password ="${ssh.myPass}" trust ="true" command ="${ssh.128k}" >
         </ sshexec >
         < sshexec host ="${ssh.host}" username ="${ssh.myName}"
            password ="${ssh.myPass}" trust ="true"
            command ="${ssh.128kto64k.err}" >
         </ sshexec >
     </ target >

     < target name ="admin模块测试" >
         < input addproperty ="admin_test_input"
            message ="测试类输入（Video*Test）：" defaultvalue ="*Test" >
         </ input >
         < echo message ="${admin_test_input}" ></ echo >
         < exec executable ="cmd" >
             < arg value ="/c" />
             < arg
                 value ="${basedir}/sh/admin_test.bat ${admin_test_input} " />
         </ exec >
     </ target >
</ project >

posted @ 2008-12-24 16:24 G_G 阅读(6382) | 评论 (3) | 编辑收藏

java gzip (使用，乱码问题已解决！)

public static void main(String[] args) {

try {

String charset = " UTF-8 " ;

String outfile = " d:\\category.20081218.gz " ;

BufferedReader in = new BufferedReader(

new InputStreamReader(

new FileInputStream( " d:\\category.20081218 " ),

charset));

BufferedOutputStream out =

new BufferedOutputStream(

new GZIPOutputStream(

new FileOutputStream(outfile)));

System.out.println( " Writing file " );

String c;

while ((c = in.readLine()) != null )

out.write( (c + " \n " ).getBytes(charset));

in.close();

out.close();

System.out.println( " Reading file " );

BufferedReader in2 =

new BufferedReader(

new InputStreamReader(

new GZIPInputStream(

new FileInputStream(outfile)

),charset

)

);

String s;

while ((s = in2.readLine()) != null )

System.out.println(s);

} catch (Exception e) {

e.printStackTrace();

}

posted @ 2008-12-22 14:35 G_G 阅读(3610) | 评论 (0) | 编辑收藏

jquery 补全使用笔记

官方上下
http://bassistance.de/jquery-plugins/jquery-plugin-autocomplete/

$.补全中文修改
    jquery.autocomplete.js 中
    $input.bind(($.browser.opera ? "keypress" : "keydown")
    改为
    $input.bind(($.browser.opera ? "keypress" : "keyup")

$. 在 localdata.js 》》 var cities = [..
   中放些中文测试吧

测试页面，最简单的使用页面。（应该算是最简单补全测试了）

使用json

posted @ 2008-12-13 09:41 G_G 阅读(1105) | 评论 (1) | 编辑收藏

ajax Form

不要为拼写 ajax url 而郁闷了。希望能对大家有帮助。

/*
    1.form ajax 使用：
    eG: form就是普通的 html form
        <input type="button" value="xx" onclick="formAjax('data.jsp',this.form,ajaxReturn)"/>
        function ajaxReturn(data){
            document.getElementById("div1").innerHTML =  data ;
        }


    2.ajax 使用   ：
    AjaxFunction
        AjaxFunction('url?param=tt&param2=te',function(text){
            alert(text);
        });

    3.迭代器：
    recursiveNodes(array,dom,pushFun,layer)
   array 迭代寄存器
   dom 被迭代对象
       pushFun 自定义收集方法
            pushFun(array,node,layer)
               node 迭代中对象
       layer 深度
    EG:
    var arr = [] ;
    recursiveNodes(arr ,dom,function(array,node,layer){
            arr.push(node);
     },2);


*/
var _request;
try {
    this._request = new XMLHttpRequest();
} catch (e) {
    try {
        this._request = new ActiveXObject('Msxml2.XMLHTTP');
    } catch (e) {
        try {
            this._request = new ActiveXObject('Microsoft.XMLHTTP');
        } catch (e) {
            request = false;
        }
    }
}

var AjaxFunction = function(urls, getAjaxText) {
    AjaxFunction._getAjaxText = null;

    _url = '';
    _params = '';

    AjaxFunction._getAjaxText = getAjaxText;
    var strs = urls.split(/\?/);
    _url = strs[0];
    if (strs.length > 1)
        _params = strs[1];

    _request.open("POST", this._url, true);
    _request.setRequestHeader("Cache-Control", "no-cache");
    _request.setRequestHeader("content-type",
            "application/x-www-form-urlencoded");
    _request.send(_params);
    _request.onreadystatechange = _onComplete;
};
function _onComplete() {
    if (_request.readyState == 4) {
        if (_request.status == 200 || _request.status == 0) {
            if (_request.responseText != null && _request.responseText != ''
                    && _request.responseText != ' ')
                AjaxFunction._getAjaxText(_request.responseText);
        }
    }
}

/*
* 迭代 1. array,dom 2. array,dom,layer
*/
function recursiveNodes(array, dom, pushFun, layer) {
    if (layer == 0)
        return;
    if (layer > 0) {
        --layer;
        if (dom.hasChildNodes && dom.hasChildNodes()) {
            for ( var i = 0; i < dom.childNodes.length; i++) {
                var nodeT = dom.childNodes.item(i);
                if (typeof pushFun == "function")
                    pushFun(array,nodeT, layer);
                else
                    array.push(nodeT);
                recursiveNodes(array, dom.childNodes.item(i), pushFun, layer);
            }
        } else
            return;
    } else if (layer < 0) {
        ++layer;
        var nodeT = dom.parentNode;
        if (nodeT) {
            if (typeof pushFun == "function") {
                pushFun(array,nodeT, layer);
            } else {
                array.push(nodeT);
            }
            recursiveNodes(array, dom.parentNode, pushFun, layer)
        } else
            return;
    }
}

function formAjax(url,ttform,returnFun){
    var datas = [];
    var arr = ['input','select'];
    recursiveNodes(datas,ttform,function(array,node,layer){
        for(var i=0;i<arr.length;i++){
            if( node.getAttribute ){
                var paramName = node.getAttribute('name') ;
                if( /select/i.test( node.nodeName ) ){
                    array.push(paramName+'='+node.options[node.selectedIndex].value);
                }else if( paramName !=null &&  /^\s*(\w+)\s*$/g.test(paramName) && new RegExp(arr[i],'i').test(node.nodeName)  ){
                    array.push(paramName+'='+node.value);
                }
            }
        }
    },999);
    //? ?
    //& &
    var urls = url+'?'+datas.join("&");
    AjaxFunction(urls,returnFun);
}

posted @ 2008-11-09 18:35 G_G 阅读(1811) | 评论 (0) | 编辑收藏

xpath javascript

posted @ 2008-09-24 19:57 G_G 阅读(504) | 评论 (0) | 编辑收藏

2008-9-23 E

Python is a dynamic object-oriented programming language that can be used for many kinds of software development.

It offers strong support for integration with other languages and tools, comes with extensive standard libraries, and can be learned in a few days.
offers 提出
integration 综合
extensive 宽广
standard libraries 标准库

Many Python programmers report substantial productivity gains and feel the language encourages the development of higher quality, more maintainable code.
report 宣告
substantial 实质
productivity 生产力

posted @ 2008-09-23 09:56 G_G 阅读(196) | 评论 (1) | 编辑收藏

create div

直接运行 div_show_drag.rar
http://www.blogjava.net/Files/Good-Game/div_Show_drag.rar

html test

<html>
<head>

<script type="text/javascript" src="showDivUtil.js"></script>

</head>

<body>

<input type="button" id="_in" value="google-baidu" onclick="test();"/>
<div id='_div' />
<script language="javascript">
/*api说明
    ShowDiv（源element , 是否使用现有 div )
        源element,是否使用现有 div 都可为null ;
*/
var ediv = new ShowDiv('_in',null);

function test(){
    if( ! ediv.isShow ){
        // tdiv［X,Y,H,W］准备展现div set->tdiv.X = .. ,
        // tsubEle［X,Y,H,W］
        // 源ele大小位置  ,tscreen［screenH,screenW］屏幕长宽
        ediv.setLocation = function(tdiv,tsubEle,tscreen){
            /*  居中展现
             tdiv.W =200 ;
             tdiv.H = 300 ;
             tdiv.X = tscreen.screenW/2-tdiv.W/2 ;
             tdiv.Y = tscreen.screenH/2-tdiv.H/2 ;
            */

             /*  根据 tsubEle 位置左显示
            tdiv.X = tsubEle.X+tsubEle.W ;
            tdiv.Y = tsubEle.Y ;
             */

              /*  根据 tsubEle 大小  左长条显示
             tdiv.X = tsubEle.X+tsubEle.W ;
             tdiv.Y = tsubEle.Y ;
             */


              /*  根据 tsubEle 大小  下长条显示
             tdiv.X = tsubEle.X+tsubEle.W ;
             tdiv.Y = tsubEle.Y ;
             tdiv.H = 200 ;
             tdiv.W = tsubEle.W ;
             */

            /*

.. 等等自己尝试吧*/
            tdiv.innerHTML = "<li>google</li><li>baidu</li>" ;
            //可以参考
            Drag.init(tdiv);
        }
        ediv.setStyle('background-color:#F4F4F4;');
        ediv.show();
    }else{
        ediv.close();
        //ediv.delete();
    }
}

</script>
</body>
</html>

showDivUtil.js

/*
* Skynet
* 2008-9-15 00:56
*   liukaiyi@gmail.com
*/
function ShowDiv(subEle,ediv){
    //public
    this.style  ;
    this.isShow = false ;

    //private
    this._div  ;
    this._subEle  ;
    this._subEle  ;

        if( typeof ediv == "undefined" || ediv == null)
            this._div=document.createElement("div");
        else if( typeof ediv == "string")
            this._div=document.getElementById(ediv);
        else if(  /object/.test(typeof ediv) )
            this._div= ediv ;

        if( typeof subEle == "string")
            this._subEle=document.getElementById(subEle);
        else if(  /object/.test(typeof subEle) )
            this._subEle= subEle ;

}

    //外置方法 x , y ,w , h , div
    ShowDiv.prototype.setLocation = new Function() ;

    //设置 div 样式
    ShowDiv.prototype.setStyle=function(styleStrOrObj){
        this.style=this._div.style ;
        if( typeof styleStrOrObj == "string"){
            var strs = styleStrOrObj.split(/;/) ;
            for(var i=0;i<strs.length;i++){
                var key = strs[i].split(/:/)[0];
                var value = strs[i].split(/:/)[1];
                var _s = key.indexOf("-") ;
                if( _s>0)
                    key=key.substring(0,_s)+key.substring(_s+1,_s+2).toLocaleUpperCase()+key.substring(_s+2,key.length);
                if( key!=null&&key!=''&&key!=' ' ){
                    eval( 'this._div.style.'+key+'="'+value+'"' );
                }
            }
        }else if(  /object/.test(typeof styleStrOrObj) ) {
            this._div.style = styleStrOrObj ;
        }
        if(this._div.style.position==null || this._div.style.position=="")
            this._div.style.position="absolute";
    }

    ShowDiv.prototype.show=function(){
        if( typeof this._subEle != "undefined" || this._subEle != null){
            this._subEle.Y = getElementPos(this._subEle).y;
            this._subEle.X = getElementPos(this._subEle).x ;
            this._subEle.W = this._subEle.offsetWidth ;
            this._subEle.H = this._subEle.offsetHeight ;
        }
        //this._div.Y = sset
        //this._div.X = sset
        this._div.W = parseInt( this._div.style.width );
        this._div.H = parseInt( this._div.style.height );

        this.setLocation(this._div,this._subEle,{screenW:document.body.clientWidth,screenH:document.body.clientHeight});
        this._div.style.left = this._div.X  ;
        this._div.style.top = this._div.Y ;

        if( this._div.W && this._div.H ){
            this._div.style.width = this._div.W ;
            this._div.style.height = this._div.H ;
        }
        document.body.appendChild(this._div);
        this.isShow = true ;
    }

    ShowDiv.prototype.close=function(){
        document.body.removeChild(this._div);
        this.isShow = false ;
    }

     ShowDiv.prototype.delete=function(){
        document.body.removeChild(this._div);
        this._div = null ;
        this.isShow = false ;
    }

//得到 Element 位置
// 说明：用 Javascript 获取指定页面元素的位置
// 整理：http://www.codebit.cn
// 来源：YUI DOM
function getElementPos(el) {
    var ua = navigator.userAgent.toLowerCase();
    var isOpera = (ua.indexOf('opera') != -1);
    var isIE = (ua.indexOf('msie') != -1 && !isOpera); // not opera spoof
    if(el.parentNode === null || el.style.display == 'none'){
        return false;
    }
    var parent = null;
    var pos = [];
    var box;

    if(el.getBoundingClientRect){
    // IE
        box = el.getBoundingClientRect();
        var scrollTop = Math.max(document.documentElement.scrollTop, document.body.scrollTop);
        var scrollLeft = Math.max(document.documentElement.scrollLeft, document.body.scrollLeft);
        return {x:box.left + scrollLeft, y:box.top + scrollTop};
    }else if(document.getBoxObjectFor){
     // gecko
        box = document.getBoxObjectFor(el);
        var borderLeft = (el.style.borderLeftWidth)?parseInt(el.style.borderLeftWidth):0;
        var borderTop = (el.style.borderTopWidth)?parseInt(el.style.borderTopWidth):0;
        pos = [box.x - borderLeft, box.y - borderTop];
    }else {
     // safari & opera
        pos = [el.offsetLeft, el.offsetTop];
        parent = el.offsetParent;
        if (parent != el) {
            while (parent) {
                pos[0] += parent.offsetLeft;
                pos[1] += parent.offsetTop;
                parent = parent.offsetParent;
            }
        }
         if (ua.indexOf('opera') != -1|| ( ua.indexOf('safari') != -1 && el.style.position == 'absolute' )){
            pos[0] -= document.body.offsetLeft;
            pos[1] -= document.body.offsetTop;
        }
    }

    if (el.parentNode) { parent = el.parentNode; }
    else { parent = null; }

    // account for any scrolled ancestors
     while (parent && parent.tagName != 'BODY' && parent.tagName != 'HTML'){
        pos[0] -= parent.scrollLeft;
        pos[1] -= parent.scrollTop;
        if (parent.parentNode) { parent = parent.parentNode; }
        else { parent = null; }
    }
    return {x:pos[0], y:pos[1]};
}

posted @ 2008-09-15 01:02 G_G 阅读(434) | 评论 (0) | 编辑收藏

dom-drag.js 拖拽学习

上面加上我的注解（希望能对大家理解有帮助）：

/**************************************************
* dom-drag.js
* 09.25.2001
* www.youngpup.net
* Script featured on Dynamic Drive (http://www.dynamicdrive.com) 12.08.2005
**************************************************
* 10.28.2001 - fixed minor bug where events
* sometimes fired off the handle, not the root.
   *    注解:  Skynet
*    email : liukaiyi@gmail.com
*        blog : www.blogjava.net/Good-Game
**************************************************/

var Drag = {

    obj : null,

    /* api 说明：
    *     方法调用可以参考：http://www.dynamicdrive.com/dynamicindex11/domdrag/
    *         o 拖拽 Handle
    *        oRoot 被拖拽 element  (可选, 默认不填 o为被拖拽对象  type=object)
    *        minX, maxX, minY, maxY 限制拖拽范围 (可选,默认不填为全屏 type=int )
    *         bSwapHorzRef, bSwapVertRef 判断是否允许横，纵向拖拽(可选,默认不填无限制 type=boolean )
    *     fXMapper(x), fYMapper(y)  为外置函数拖拽效果体现前调用 (x,y) 为当前element位置(可选 type=Function）
    */
    init : function(o, oRoot, minX, maxX, minY, maxY, bSwapHorzRef, bSwapVertRef, fXMapper, fYMapper)
    {
        /* 拖拽事件挂载  (本js 主线生命周期描述)
        *    1. 预定 o.onmousedown事件触发运行  Drag.start。
        *    2. 触发 element-> onmousedown->Drag.start
        *        2.1    先得到 element 当前"改变初"位置,记入到 o.lastMouseX ;o.lastMouseY，挂载Drag.obj,Darp.root 为当前 element。
        *        2.2     预定 document.onmousemove    = Drag.drag; document.onmouseup = Drag.end。
        *    3.  触发 document.onmousemove 运行 Drag.drag-> 拖拽效果体现。
        *    4.  触发 document.onmouseup 运行 Drag.end-> 挂载 document.onmousemove;document.onmouseup;Drag.obj取消。
        */
        o.onmousedown = Drag.start;

        //是否能横，纵向拖拽
        o.hmode            = bSwapHorzRef ? false : true ;
        o.vmode            = bSwapVertRef ? false : true ;
        //挂载 o.root
        o.root = oRoot && oRoot != null ? oRoot : o ;

        if (o.hmode  && isNaN(parseInt(o.root.style.left  ))) o.root.style.left   = "0px";
        if (o.vmode  && isNaN(parseInt(o.root.style.top   ))) o.root.style.top    = "0px";
        if (!o.hmode && isNaN(parseInt(o.root.style.right ))) o.root.style.right  = "0px";
        if (!o.vmode && isNaN(parseInt(o.root.style.bottom))) o.root.style.bottom = "0px";

        // 限定移动范围
        o.minX    = typeof minX != 'undefined' ? minX : null;
        o.minY    = typeof minY != 'undefined' ? minY : null;
        o.maxX    = typeof maxX != 'undefined' ? maxX : null;
        o.maxY    = typeof maxY != 'undefined' ? maxY : null;

        o.xMapper = fXMapper ? fXMapper : null;
        o.yMapper = fYMapper ? fYMapper : null;

        /*自定义拖拽－事件添加（相当于我们在java中的抽象类中未实现的方法  比如：
        *    obj.onDrag = function(x, y) {
         *        scrolldiv.style.top=y * (-1) +"px";
        *    }
        */
        o.root.onDragStart    = new Function();
        o.root.onDragEnd    = new Function();
        o.root.onDrag        = new Function();
    },

    //由 function init >> o.onmousedown    = Drag.start;
    start : function(e)
    {
        //得到被拖拽 element
        var o = Drag.obj = this;
        e = Drag.fixE(e);

        //element 移动初位置
        var y = parseInt(o.vmode ? o.root.style.top  : o.root.style.bottom);
        var x = parseInt(o.hmode ? o.root.style.left : o.root.style.right );
        //可能的外置函数调用
        o.root.onDragStart(x, y);
        //event 初位置记入
        o.lastMouseX    = e.clientX;
        o.lastMouseY    = e.clientY;

        if (o.hmode) {
            if (o.minX != null)    o.minMouseX    = e.clientX - x + o.minX;
            if (o.maxX != null)    o.maxMouseX    = o.minMouseX + o.maxX - o.minX;
        } else {
            if (o.minX != null) o.maxMouseX = -o.minX + e.clientX + x;
            if (o.maxX != null) o.minMouseX = -o.maxX + e.clientX + x;
        }

        if (o.vmode) {
            if (o.minY != null)    o.minMouseY    = e.clientY - y + o.minY;
            if (o.maxY != null)    o.maxMouseY    = o.minMouseY + o.maxY - o.minY;
        } else {
            if (o.minY != null) o.maxMouseY = -o.minY + e.clientY + y;
            if (o.maxY != null) o.minMouseY = -o.maxY + e.clientY + y;
        }

        /*>>>>>>>>>>>比较关键的挂载<<<<<<<<<<<<<<
        *
        *    使用 document.onmousemove 事件而不使用 element的，是应为当拖动太快，可能会脱离element.
        */
        document.onmousemove    = Drag.drag;
        document.onmouseup        = Drag.end;

        return false;
    },

    //由 function start>> document.onmousemove    = Drag.drag;
    drag : function(e)
    {
        e = Drag.fixE(e);
        var o = Drag.obj;

        var ey    = e.clientY;
        var ex    = e.clientX;
        //得到 element 当前位置（vmode,hmode判断是否可以横纵向拖拽）
        var y = parseInt(o.vmode ? o.root.style.top  : o.root.style.bottom);
        var x = parseInt(o.hmode ? o.root.style.left : o.root.style.right );
        var nx, ny;

        if (o.minX != null) ex = o.hmode ? Math.max(ex, o.minMouseX) : Math.min(ex, o.maxMouseX);
        if (o.maxX != null) ex = o.hmode ? Math.min(ex, o.maxMouseX) : Math.max(ex, o.minMouseX);
        if (o.minY != null) ey = o.vmode ? Math.max(ey, o.minMouseY) : Math.min(ey, o.maxMouseY);
        if (o.maxY != null) ey = o.vmode ? Math.min(ey, o.maxMouseY) : Math.max(ey, o.minMouseY);

        //本js中最主要的地方：
        //得到鼠标移动向量 drap(x,y) = fun_drap:event(x,y) - fun_start:event(x,y)
        //并于得到拖拽效果:  element(x,y) + drap(x,y)
        nx = x + ((ex - o.lastMouseX) * (o.hmode ? 1 : -1));
        ny = y + ((ey - o.lastMouseY) * (o.vmode ? 1 : -1));

        if (o.xMapper)        nx = o.xMapper(y)
        else if (o.yMapper)    ny = o.yMapper(x)

        //效果体现
        Drag.obj.root.style[o.hmode ? "left" : "right"] = nx + "px";
        Drag.obj.root.style[o.vmode ? "top" : "bottom"] = ny + "px";
        Drag.obj.lastMouseX    = ex;
        Drag.obj.lastMouseY    = ey;
        //调用外置函数
        Drag.obj.root.onDrag(nx, ny);
        return false;
    },

    //由 function start>> document.onmouseup        = Drag.end;
    end : function()
    {
        document.onmousemove = null;
        document.onmouseup   = null;
        Drag.obj.root.onDragEnd(    parseInt(Drag.obj.root.style[Drag.obj.hmode ? "left" : "right"]),
                                    parseInt(Drag.obj.root.style[Drag.obj.vmode ? "top" : "bottom"]));
        Drag.obj = null;
    },

    //跨浏览器得到 event
    fixE : function(e)
    {
        if (typeof e == 'undefined') e = window.event;
        if (typeof e.layerX == 'undefined') e.layerX = e.offsetX;
        if (typeof e.layerY == 'undefined') e.layerY = e.offsetY;
        return e;
    }
};

posted @ 2008-09-14 11:28 G_G 阅读(2676) | 评论 (0) | 编辑收藏

struts2 ognl

参考：
http://neil-jh.javaeye.com/blog/199345

效果：

google

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib uri="/struts-tags" prefix="s"%>
<%@taglib uri="http://java.sun.com/jstl/core_rt" prefix="c"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<li>
    
    <s:property value="%{@action.SsdAction@GOOD}"/>

    
      <s:set name="num" value="20" />
    <s:set name="listData" value="%{ ssdMethod.getBeans(#num)  }" />

    
    <select>
        <c:forEach var="btmp" items="${listData}">
            <option value="${btmp.id} }">${btmp.name}</option>
        </c:forEach>
    </select>

    <!-- 调用枚举类
        public enum Type {
            //id value : gget sset
            g1(1,"test1"),
            g2(2,"test2"),
            g3(3,"test3");

.
    -->
    <s:select list="%{ @myEnum.Type@values() }" listKey="id" listValue="value" />

    
    <s:select list="%{ @myEnum.Type@values().{?#this.id>2 } }" listKey="id" listValue="value" />

</li>

</body>
</html>

posted @ 2008-09-11 16:04 G_G 阅读(432) | 评论 (0) | 编辑收藏

e 学习

haptic 触觉
   --of or relating to the sensation of touch.
   －－关于             触动                         感觉。

                   haptics is the science of applying tactile sensation to humen interaction with computers .
字面翻译：触觉论   是一种科学    申请         触觉                   与人类       互动            和       电脑
                ：触觉论是将人类的接触感觉应用与计算机连接的一门科学。

       A haptic device is one that involves physical contact between the computer and the user .
》》一个触觉设备            是一个         涉及      物理        连接       在                   电脑             和    人
》》一个触觉设备包含计算机和用户之间的物理连接

     usually through an input/output device,such as a joystick or   data gloves ,that senses the body,s movements.
》》通常     通过         一个输入/输出设备，比如一个操纵杆或    数据手套，这些设备    感觉   身体的移动。

posted @ 2008-09-10 23:14 G_G 阅读(164) | 评论 (0) | 编辑收藏

google proto buffer 使用（java）

主页：http://code.google.com/apis/protocolbuffers/docs/overview.html

testProto.proto

package foo.bar;
option java_package = "com.proto";

message Person {
  required string name = 1;
  required int32 id = 2;
  optional string email = 3;

  enum PhoneType {
    MOBILE = 0;
    HOME = 1;
    WORK = 2;
  }

  message PhoneNumber {
    required string number = 1;
    optional PhoneType type = 2 [default = HOME];
  }

  repeated PhoneNumber phone = 4;
}

运行命令
'/home/kaiyi/proto/bin/protoc' --java_out=src testProto.proto

使用( 本类可用，builder 可改，开用但 list 删除要使用比较郁闷的方法删除！)

package unit;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.Collections;
import java.util.List;

import com.google.protobuf.InvalidProtocolBufferException;
import com.proto.TestProto;
import com.proto.TestProto.Person;
import com.proto.TestProto.Person.PhoneNumber;

public class Main {
    public static void main(String[] args) throws InvalidProtocolBufferException {
        //空创建
        Person.Builder builder = Person.newBuilder();
        builder.setName("liukaiyi");
        builder.setId(1);

        builder.setEmail("email");

        PhoneNumber.Builder pBuilder1 = PhoneNumber.newBuilder();
        pBuilder1.setNumber("1");
        pBuilder1.setType(TestProto.Person.PhoneType.MOBILE);


        PhoneNumber.Builder pBuilder2 = PhoneNumber.newBuilder();
        pBuilder2.setNumber("2");
        pBuilder2.setType(TestProto.Person.PhoneType.HOME);



        builder.addPhone(pBuilder1);
        builder.addPhone(pBuilder2);

//此处为存储到数据库或传输！
byte[] data = builder.build().toByteArray() ;
        for(byte tb : data )
            System.out.print( (char)tb );


        //组建
        Person person = Person.parseFrom(data);
        Person.Builder builder2 = Person.newBuilder(person);
        builder2.setEmail("test");

        PhoneNumber.Builder pBuilder3 = PhoneNumber.newBuilder();
        pBuilder3.setNumber("3");
        pBuilder3.setType(TestProto.Person.PhoneType.HOME);
        builder2.addPhone(pBuilder3);

//这我最不明白的地方， list 这只能使用这种方法才可以删除 list ????
        List list = new ArrayList(builder2.getPhoneList());
        List<PhoneNumber> ltmp = builder2.getPhoneList() ;
        for(int i=0;i<list.size();i++ ){
            if(ltmp.get(i).getNumber().equals("2"))
                list.remove( ltmp.get(i) ) ;
        }
        builder2.clearPhone().addAllPhone(list);
        builder2.clearEmail();

        System.out.println(list.size());
        System.out.println();
        byte[] data2 = builder2.build().toByteArray() ;
        for(byte tb : data2 )
            System.out.print( (char)tb );




    }
}

posted @ 2008-09-08 17:01 G_G 阅读(2756) | 评论 (0) | 编辑收藏

javascript ajax

<? xml version="1.0" encoding="utf8" ?>
<% @ page language = " java " contentType = " text/html; charset=utf8 " pageEncoding = " utf8 " %>
<% @taglib uri = " /WEB-INF/struts-tags.tld " prefix = " s " %>
<% @taglib uri = " /WEB-INF/ljw.tld " prefix = " ljw " %>


<% @page import = " com.ljw.bean.CorrectionWrong " %>
<% @page import = " com.ljw.bean.CorrectionWrong.State " %>
<% @page import = " com.opensymphony.xwork2.util.ValueStack " %> < html xmlns ="http://www.w3.org/1999/xhtml" >
< head >
< meta http-equiv ="Content-Type" content ="text/html; charset=utf8" />
< title > Insert title here </ title >
< script type ="text/javascript" src ="../js/prototype.js" ></ script >
< script type ="text/javascript" src ="../js/jsMsg.jsp" ></ script >
< script type ="text/javascript" src ="../js/comm.js" ></ script >
< SCRIPT language =JavaScript src ="../js/supertable/dialog.js" type =Text/JavaScript ></ SCRIPT >
</ head >
< body >
< div id ="communityDiv" >
< s:set name ="" ></ s:set >
< s:iterator id ="d" value ="%{pageList.objectList}" >
    用户名字： < s:property value ="#d.userInfo.userName" />< br >
    url： < s:property value ="#d.url" />< br >
    状态： < s:property value ="#d.ecwState.value" />< br >
    纠错： < s:property value ="#d.cwArticle" /></ br >
    编辑输入： < textarea rows ="10" cols ="50" id ='<s:property value ="#d.id" /> ' > < s:property value ="#d.boardmasterDesc" /></ textarea >
     < input type ="button" onclick ="getUpdate('<s:property value=" #d.id" /> ')"/>
< hr />
</ s:iterator >
< br />
< ljw:pages value ="%{pageList.pages}" javaScript ="loadCommunityListUrl" />
</ div >
</ body >
< script type ="text/javascript" >
function loadCommunityListUrl(url) {
     $('communityDiv').innerHTML = pageLoadingCenter;
       var urls = getActionName(url);
       var pars = getActionPars(url);
       var myAjax = new Ajax.Updater( " communityDiv " , urls, {method: 'post', parameters: pars});
    }
var request = false ;
try {
  request = new XMLHttpRequest();
} catch (trymicrosoft) {
   try {
    request = new ActiveXObject( " Msxml2.XMLHTTP " );
  } catch (othermicrosoft) {
     try {
      request = new ActiveXObject( " Microsoft.XMLHTTP " );
    } catch (failed) {
      request = false ;
    }
  }
}
if ( ! request)
  alert( " Error initializing XMLHttpRequest! " );

var _robj = null ;
function getUpdate(ki) {
  _robj = document.getElementById(ki) ;
   var urls = 'cwmain. do ';
   var pars = 'c = ajaxUpdateByBoardMaster & cwId = ' + ki + ' & boardMasterDesc = ' + _robj.value ;
  request.open( " POST " , urls, true );
  request.setRequestHeader( " Cache-Control " , " no-cache " );
  request.setRequestHeader( " content-type " , " application/x-www-form-urlencoded " );
  request.send(pars);
  request.onreadystatechange = updatePage;
}

function updatePage() {
     if (request.readyState == 4 ) {
         if (request.status == 200 || request.status == 0 ) {
            alert(request.responseText);
            eval(' var ajaxData = ' + request.responseText);
             if ( ajaxData.isUpdate ){
                 alert( '更新成功！' );
            } else {
                alert( '更新不成功！' );
            }
        }
    }
}

</ script >
</ html >

posted @ 2008-08-16 18:15 G_G 阅读(568) | 评论 (2) | 编辑收藏

js 拖动

< html >
< head >< title > 拖动效果函数演示 by Longbill.cn </ title >
< style >

div
{
    position : absolute ;
    background-color : #c3d9ff ;
    margin : 0px ;
    padding : 5px ;
    border : 0px ;
    width : 100px ;
    height : 100px ;
}
</ style >

</ head >
< body >


< script >
function drag(o,s)
{
     if ( typeof o == " string " ) o = document.getElementById(o);
    o.orig_x = parseInt(o.style.left) - document.body.scrollLeft;
    o.orig_y = parseInt(o.style.top) - document.body.scrollTop;
    o.orig_index = o.style.zIndex;

    o.onmousedown = function (a)
    {
         this .style.cursor = " move " ;
         this .style.zIndex = 10000 ;
         var d = document;
         if ( ! a)a = window.event;
         var x = a.clientX + d.body.scrollLeft - o.offsetLeft;
         var y = a.clientY + d.body.scrollTop - o.offsetTop;
         // author: www.longbill.cn
        d.ondragstart = " return false; "
        d.onselectstart = " return false; "
        d.onselect = " document.selection.empty(); "

         if (o.setCapture)
            o.setCapture();
         else if (window.captureEvents)
            window.captureEvents(Event.MOUSEMOVE | Event.MOUSEUP);

        d.onmousemove = function (a)
        {
             if ( ! a)a = window.event;
            o.style.left = a.clientX + document.body.scrollLeft - x;
            o.style.top = a.clientY + document.body.scrollTop - y;
            o.orig_x = parseInt(o.style.left) - document.body.scrollLeft;
            o.orig_y = parseInt(o.style.top) - document.body.scrollTop;
        }

        d.onmouseup = function ()
        {
             if (o.releaseCapture)
                o.releaseCapture();
             else if (window.captureEvents)
                window.captureEvents(Event.MOUSEMOVE | Event.MOUSEUP);
            d.onmousemove = null ;
            d.onmouseup = null ;
            d.ondragstart = null ;
            d.onselectstart = null ;
            d.onselect = null ;
            o.style.cursor = " normal " ;
            o.style.zIndex = o.orig_index;
        }
    }

     if (s)
    {
         var orig_scroll = window.onscroll ? window.onscroll: function (){};
        window.onscroll = function ()
        {
            orig_scroll();
            o.style.left = o.orig_x + document.body.scrollLeft;
            o.style.top = o.orig_y + document.body.scrollTop;
        }
    }
}
</ script >

< div id ="div1" style ="left:10px;top:10px;" > div1:我可以被拖动 </ div >
< div id ="div2" style ="left:120px;top:10px;background-color : #f3d9ff" > div2:来拖我呀 </ div >
< div id ="div3" style ="left:230px;top:10px;background-color : #c3ffff" > div3:我随便你拖 </ div >
< div id ="div4" style ="left:10px;top:120px;background-color : #c3d944" > div4:我可以随窗口滑动，把我拖到最下面，然后滚动网页看看 </ div >
< div id ="div5" style ="left:120px;top:120px;background-color : #f3d944" > 作者: Longbill
< a href =http://www.longbill.cn target =_blank > www.longbill.cn </ a >
</ div >
< div id ="div6" style ="left:230px;top:120px;background-color : #e3f944;width:200px;" > 参数说明:

drag(obj [,scroll]);

obj:对象的id或对象本身;

scroll(可选):对象是否随窗口拖动而滑动，默认为否

鼠标右键查看源代码
</ div >

< script >
drag( " div1 " );
drag( " div2 " );
drag( " div3 " );
drag( " div4 " , 1 );
drag( " div5 " , 1 );
drag( " div6 " , 1 );

</ script >

</ body >

posted @ 2008-08-16 17:22 G_G 阅读(319) | 评论 (0) | 编辑收藏

ajax javascript 弹出框

demo 下载： http://www.blogjava.net/Files/Good-Game/div_.rar
运行 div.html

html:

js.

// 参考： http://hi.baidu.com/foxlively/blog/item/0ce341b3f0c050a2d8335af8.html
// 使用： prototype.js
//使用方法
var _div1 = null;
var _style2 = null;

function getDrag(event, url,divId, style1, style2) {

    if (style2)
        _style2 = style2;
    else
        _style2 = "";

    if(divId==null)
        _div1 = document.createElement("div");
    else
        _div1 = document.getElementById(divId);

    _div1.style.position = 'absolute';
    _div1.style.display = 'none';

    if (_div1.style.border == null || _div1.style.border == '')
        _div1.style.border = '1px solid #284860';

    if (style1)
        _div1.setAttribute('style', style1);
    actionAjax(url);
    document.body.appendChild(_div1);
    showByEvent(event, _div1);
}

function getActionName(url) {
    var question = url.indexOf("?");
    if (question > 0) {
        return url.substring(0, question);
    }
    else {
        return url;
    }
}

function getActionPars(url) {
    var question = url.indexOf("?");
    if (question > 0) {
        return url.substring(question+1, url.length);
    }
    else {
        var d = new Date();
        var t = d.getTime();
        return "timestamp="+t;
    }
}

function actionAjax(url) {
    var urls = getActionName(url);
    var pars = getActionPars(url);
    var myAjax = new Ajax.Updater(_div1, urls, {
        method :'post',
        parameters :pars,
        onComplete :_action
    });
}

function _action(req) {
    var varhtml = "<div id=\"_drag_div\" style=\""
            + _style2
            + "\" align=\"right\"><br/><a href=\"javascript:;\" onclick=\"this.parentNode.parentNode.style.display='none';this.parentNode.parentNode.innerHTML=null;\">[关闭]</a></div>"
            + req.responseText
            +"<div id=\"_drag_div\" style=\""
            + _style2
            + "\" align=\"left\"><br/><a href=\"javascript:;\" onclick=\"this.parentNode.parentNode.style.display='none';this.parentNode.parentNode.innerHTML=null;\">[关闭]</a></div>"
            ;
    //varhtml =  varhtml.replace(/form[ ]+action=["'](.*)["']/gi, "form action=\"javascript:actionAjax('$1');\" ")  ;

    _div1.innerHTML = varhtml;
    var drag = new Drag();
    // drag.build(div1);//拖动本身
    drag.build(_div1, _div1.firstChild);// 通过一个对象拖动另一个对象
    //drag.build(_div1, _div1.lastChild);// 通过一个对象拖动另一个对象
}

function showByEvent(event, useDiv) {
    useDiv.style.display = "";
    useDiv.style.left = mouseX(event);
    useDiv.style.top = mouseY(event);
}

function mouseX(ev) {
    if( ev == null )ev = event || window.event ;
    if(ev.clientX){
        return ev.clientX + document.body.scrollLeft - document.body.clientLeft;
    }else if(ev.pageX){
        return ev.pageX;
    }
}
function mouseY(ev) {
    if( ev == null )ev = event || window.event ;
    if(ev.clientY){
        return ev.clientY + document.body.scrollTop - document.body.clientTop ;
    }else if(ev.pageX){
        return ev.pageY;
    }
}

function Drag() {
}
Drag.prototype.baseX = 0;
Drag.prototype.baseY = 0;
Drag.prototype.lastX = 0;
Drag.prototype.lastY = 0;
Drag.prototype.nowX = 0;
Drag.prototype.nowY = 0;
Drag.prototype.obD = null;
Drag.prototype.obM = null;
Drag.prototype.build = function(_obD, _obM) {
    if (_obM) {
        Drag.prototype.obM = _obM;
    } else {
        Drag.prototype.obM = _obD;
    }
    Drag.prototype.obD = _obD;
    Drag.prototype.obM.onmousedown = function(event) {
        Drag.prototype.lastX = mouseX(event);
        Drag.prototype.lastY = mouseY(event);
        Drag.prototype.baseX = Drag.prototype.obD.style.left;
        Drag.prototype.baseY = Drag.prototype.obD.style.top;
        this.onmousemove = function(event) {
            Drag.prototype.nowX = mouseX(event);
            Drag.prototype.nowY = mouseY(event);
            Drag.prototype.obD.style.left = (parseFloat(Drag.prototype.baseX)
                    + Drag.prototype.nowX - Drag.prototype.lastX)
                    + "px";
            Drag.prototype.obD.style.top = (parseFloat(Drag.prototype.baseY)
                    + Drag.prototype.nowY - Drag.prototype.lastY)
                    + "px";
        }
    }
    Drag.prototype.obM.onmouseup = function(event) {
        // obD.onmouseup = null;
        Drag.prototype.obD.onmousemove = null;
        Drag.prototype.obM.onmousemove = null;
    }
    Drag.prototype.obM.onmouseout = function() {
        // obM.onmouseup = null
        Drag.prototype.obM.onmousemove = null;
        Drag.prototype.obD.onmousemove = null;
    }
}

posted @ 2008-08-14 14:11 G_G 阅读(1517) | 评论 (1) | 编辑收藏

部分高级查询 sql 拼写笔记（mysql）

参考：http://www.programbbs.com/bbs/view25-12320-1.htm
但上面的一些sql语句，有查询时间问题，在此我已于改正了并希望和大家分享。

---------自我感觉第四题很不错！-------------

----------------------------------------------------------------------
第一题(只要重复的都要输出)
----------------------------------------------------------------------

create table c (id int );
insert into c values (1),(2),(3),(4),(3),(5),(6),(1);
结果:
select id from c group by id having count(id)>1 ;

附加（查询重复最多的倒排）

select bid,count(bid) as cu from tb group by bid having count(bid)>1 order by cu desc

----------------------------------------------------------------------
第二题(报表查询横向输出)
查询后的结果：
Create table d(id int,name varchar(50));
insert into d values(1,'gly');
insert into d values(2,'ptgly');
insert into d values(3,'ybgly');
insert into d values(4,'ptgly');
insert into d values(5,'ybgly');
+---+-----+------+
|gly|ptgly|ybgly |
|---+-----+------+-
|1 |2 |2 |
+---+-----+------+
-----------------------------------------------------------------------

select
    sum(case when name='gly' then 1 else 0 end ) as gly  ,
    sum(case when name='ptgly' then 1 else 0 end ) as ptgly  ,
    sum(case when name='ybgly' then 1 else 0 end ) as ybgly
from d ;

第三题
可以根据上面 2,4 可以得出。
下面我们详细说下 4题。

-----------------------------------------------------------------------
第四题（复杂组合查询！）
create table table_a (No int, No2 int,num double,itime date);
insert into table_a values
     (1234,567890,33.5,'2004-12-21'),
     (1234,598701,44.8,'2004-11-21'),
     (1234,598701,45.2,'2004-10-01'),
     (1234,567890,66.5,'2004-9-21'),
     (3456,789065,22.5,'2004-10-01'),
     (3456,789065,77.5,'2004-10-27'),
     (3456,678901,48.5,'2004-12-21');
按月统计销售表中货物的销售量数
查询结果如下：
No， No2 ，   九月，　十月，十一月，十二月
1234，567890， 66.5 ，　 0 ，　0 ， 33.5
1234，598701， 0   ，　45.2，　44.8，　0
3456，789065，　0 ，　 100，　0 ，　 0
3456，678901，　0　，    0，    0 ， 48.5
-----------------------------------------------------------------------

//当然也可以使用mysql 时间函数在软件编辑时你可以输入 String[] 并根据数据动态拼写 sql( case部分！！ )
//这个例子很好哦！报表可以一句sql 得出！
select NO,NO2,
    sum(case  when itime like '2004-%9%' then num else 0 end) as 9M,
    sum(case  when itime like '2004-10%' then num else 0 end) as 10M,
    sum(case  when itime like '2004-11%' then num else 0 end) as 11M,
    sum(case  when itime like '2004-12%' then num else 0 end) as 12M
from table_a group by no,no2 order by no,no2 ;

--------------------------------------------------------------
第五题
代码,名称
1     a
2     b
11    c
(代码11表示为1的下级)
我要通过一条句子,得出如下结果:

代码,名称,有无下级
1     a     有
2     b     无
11    c     无

Create table TabTest(t_Code varchar(10),t_Name varchar(10));
insert into TabTest values('1','a');
insert into TabTest values('2','b');
insert into TabTest values('11','c');
--------------------------------------------------------------

select tt1.t_Code,tt1.t_name,(
     case
             when exists (select 1 from tabtest tt2
                                        where tt2.t_code like CONCAT(tt1.t_code,'%') and
                                        tt2.t_code <> tt1.t_code )  then 'you'
             else 'wu'
      end ) as you_wu
from tabtest  tt1 ;

posted @ 2008-08-09 22:00 G_G 阅读(3468) | 评论 (9) | 编辑收藏

pager-taglib 分页使用

官方 http://jsptags.com/tags/navigation/pager/index.jsp

先向 demo 页面样式：
########################################################################################
request.getParameter 中参数
'pager.offset'=6
分页中标签中隐含属性 'offset'=6
|< <<1 234 5 6 7 >>>|

7
8
9

|< <<1 234 5 6 7 >>>|
#######################################################################################

<%@ page session="false" %>
<%@ taglib uri="http://jsptags.com/tags/navigation/pager" prefix="pg" %>
<%@ page contentType="text/html; charset=gb2312"%>
<html>
<head>
<title>Pager Tag Library Demo</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">


request.getParameter 中参数<br/>
<%for(Object otmp : request.getParameterMap().keySet() ){%>
    <%="'"+otmp.toString()+"'"%>=<%=request.getParameter(otmp.toString())%><br\>
<%}%>



<form action="<%= request.getRequestURI() %>" method="get">
<br/>


<pg:pager
    items="<%= webPalette.length %>"
    index="<%= "center" %>"
    maxPageItems="<%= 3 %>"
    maxIndexPages="<%= 10 %>"
    isOffset="<%= true %>"
    export="offset,currentPageNumber=pageNumber"
    scope="request">

<br/>分页中标签中隐含属性 'offset'=<%=offset%><br/>

  
  <pg:param name="google"/>


<pg:index>
  <jsp:include page="/WEB-INF/jsp/texticon.jsp" flush="true"/>
</pg:index>

<hr>
<table width="90%" cellspacing="4" cellpadding="4">
    <%for (int i = offset.intValue(),l = Math.min(i + 10, webPalette.length);i < l; i++){%>
        <pg:item>
            <tr><th bgcolor="<%= webPalette[i][0] %>"><font color="<%= webPalette[i][1] %>"><%= i + 1 %></font></th></tr>
        </pg:item>
    <%}%>
</table>
<hr>

<pg:index>
  <jsp:include page="/WEB-INF/jsp/texticon.jsp" flush="true"/>
</pg:index>

</pg:pager>
</center>
</body>
</html>

<%!
private static final String BLACK = "#000000", WHITE = "#ffffff";
private static final String[][] webPalette = {
    { WHITE,   BLACK},
    {"#cccccc",BLACK},
    {"#999999",BLACK},
    {"#666666",WHITE},
    {"#333333",WHITE},
    { BLACK,   WHITE},
    {"#ffcc00",BLACK},
    {"#ff9900",BLACK},
    {"#ff6600",BLACK},
    {"#ff3300",WHITE},
    {"#99cc00",BLACK},
    {"#cc9900",BLACK},
    {"#ffcc33",BLACK},
    {"#ffcc66",BLACK},
    {"#ff9966",BLACK},
    {"#ff6633",BLACK},
    {"#cc3300",WHITE},
    {"#cc0033",WHITE},
    {"#ccff00",BLACK},
    {"#ccff33",BLACK},
    {"#333300",WHITE}
};

private static final String getParam(ServletRequest request, String name,
    String defval)
{
    String param = request.getParameter(name);
    return (param != null ? param : defval);
}

private static final int getParam(ServletRequest request, String name,
    int defval)
{
    String param = request.getParameter(name);
    int value = defval;
    if (param != null) {
    try { value = Integer.parseInt(param); }
    catch (NumberFormatException ignore) { }
    }
    return value;
}

%>

<%@ page session="false" %>
<%@ taglib uri="http://jsptags.com/tags/navigation/pager" prefix="pg" %>

<jsp:useBean id="currentPageNumber" type="java.lang.Integer" scope="request"/>

<font face="fixed">


<pg:first export="firstPageUrl=pageUrl" unless="current">
  <a href="<%= firstPageUrl %>"> |< </a>
</pg:first>


<pg:skip export="skipBackPageUrl=pageUrl" pages="<%= -10 %>">
  <a href="<%= skipBackPageUrl %>"><<<</a>
</pg:skip>


<pg:prev export="prevPageUrl=pageUrl">
  <a href="<%= prevPageUrl %>"><<</a>
</pg:prev>


<pg:pages><%
  if (pageNumber == currentPageNumber) {
    %> <b><%= pageNumber %></b> <%
  } else {
    %> <a href="<%= pageUrl %>"><%= pageNumber %></a> <%
  }
%></pg:pages>


<pg:next export="nextPageUrl=pageUrl">
  <a href="<%= nextPageUrl %>">>></a>
</pg:next>


<pg:skip export="skipForwardPageUrl=pageUrl" pages="<%= 10 %>">
  <a href="<%= skipForwardPageUrl %>">>>></a>
</pg:skip>


<pg:last export="lastPageUrl=pageUrl" unless="current">
  <a href="<%= lastPageUrl %>">>|</a>
</pg:last>

</font>

posted @ 2008-08-07 14:32 G_G 阅读(2960) | 评论 (0) | 编辑收藏

display 分页

-> http://displaytag.sourceforge.net
分页流程描述：
1.组合查询参数得取。
比如时间范围，用户名模糊查询。。这些存入 session->data;name
2.通过持久层得到 ‘数据总条数’‘当前展现页数据’；
3.分页点击；根据session 组合参数，再次向数据库申请书及。

代码：

<jsp:root version="1.2" xmlns:jsp="http://java.sun.com/JSP/Page"
    xmlns:display="urn:jsptld:http://displaytag.sf.net">
    <jsp:directive.page import="java.util.regex.Pattern" />
    <jsp:directive.page import="test.Bean" />
    <jsp:directive.page import="java.util.ArrayList" />
    <jsp:directive.page import="java.util.List" />
    <jsp:directive.page contentType="text/html; charset=UTF-8" />
    <jsp:include page="inc/header.jsp" flush="true" />

<jsp:scriptlet> <![CDATA[

    Pattern pattern = Pattern.compile("d-[0-9]+-p");
    String pageIndexName = null ;
    for(Object otmp : request.getParameterMap().keySet() ){
        if( pattern.matcher(otmp.toString()).find() ){
            pageIndexName = otmp.toString();
            break;
        }
    }


    int pageSize = 10;   //每页显示的条数
    int pageIndex = 0 ;
    if(pageIndexName!=null){
        pageIndex = (request.getParameter(pageIndexName)==null)?
                0:(Integer.parseInt(request.getParameter(pageIndexName)) - 1);  //当前页数
    }


     List list = new ArrayList();
     for(int i=0;i<pageSize;i++){
         list.add( new Bean(pageIndex*10+i,"liu-"+pageIndex*10+i)  );
     }
    request.setAttribute("data",list);
    session.setAttribute( "resultSize", 100 );
    out.print("!"+pageIndexName);

    ]]></jsp:scriptlet>

    <h2>数据分页展现开始</h2>
    <display:table name="data" pagesize="10" partialList="true"
        size="sessionScope.resultSize">
        <display:column property="id" title="ID"></display:column>
        <display:column property="name" title="名字"></display:column>
    </display:table>


    <jsp:include page="inc/footer.jsp" flush="true" />

</jsp:root>

posted @ 2008-08-06 22:28 G_G 阅读(1526) | 评论 (0) | 编辑收藏

项目开发感想

   项目开发：就好像是一个取得真理的一个过程。
   在开始“没有人”会知道什么是对的，什么是错的。所谓的客户（中世纪教会的教徒），告诉你月亮是“热胀冷缩”造成的“阴晴圆缺”。
   在初期你敢于否定“热胀冷缩”原理？或者说根本就是认为月亮是受“热胀冷缩”原理影响的。

   那好，下面我们根据月亮圆缺原理，写个统计温度与月亮亮度报表。

   客户自己想要的东西也是一个认知的过程。编码要在开始就要确定是在一个不稳定的环境（即使错了我也能容易修改，这是软件最有价值的地方）。对于这些理解为项目的可变性总结出的一些见解：
   1.尽量明确各层使用框架。这样能统一技术，明确编码风格，统一存放，查找地址。这样就能很好的定位要修改文件的物理地址和尽量不与个人技术有关。
   2.尽量明确各种动作的命名规范。这样不但能很好的使用 aop ，而且为修改提供了逻辑地址查找提供便利。
   3.减少个人英雄主义。由于某些个人原因，引入与项目不兼容的技术，这是很危险的。只有这为“英雄”能修改的后果很严重。
   4.编码中对“可预见性”的代码结构适应，扩展接口预留。月亮缺失可能不是“热胀冷缩”引起的怎么办（当然也是最难做到）这只要编码想到可能就有“可变性”就要有好的相应对策，比如：公司鼓励程序员的为“可变性预留接口”，当然最好也注意下预留接口的规范。

posted @ 2008-08-05 17:02 G_G 阅读(1631) | 评论 (2) | 编辑收藏

tomcat 调试扩展

参考引用：
主题：使用全功能Tomcat简化调试
让classpath参数走开

直接用eclipse 调试：

tomcat - > service.xml
<Context debug="5" docBase="E:/tomcat/tomcatwebroot"
path="/tomcatwebroot" reloadable="true" privileged="true">
</Context>

这引入一个java 文件到你的工程中

import java.io.File;
import java.io.FileFilter;
import java.lang.reflect.Method;
import java.net.URL;
import java.net.URLClassLoader;
import java.util.ArrayList;
import java.util.List;

public class MainClassLoad {
    //commons-lang-2.0.jar
    static String TOMCAT_HOME = "D:\\apache\\apache-tomcat-5.5.20\\apache-tomcat-5.5.20";

    public static void main(String[] args) throws Exception {
        System.setProperty("catalina.home", TOMCAT_HOME);

        final ClassLoader classLoader = getClassLoader(new String[]{
                TOMCAT_HOME+"\\common\\lib",
                TOMCAT_HOME+"\\server\\lib",
                TOMCAT_HOME+"\\bin"
        });
        Object obj = getObject(classLoader,"org.apache.catalina.startup.Catalina");
        Method setConfig = obj.getClass().getMethod("setConfig", new Class[]{String.class});
        setConfig.invoke(obj, TOMCAT_HOME + "/conf/server.xml");

        Method start = obj.getClass().getMethod("start", new Class[]{});
        start.invoke(obj, null);
    }



    public static Object getObject(ClassLoader classLoader,String className) throws Exception{
        return classLoader.loadClass(className).newInstance();
    }


    public static ClassLoader getClassLoader(String[] libPath) throws Exception{
        List<URL> list = new ArrayList<URL>();
        FileFilter fileFilter = new FileFilter()
         {
           public boolean accept(File dir)
           {
             String name = dir.getName().toLowerCase();
             return name.endsWith("jar") || name.endsWith("zip");
           }
         };

        for(String stmp : libPath){
            for(File ftmp : new File(stmp).listFiles(fileFilter) ){
                list.add( new URL("file",null,ftmp.getPath()) );
            }
        }
        URL[] urls = new URL[list.size()];
         // fill the urls array with URLs to library files found in libRoot
         for(int i = 0; i < list.size(); i++) {
           urls[i] = new URL("file",null,list.get(i).getPath() );
         }
        ClassLoader classLoader = new URLClassLoader(urls,
                 Thread.currentThread().
                 getContextClassLoader());
        return  classLoader ;
    }


}

posted @ 2008-08-01 18:46 G_G 阅读(1233) | 评论 (0) | 编辑收藏

一道题面试题！

代码编辑耗时 40 分钟；自己感觉很慢！！

文本文件，我想写个Java程序，读一遍这个
文件，然后打印出来文件中英文字母（a 到 z）出现的次数。不区分大小写。
代码：

import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.util.Collections;
import java.util.LinkedHashMap;
import java.util.Map;

public class LinjiawangMain {

    public static void main(String[] args) throws Exception {
        Map<Character, Integer> map = getCountByFileLetters("chars.txt") ;
        for(char ctmp : map.keySet()){
            System.out.println( ctmp+"="+map.get(ctmp) );
        }
    }


    //统计文件字符工具方法
    public static Map<Character, Integer> getCountByFileLetters(String filePath) throws Exception{
        //逻辑参数定义
        int int_A = 'A';
        int int_Z = 'Z';

        int int_a = 'a';
        int int_z = 'z';

        //数据收集 map (保持存储顺序使用 LinkedHashMap )
        Map<Character, Integer> map = new LinkedHashMap<Character, Integer>();

        //以 ISO-8859-1 字符读取 .classpath 下的文件
        InputStreamReader read = new InputStreamReader(new FileInputStream(
                LinjiawangMain.class.getClassLoader().getResource(filePath)
                        .getPath()), "ISO-8859-1");
        //临时数据收集
        int[] iis = new int[int_z-int_a];
        while(read.ready() ){
            int itmp = read.read();
            // 当 'a'<=itmp<='z' (短路)
            // 当 'A'<=itmp<='Z' (非短路) 后修改itmp到 'a' 到 'z'范围
            if(
                ( itmp >=int_a && itmp<=int_z ) ||
                ( itmp>=int_A && itmp<=int_Z  ) | (itmp=(itmp+(int_a-int_A)))>=int_a
            ){
                iis[itmp-int_a]++ ;
            }
        }

        //由临时数据收集转到正式收集
        for(int i=0;i<int_z-int_a;i++){
            map.put( (char)(i+int_a),iis[i] );
        }
        //非修改 map
        return Collections.unmodifiableMap(map) ;
    }

}

文件：
aAbbbbCCCCc2345ABdb
abc
d

posted @ 2008-07-30 11:29 G_G 阅读(1860) | 评论 (2) | 编辑收藏

一句话技术（大家来接龙）

那位来开个头吧

正则匹配 html标题
    <[hH]([1-9])>.*?</[hH]\1>

数据库查询执行顺序:
    from->where->group by->聚集函数->having->order by
    table level(id,name)
    select count(*) as cu from level where id>1 group by name desc having cu>=1 order by id ;

火狐 xpath 取 document dom 值：
    id('table8')/tbody/tr[6]/td/@valign

数据库有为空列排放位置:
    1. select name,
                case
                         when name is null then 0
                         else 1
                end
                    as is_null
         from level
         order by is_null ;
    2.select name from level where name is null
       union
      select name from level where name is not null ;

数据库报表表链为空项替换为0
table a (id); values - > 1 ,2 ,3
table b (id,num); -> (1,15),(1,5)
查询结果为要为
1    20
2    0
3    0

select a.id as id,
        sum(
            case
                when b.num is  null then 0
                else b.num
             end
            ) as num
from a left join b on a.id=b.id
group by id ;

posted @ 2008-07-28 11:02 G_G 阅读(1265) | 评论 (1) | 编辑收藏

mysql 导出文本数据转换展现格式

package uu;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.regex.Pattern;

public class MainExc {
     // 数据文本
     static String filePath = " smsservice.data " ;
     // 输出文本
     static String outfile = " outfile.html " ;
     // 输出文本格式
     static String charset = " GBK " ;

     // 数据逻辑展现
     static Map < Pattern, String > map = new HashMap < Pattern, String > ();
     static {
        map.put(Pattern.compile( " ^XZT " ), " sina " );
        。。。。。
    }

     // 类型定义
     static Map < Pattern, String > maptype = new HashMap < Pattern, String > ();
     static {
        maptype.put(Pattern.compile( " ^3P45 " ), " 客户端 " );
        maptype.put(Pattern.compile( " ^6930 " ), " 图表 " );
        ......

    }

     // 禁止展现
     static List < Pattern > listNo = new ArrayList < Pattern > ();
     static {
        listNo.add(Pattern.compile( " ^9588Command$ " ));
        listNo.add(Pattern.compile( " ^5kjsCommand$ " ));
        listNo.add(Pattern.compile( " ^529901001011021$ " ));
        listNo.add(Pattern.compile( " ^529901001011022$ " ));
    }



     public static void main(String[] args) throws Exception {
         // read
        InputStreamReader read = new InputStreamReader(
                 new FileInputStream(MainExc. class .getClassLoader().getResource(
                        filePath).getPath()), charset);

         // writer
         if (MainExc. class .getClassLoader().getResource(outfile) == null ) {
             new File(MainExc. class .getClassLoader().getResource( " . " ).getPath()
                     + " /outfile.html " ).createNewFile();
        }
        OutputStreamWriter writer = new OutputStreamWriter(
                 new FileOutputStream(MainExc. class .getClassLoader()
                        .getResource(outfile).getPath()), charset);

         // 内存装载处
        List < Map < String, String >> datas = new ArrayList < Map < String, String >> ();



        StringBuffer buffer = new StringBuffer();
        BufferedReader reader = new BufferedReader(read);
        String stmp = null ;
        List < String > colName = new ArrayList < String > ();
         // 得到列名
         if ((stmp = reader.readLine()) != null && ! stmp.trim().equals( "" )) {
             // split - > Tab
             for (String stmp2 : stmp.split( "      " )) {
                colName.add(stmp2);
            }
        }

         // 列数据收集
         while ((stmp = reader.readLine()) != null && ! stmp.trim().equals( "" )) {

            Map < String, String > data = new HashMap < String, String > ();
            String[] sdata = stmp.split( "      " );
             for ( int i = 0 ; i < colName.size(); i ++ ) {
                data.put(colName.get(i), sdata[i]);
            }
            datas.add(data);
        }


         // writer
        writer.append( " <center><table  border>\n " );
        writer.append( " <tr> " + " <td>通道伙伴</td> " + " <td>指令</td> " + " <td>长号码</td> "
                 + " <td>资费</td> " + " <td>业务类型（图表/客户端）</td> " + " </tr>\n " );
         // 通道伙伴指令长号码资费业务类型（图表？客户端？）
        wfor: for (Map < String, String > mtmp : datas) {

             for (Pattern ptmp : listNo) {
                 if (ptmp.matcher(mtmp.get( " command " )).find()) {
                     continue wfor;
                }
            }

            String hzhb = "" ;

             for (Pattern ptmp : map.keySet()) {
                 if (ptmp.matcher(mtmp.get( " command " )).find()) {
                    hzhb = map.get(ptmp);
                }
            }

            String type = "" ;
             for (Pattern ptmp : maptype.keySet()) {
                 if (ptmp.matcher(mtmp.get( " command " )).find()) {
                    type = maptype.get(ptmp);
                }
            }

            writer.append( " <tr> " + " <td align='center'> " + hzhb + " </td> "
                     + " <td align='center'> " + mtmp.get( " command " ) + " </td> "
                     + " <td align='center'> " + mtmp.get( " num " ) + " </td> "
                     + " <td align='center'> " + mtmp.get( " money " ) + " </td> "
                     + " <td align='center'> " + type + " </td> " + " </tr>\n " );
        }
        writer.append( " </table></center>\n " );

         // save
        writer.flush();
        writer.close();
    }

}

posted @ 2008-07-25 16:39 G_G 阅读(2149) | 评论 (0) | 编辑收藏

Hibernate fetch lazy cascade inverse 关键字(转)

一篇非常好的 Hibernate 文章
出自： http://guxing.blog.enorth.com.cn/article/174717.shtml

Tags: fetch

Hibernate最让人头大的就是对集合的加载形式。

书看了N次了，还是没有真正理解Hibernate。所以下午专门做了下测试，对配置文件的意思加深了认识。

假设有两个表，Photos(一） --- picture(多）Photo包含picture集合

结论1： HQL代码 > fetch（配置） > lazy （配置）
结论2：默认 lazy="true"
结论3： fetch 和 lazy 主要是用来级联查询的，   而 cascade 和 inverse 主要是用来级联插入和修改的
结论4：如果你是用spring来帮你管理你的session, 并且是自动提交，延迟加载就等于没加载~_~(当然除非你手动重新打开session然后手动Hibernate.initialize(set);然后关闭session.
结论5: cascade主要是简化了在代码中的级联更新和删除。
j结论6：老爸可以有多个孩子，一个孩子不能有多个老爸，而且老爸说的算, 孩子围着老爸转。所以Photos老爸要有权力所以 cascade 这个关键子都是送给老爸的，也就是级联更新，老爸改姓了，儿子也得跟着改，呵呵。“不然，就没有零花钱咯”。而Picture儿子整体挨骂，但是还是要维护父子之间良好的关系，对老爸百依百顺，所以老爸就说，儿子，“关系，由你来维护（inverse="true") ，不然就不给零花钱。呵。”。
               <set name="pictures" inverse="true" cascade="all">
                    <key>
                       <column name="photosid" not-null="true" />
                    </key>
                 <one-to-many class="girl.domain.Picture" />
             </set>

测试代码：

   Photos p = ps.getById(1);
  Set<Picture> set = p.getPictures();
  for(Picture pic : set){
   System.out.println(pic.getId());
  }

配置文件的一部分：
       <set name="pictures" inverse="true" cascade="all" >
            <key>
                <column name="photosid" not-null="true" />
            </key>
            <one-to-many class="girl.domain.Picture" />
        </set>

测试过程会对配置文件不断修改：并且从来不曾手动重新打开session

测试结构：

当配置条件为 lazy=true一句查询测试代码中没有调用getPicture() 正常
Hibernate: select photos0_.id as id0_0_, photos0_.userid as userid0_0_, photos0_.typeid as typeid0_0_, photos0_.name as name0_0_, photos0_.createtime as createtime0_0_, photos0_.description as descript6_0_0_, photos0_.faceid as faceid0_0_, photos0_.uri as uri0_0_ from super.photos photos0_ where photos0_.id=?

lazy=true 一句查询有getPicture()
Hibernate: select photos0_.id as id0_0_, photos0_.userid as userid0_0_, photos0_.typeid as typeid0_0_, photos0_.name as name0_0_, photos0_.createtime as createtime0_0_, photos0_.description as descript6_0_0_, photos0_.faceid as faceid0_0_, photos0_.uri as uri0_0_ from super.photos photos0_ where photos0_.id=?

lazy=true 一句查询有getPicture() 并且访问了里面的元数Picture 且有异常抛出
Hibernate: select photos0_.id as id0_0_, photos0_.userid as userid0_0_, photos0_.typeid as typeid0_0_, photos0_.name as name0_0_, photos0_.createtime as createtime0_0_, photos0_.description as descript6_0_0_, photos0_.faceid as faceid0_0_, photos0_.uri as uri0_0_ from super.photos photos0_ where photos0_.id=?

lazy="false" 两句查询肯定没问题，因为全部数据都个查了出来所以怎么调用都正常
Hibernate: select photos0_.id as id0_0_, photos0_.userid as userid0_0_, photos0_.typeid as typeid0_0_, photos0_.name as name0_0_, photos0_.createtime as createtime0_0_, photos0_.description as descript6_0_0_, photos0_.faceid as faceid0_0_, photos0_.uri as uri0_0_ from super.photos photos0_ where photos0_.id=?
Hibernate: select pictures0_.photosid as photosid1_, pictures0_.id as id1_, pictures0_.id as id2_0_, pictures0_.photosid as photosid2_0_, pictures0_.name as name2_0_, pictures0_.clicked as clicked2_0_, pictures0_.uploaddate as uploaddate2_0_, pictures0_.size as size2_0_, pictures0_.description as descript7_2_0_, pictures0_.uri as uri2_0_ from super.picture pictures0_ where pictures0_.photosid=?

fetch="join" 一句查询效果＝＝ lazy="false" 呵呵，哪个效率高，我就不知道了。。。。。。。。。。。
Hibernate: select photos0_.id as id0_1_, photos0_.userid as userid0_1_, photos0_.typeid as typeid0_1_, photos0_.name as name0_1_, photos0_.createtime as createtime0_1_, photos0_.description as descript6_0_1_, photos0_.faceid as faceid0_1_, photos0_.uri as uri0_1_, pictures1_.photosid as photosid3_, pictures1_.id as id3_, pictures1_.id as id2_0_, pictures1_.photosid as photosid2_0_, pictures1_.name as name2_0_, pictures1_.clicked as clicked2_0_, pictures1_.uploaddate as uploaddate2_0_, pictures1_.size as size2_0_, pictures1_.description as descript7_2_0_, pictures1_.uri as uri2_0_ from super.photos photos0_ left outer join super.picture pictures1_ on photos0_.id=pictures1_.photosid where photos0_.id=?

不加fetch＝"join"一句查询没有getPicture() 正常
Hibernate: select photos0_.id as id0_0_, photos0_.userid as userid0_0_, photos0_.typeid as typeid0_0_, photos0_.name as name0_0_, photos0_.createtime as createtime0_0_, photos0_.description as descript6_0_0_, photos0_.faceid as faceid0_0_, photos0_.uri as uri0_0_ from super.photos photos0_ where photos0_.id=?

不加fetch＝"join" 一句查询有getPicture() 正常
Hibernate: select photos0_.id as id0_0_, photos0_.userid as userid0_0_, photos0_.typeid as typeid0_0_, photos0_.name as name0_0_, photos0_.createtime as createtime0_0_, photos0_.description as descript6_0_0_, photos0_.faceid as faceid0_0_, photos0_.uri as uri0_0_ from super.photos photos0_ where photos0_.id=?

不加fetch＝"join"一句查询有getPicture() 并且访问里面的元素Picture的ID 有异常抛出
Hibernate: select photos0_.id as id0_0_, photos0_.userid as userid0_0_, photos0_.typeid as typeid0_0_, photos0_.name as name0_0_, photos0_.createtime as createtime0_0_, photos0_.description as descript6_0_0_, photos0_.faceid as faceid0_0_, photos0_.uri as uri0_0_ from super.photos photos0_ where photos0_.id=?

来个两兵交战 fetch="join" lazy="true" 呵呵结果，一句查询，结构正常所以就当lazy不存在好了。看来fetch 是老大。、、、、、、、、、、、、、
Hibernate: select photos0_.id as id0_1_, photos0_.userid as userid0_1_, photos0_.typeid as typeid0_1_, photos0_.name as name0_1_, photos0_.createtime as createtime0_1_, photos0_.description as descript6_0_1_, photos0_.faceid as faceid0_1_, photos0_.uri as uri0_1_, pictures1_.photosid as photosid3_, pictures1_.id as id3_, pictures1_.id as id2_0_, pictures1_.photosid as photosid2_0_, pictures1_.name as name2_0_, pictures1_.clicked as clicked2_0_, pictures1_.uploaddate as uploaddate2_0_, pictures1_.size as size2_0_, pictures1_.description as descript7_2_0_, pictures1_.uri as uri2_0_ from super.photos photos0_ left outer join super.picture pictures1_ on photos0_.id=pictures1_.photosid where photos0_.id=?

posted @ 2008-07-23 11:14 G_G 阅读(956) | 评论 (0) | 编辑收藏

页面 table 数据收集

收集javascript

<html>
<head>
</head>
<body>
<table border>

    <tr >
        <td>指令</td>
        <td>统计</td>
    </tr>

  
    <tr name='_trdata'>
        <td name="_comm">234</td>
        <td name="_count">1</td>
    </tr>

    <tr name='_trdata'>
        <td name="_comm">1234</td>
        <td name="_count">2</td>
    </tr>

    <tr name='_trdata'>
        <td name="_comm">1256</td>
        <td name="_count">9</td>
    </tr>

</table>
<input id="t1" type="text" />
<input type="button" value="页面数据收集"
                    onclick="numSum( document.getElementById('t1').value,'ss1');">
结果:<span id="ss1" />
</body>

<script type="text/javascript">

    /* startRegx
    *    E.g  3P45 -> 3P4501

* E.g 3P45;MAXAM -> 3P4509

MAXAM1

    * 收集方法
    */
    function numSum(startRegx,strTextId){
        var sum = 0 ;

        //准备  匹配正则
        var regxStrs = startRegx.split(";");
        var regxs =  new Array(regxStrs.length);
        for(var i=0;i<regxStrs.length;i++){
            regxs[i] = new RegExp("^"+regxStrs[i], '');
        }

        //得到需要的 tr
        var trs = document.getElementsByName('_trdata');

        //遍历 tr
        for(var i=0;i<trs.length;i++){
            trs[i].style.backgroundColor = "";

            //得到全部 td
            var comm = getValusByObjectChildName(trs[i],'_comm');
            var count = getValusByObjectChildName(trs[i],'_count');
            if(  comm == null  ) continue ;

            for(var k=0;k<regxs.length;k++ ){
                if( regxs[k].test( comm )){
                    if( ! isNaN( count ) ){
                         trs[i].style.backgroundColor = "#00cccc";
                         sum += parseInt( count ) ;
                    }
                }
            }
        }

        document.getElementById(strTextId).innerHTML = sum ;
    }

   //收集工具方法
   function  getValusByObjectChildName(fobj,cName){
            if( fobj==null || fobj.firstChild==null )
                    return null ;

          var cns = fobj.childNodes ;

          for(var j=0;j<cns.length;j++){
              if( cns[j].getAttribute &&  cns[j].getAttribute('name')==cName ){
                  return cns[j].firstChild.nodeValue ;
              }
          }
          return null ;
    }

</script>

</html>

posted @ 2008-07-21 17:12 G_G 阅读(1390) | 评论 (0) | 编辑收藏

dwr 学习笔记

参考引用：

使用说明： lib添加dwr.jar
web.xml添加

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE web-app PUBLIC
    "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">
<web-app id="dwr">
  <display-name>DWR (Direct Web Remoting)</display-name>
  <description>A Simple Demo DWR</description>

  <servlet>
    <servlet-name>dwr-invoker</servlet-name>
    <display-name>DWR Servlet</display-name>
    <description>Direct Web Remoter Servlet</description>
    <servlet-class>org.directwebremoting.servlet.DwrServlet</servlet-class>

    
    <init-param>
      <param-name>debug</param-name>
      <param-value>true</param-value>
    </init-param>

  </servlet>

  <servlet-mapping>
    <servlet-name>dwr-invoker</servlet-name>
    <url-pattern>/dwr/*</url-pattern>
  </servlet-mapping>

</web-app>

dwr.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE dwr PUBLIC
    "-//GetAhead Limited//DTD Direct Web Remoting 1.0//EN"
    "http://www.getahead.ltd.uk/dwr/dwr10.dtd">
<dwr>
    <allow>
        
        <create creator="new" javascript="CatalogDAO">
            <param name="class" value="com.ajaxlab.ajax.CatalogDAO" />
            <include method="getItem" />
            <include method="findItems" />
            <include method="updateItem" />
        </create>

        
        <convert converter="bean" match="com.ajaxlab.ajax.Item">
            <param name="include"
                value="id,name,description,formatted- Price" />
        </convert>
    </allow>
</dwr>

类说明
bean Item:
private String id = "";
private String name = "";
private String description = "";
private int price = 0;
get();set();

dao

    public Item getItem(String id) {
        Item item = new Item("产品-"+id);
        item.setName("新品-"+id);
        item.setPrice(100);
        item.setDescription("中国制造.");
        return item;
    }

    public List findItems(String expression) {
        List list = new ArrayList();
        Item item1 = new Item("产品-001");
        item1.setName("新品-001");
        item1.setDescription(expression);
        item1.setPrice(10);
        Item item2 = new Item("产品-002");
        item2.setName("新品-002");
        item2.setDescription(expression);
        item2.setPrice(15);
        Item item3 = new Item("产品-003");
        item3.setName("新品-003");
        item3.setDescription(expression);
        item3.setPrice(35);
        list.add(item1);
        list.add(item2);
        list.add(item3);
        return list;

    }

   /* html input text ->
        {
            description:"中国制造.",
            id:"1",
            name:"刘凯毅"
        }
        return true ;

     */
    public boolean updateItem(Item item ){
        if( item!=null && item.getName().equals("刘凯毅") )
            return true;

        return false ;
    }

js 方法：
在 input 输入->>
method( !! )

bean(id,name...)
{id:1,name:'liukaiyi'}

当多参数为 map
{dd:'liu',aa:'gg'}

js多参数
class.method(
objectEval($("p00").value),
objectEval($("p01").value),
reply0);

展现页：

<html>
<head>
  <title>DWR Test</title>
  
  <script type='text/javascript' src='/testDwr/dwr/interface/CatalogDAO.js'></script>
  <script type='text/javascript' src='/testDwr/dwr/engine.js'></script>
  <script type='text/javascript' src='/testDwr/dwr/util.js'></script>

  <script type='text/javascript'>
//输入到方法中参数格式转换
  function objectEval(text){
    text = text.replace(/\n/g, ' ');
    text = text.replace(/\r/g, ' ');
    if (text.match(/^\s*\{.*\}\s*$/))
    {
      text = '[' + text + '][0]';
    }
    return eval(text);
  }

//本例 alert 展现
  var reply = function(data){
      alert(dwr.util.toDescriptiveString(data, 2));
  }

  </script>

</head>
<body >

<li>
  findItems(    <input  type='text'  value='""' id='p00' />  );
  <input class='ibutton' type='button' onclick='CatalogDAO.findItems(objectEval($("p00").value), reply);' value='Execute'  />

</li>
<li>
  getItem(    <input class='itext' type='text' size='10' value='""' id='p10' title='Will be converted to: java.lang.String'/>  );
  <input class='ibutton' type='button' onclick='CatalogDAO.getItem(objectEval($("p10").value), reply);' value='Execute'  title='Calls CatalogDAO.getItem(). View source for details.'/>
</li>

<li>
updateItem(   <input class='itext' type='text' size='10' value='{}' id='p20'/> );
<input class='ibutton' type='button' onclick='CatalogDAO.updateItem(objectEval($("p20").value), reply);' value='Execute' />
</li>

</body></html>

posted @ 2008-07-17 15:17 G_G 阅读(1715) | 评论 (0) | 编辑收藏

企业数据分类

摘要: 本文提供：1.企业分类数据2.此类用于吧文本数据变成 sql 并插入数据库 Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> import java.io.BufferedReader; im... 阅读全文

posted @ 2008-07-15 16:18 G_G 阅读(1649) | 评论 (0) | 编辑收藏

ibatis 关系数据库设计参考

摘要: 直接运行demo http://www.blogjava.net/Files/Good-Game/iba2.rar 数据说明： Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> /* ibatis ... 阅读全文

posted @ 2008-07-15 15:37 G_G 阅读(2003) | 评论 (0) | 编辑收藏

实用，简单 ibatis dome （包含多对一；一对多）

dome
使用hsql 数据库；
一对多，多对一；

可以直接运行的 dome:http://www.blogjava.net/Files/Good-Game/iba.rar
本例指涉及到查询，为了简单没有事务，和service层

先看测试运行：

    @Test
    public void testLevel() {

        try {

            Level level = (Level)DaoConfig.getSqlMap().queryForObject("level.getLevelId", new Integer(2) );
            System.out.println("f_level="+level.getFlevel().getName());

            System.out.println("->level="+level.getName());
            for(Level ltmp : level.getClevel()){
                System.out.println("c_root="+ltmp.getName());
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

运行结果：

hsql 数据库初始化
create table level  (     id int not null,     name varchar(80) null,     fid int ,     constraint pk_supplier primary key (id),     constraint fk_item_1 foreign key (fid)         references level (id) )
create index levelName on level (name)
insert into level (id,name,fid) values(1,'root',null)
insert into level (id,name,fid) values(2,'level_1',1)
insert into level (id,name,fid) values(3,'root_2',1)
insert into level (id,name,fid) values(4,'root_1_1',2)
insert into level (id,name,fid) values(5,'root_1_2',2)
insert into level (id,name,fid) values(6,'root_1_1_1',4)

运行结果
f_level=root
->level=level_1
    c_level=root_1_1
    c_level=root_1_2

DaoConfig工具类：

package test.persistence;

import com.ibatis.common.jdbc.ScriptRunner;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;

import java.io.IOException;
import java.io.PrintWriter;
import java.io.Reader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
/**
* damo api
* http://portals.apache.org/bridges/multiproject/jpetstore/apidocs/overview-summary.html
* @author Administrator
*
*/
public class DaoConfig {

  private static SqlMapClient sqlMap = null ;
  static {
    try {
      Properties props = Resources.getResourceAsProperties("properties/database.properties");
      String url = props.getProperty("url");
      String driver = props.getProperty("driver");
      String username = props.getProperty("username");
      String password = props.getProperty("password");
      if (url.equals("jdbc:hsqldb:mem:jpetstore")) {
        Class.forName(driver).newInstance();
        Connection conn = DriverManager.getConnection(url, username, password);
        try {
          ScriptRunner runner = new ScriptRunner(conn, false, false);
          runner.setErrorLogWriter( new PrintWriter(  System.out ) );
          runner.setLogWriter(new PrintWriter(  System.out ));
          runner.runScript(Resources.getResourceAsReader("hsql/test.sql"));
        }catch (Exception e) {
            e.printStackTrace();
        } finally {
          conn.close();
        }
      }


      String resource = "test/persistence/sql-map-config.xml";
      Reader reader = Resources.getResourceAsReader (resource);
      sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
    } catch (Exception e) {
      throw new RuntimeException("Description.  Cause: " + e, e);
    }
  }

  public static SqlMapClient getSqlMap(){
      return sqlMap ;
  }

}

dao:

public class LevelDao {
     public static List<Level>  getAll(){
        try {
            return DaoConfig.getSqlMap().queryForList("getAllLevel");
        } catch (Exception e) {
            e.printStackTrace();
        }
        return null ;
    }
}

持久类说明

package test.domain;

import java.util.List;

public class Level {
    private Integer id ;
    private String name ;

    //得到此对象父节点 (多对一)
    private Level flevel ;
    //得到此对象孩子节点 (一对多)
    private List<Level> clevel;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Level getFlevel() {
        return flevel;
    }

    public void setFlevel(Level flevel) {
        this.flevel = flevel;
    }

    public List<Level> getClevel() {
        return clevel;
    }

    public void setClevel(List<Level> clevel) {
        this.clevel = clevel;
    }

}

level.xml

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

<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="level">

    <typeAlias alias="level" type="test.domain.Level" />

    <resultMap class="level" id="getLevelByFa">
        <result property="id" column="id" />
        <result property="name" column="name" />
        <result property="flevel" column="fid" select="level.getLevelId"/>
        <result property="clevel" column="id" select="level.getLevelByfId"/>
    </resultMap>

     <select id="getLevelId" resultClass="level" parameterClass="int" resultMap="getLevelByFa"  >
         select
         id ,
         name ,
         fid
         from level
         WHERE id =#id#
     </select>


     <select id="getLevelByfId" resultClass="level" parameterClass="int" resultMap="getLevelByFa"  >
         select
         id ,
         name ,
         fid
         from level
         WHERE fid =#id#
     </select>
</sqlMap>

map confg

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

<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig >
    <properties resource="properties/database.properties"/>
    <settings
        useStatementNamespaces="true"
    />

  <transactionManager type="JDBC">
    <dataSource type="SIMPLE">
      <property value="${driver}" name="JDBC.Driver"/>
      <property value="${url}" name="JDBC.ConnectionURL"/>
      <property value="${username}" name="JDBC.Username"/>
      <property value="${password}" name="JDBC.Password"/>
    </dataSource>
  </transactionManager>

  <sqlMap resource="test/persistence/level.xml"/>

</sqlMapConfig>

posted @ 2008-07-14 14:45 G_G 阅读(4449) | 评论 (2) | 编辑收藏

下拉 remove

html

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<form action="">
    <table>
        <tr>
            <td>
                <select id="s1" size="5">
                    <option>-1-</option>
                    <option>-2-</option>
                    <option>-3-</option>
                </select>
            </td>
            <td>
                <input type="button" value=">>" onclick="optionRemove('s1','s2');"/>
                <input type="button" value="<<" onclick="optionRemove('s2','s1');"/>
            </td>
            <td>
                <select id="s2" size="5">
                </select>
            </td>
        </tr>
    </table>
</form>

</body>
<script type="text/javascript">
    function optionRemove(selFromById,selToById){
        var sf = document.getElementById(selFromById);
        var st = document.getElementById(selToById);

        var mo =  sf.options[sf.selectedIndex];
        var moTest =  mo.text ;
        var moValue = mo.value ;

        sf.remove(sf.selectedIndex);
        st.options.add(new Option(moTest,moValue ),0)

    }
</script>
</html>

posted @ 2008-07-12 17:38 G_G 阅读(206) | 评论 (0) | 编辑收藏

javascript select 操作

           < input type ="hidden" name ="SMSServices" value ="" />
           < td >
               < select size ="5"   name ="from_SMSServices" >
                   <% for (SMSService stmp : SMSServiceUtils.getAllSMSService()) { %>
                     < option value ="<%=stmp.getId()%>" > <% = stmp.getName() %> </ option >
                 <% } %>
               </ select >
           </ td >
           < td >
               < input type ="button"   value ='>>' onclick ="optionSelectedMove(this.form,'from_SMSServices','to_SMSServices');" />< br />
               < input type ="button"   value ='<<' onclick ="optionSelectedMove(this.form,'to_SMSServices','from_SMSServices');" />
           </ td >
           < td >
               < select size ="5" name ="to_SMSServices" >
               </ select >
           </ td >
       </ tr >

       < tr >< input type ="button" value ="提交" onClick ="addSMSServicesValues('SMSServices','to_SMSServices');this.form.submit();" /></ tr >

javascript 方法

posted @ 2008-07-04 11:03 G_G 阅读(630) | 评论 (0) | 编辑收藏

logg4j 使用笔记

参考：http://www.builder.com.cn/2008/0517/866964.shtml

上面很全文就不说了。

在这logger邮件，总不成功。在此我重写：

log4j.appender.MAIL=uu.Mail
#defines how often emails are send
log4j.appender.MAIL.BufferSize=1
log4j.appender.MAIL.threshold=error

log4j.appender.MAIL.SMTPHost=mail.chinanet.net.cn
log4j.appender.MAIL.From=wap@chinanet.net.cn
log4j.appender.MAIL.To=liukaiyi@gmail.com
log4j.appender.MAIL.Subject=Application.log error occurred

log4j.appender.MAIL.layout=org.apache.log4j.PatternLayout
log4j.appender.MAIL.SMTPUsername=wap
log4j.appender.MAIL.SMTPPassword=aaaaaa
log4j.appender.MAIL.layout.ConversionPattern=%d %5p [%c] %n%m%n

package uu;

import java.util.Date;
import java.util.Properties;

import javax.mail.Authenticator;
import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.PasswordAuthentication;
import javax.mail.Session;
import javax.mail.Store;
import javax.mail.Transport;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;

import org.apache.log4j.net.SMTPAppender;

public class Mail extends SMTPAppender {
    public void activateOptions() {
        Mail sml = new Mail();
        sml.send("wap","aaaaaa","liukaiyi@gmail.com","logg4j"," 邮件正文测试开始 ");
        System.out.println("邮件发送成功！");
    }

    // goMail 收邮件邮箱  mailContent 邮件正文
    public static void sendMail(String goMail,String mailContent){
        Mail sml = new Mail();
        sml.send("wap","aaaaaa",goMail,"订单管理",mailContent);
        System.out.println("邮件发送成功！");
    }
    public void send(String name,String pass,String goMail,String title,String mailContent){
        try
        {
            Properties props = new Properties();
            Session sendMailSession;
            Store store;
            Transport transport;
            props.put("mail.smtp.auth","true");
            props.put("mail.smtp.host", "mail.chinanet.net.cn"); //smtp

            props.put("mail.smtp.user",name+"@chinanet.net.cn"); //


            props.put("mail.smtp.password",pass); //�ʼ��
            PopupAuthenticator popA=new PopupAuthenticator();//
            PasswordAuthentication pop = popA.performCheck(name+"@chinanet.net.cn",pass); //��д�û��
            sendMailSession = Session.getInstance(props, popA);
            Message newMessage = new MimeMessage(sendMailSession);
            newMessage.setFrom(new InternetAddress(name+"@chinanet.net.cn"));

            newMessage.setRecipient(Message.RecipientType.TO, new InternetAddress(goMail));  //��շ��ʼ��ַ
            newMessage.setSubject(title);
            newMessage.setSentDate(new Date());
            mailContent+="\n\n"+new Date().toLocaleString();
            newMessage.setText(mailContent); //�ʼ��
            transport = sendMailSession.getTransport("smtp");
            transport.send(newMessage);
        }
        catch (MessagingException ex)
        {
            ex.printStackTrace();
        }
    }

    public class PopupAuthenticator extends Authenticator{
        String username=null;
        String password=null;
        public PopupAuthenticator(){}
        public PasswordAuthentication performCheck(String user,String pass){
            username = user;
            password = pass;
            return getPasswordAuthentication();
        }
        protected PasswordAuthentication getPasswordAuthentication() {
            return new PasswordAuthentication(username, password);
        }
    }

}

posted @ 2008-07-02 11:20 G_G 阅读(728) | 评论 (0) | 编辑收藏

开源myCompetence权限框架成立

此文随时更新

项目svn http://mycompetence.googlecode.com/svn/trunk/mycompetence/
如在浏览器中查看有乱码问题。
请把浏览器编码改成 utf-8 或 gb2312 查看试试;

数据表结构create.sql（未完）
项目说明项目说明.txt（未完）

在一片声讨中，项目以蜗牛的速度慢慢开始了。
2008-6-25 尝试持久层建模; create.sql

2008-6-30 16:46 添加配置工具类，并确立简单的配置插件使用
（参考：dataSource.DataSourceUtil）

posted @ 2008-06-26 12:03 G_G 阅读(1393) | 评论 (0) | 编辑收藏

我的 ssh demo

项目下载地址
http://www.blogjava.net/Files/Good-Game/TurtleSwims2.rar

此系统为 ssh 框架

svn :
cd E:\svnProject
e:
start svnserve -d -r .

1.spring 管理hibernate事务

2.spring 管理struts2注入

3.ant demo 中hibernate对类文件下的使用
    可在ant 中找到 
    <fileset dir="demo">
        <include name="**/*Bean.java" />
    </fileset>
    生成映射

4.ant hbm2ddl
    0.建立此动作文件
    1.备份数据库,并重建数据库
    2.建立hbm2ddl标签并建create table sql 文件
    3.执行sql文件

5.ant test
    可在ant 中找到
     对类文件为 Test*.class
     ./conf/htmlreport/junit-noframes.html

6.web table 展现可以使用 eXtremeComponents
    http://127.0.0.1:8080/TurtleSwims/demo/extremecomponents.jsp

7.在线文本编辑器
    /TurtleSwims/demo/fckeditor.jsp
    commons-fileupload.jar
    FCKeditor-2.3-modify.jar

8.文件上传
    fileUploadDemo.action
    /demo/strtus2/fileUploadDemo.jsp

9.图片生成
    /demo/pictureYield.action

posted @ 2008-06-23 17:06 G_G 阅读(2265) | 评论 (3) | 编辑收藏

ant 项目使用（修改配置，并加上lib 直接使用）

摘要: 功能描述: 1.ant hibernate：由class xdoclet 得到映射.2.hbm2ddl action 2.0.建立此动作文件 2.1.备份数据库,并重建数据库 2.2.建立hbm2ddl标签并建create table sql 文件 ... 阅读全文

posted @ 2008-06-23 16:27 G_G 阅读(1722) | 评论 (0) | 编辑收藏

Hibernate 数据库设计_1

大家有什么好意见尽量跟我说。我尽量把这编文章弄得更适应大家开发。方便大家使用
此文时时更新！

1.每张表除有关业务描述列外最好预留：

IsShow(true/false) 一些关键数据删除采用隐藏.
version(long|int) 乐观锁使用 hibernate 问题_3(锁
预留扩展字段（可以参考：google protobuf 等）

2.关联关系映射注意21. 示例：父子关系(Parent Child Relationships)

添加级联孩子对象，会生成两条sql（INSERT为c创建， UPDATEp到c的连接p）。

解决办法:<set name="children" inverse="true">
参考：21.2. 双向的一对多关系(Bidirectional one-to-many)

删除级联孩子对象,级联删除.

                解决办法1:<set name="children" inverse="true" cascade="all-delete-orphan">
                参考：21.3. 级联生命周期（Cascading lifecycle）
                解决办法2：删除隐藏策略
              <set name="children" inverse="true" where=" IsShow=boolean|int " cascade="save-update">
             许多数据库没有boolean类型可以用整型替代数据建立默认0可见，不可见改为1.

3一般表设计

posted @ 2008-06-16 15:35 G_G 阅读(2855) | 评论 (1) | 编辑收藏

google svn 服务器使用

google svn 服务器使用：
    1. http://code.google.com/ 用gmail登入。>后点击>Project Hosting
    2. 进入>> http://code.google.com/hosting/ >后点击>Create a new project
    3. 填入必要的项目名，描述等确定。就可以了
    4. 确定成功后 ->Source
    5. 到eclipse的打开新建一个project->team->share Project->svn
    6. 后面根据 google source 上的svn提示，这我就不多说了。一般的svn http url

posted @ 2008-06-10 15:18 G_G 阅读(14260) | 评论 (1) | 编辑收藏

scilab 工具使用

   这些日子一直在想，将来的我怎么在技术这条道路上好好走下去（这一辈子我都会干技术的，我相信我自己）。
    想着想着慢慢的开始害怕自己被淘汰。我才24岁就我工作的一年半中，就看到太多太多的技术被更替，被淘汰。又太多的新技术出现在我们面前。我这年努力去追赶（学习新技术就是一种投资^_^）
    应该要有些压箱底的东西！就今天开始先学数学；后数据结构；最后算法。我要把原来大学学的一点一点捡回来了。

学习之前给自己找个数学学习工具；

scilab（开源） http://www.scilab.org/
（参考） http://blog.chinaunix.net/u/7217/article_40744.html
http://blog.chinaunix.net/u1/56796/showart_694786.html
与之对应的 matlab（企业）对现在我来说太大了

scilab安装后运行
在命令行写入（运行后）：
A=[1 2 3 4;5 6 7 8]

hist3d(A);

posted @ 2008-06-09 16:58 G_G 阅读(1914) | 评论 (3) | 编辑收藏

mysql 树形结构数据收集（存储过程）

就用数据数据库表地址数据（中国地区）来说吧
存储过程：

DELIMITER //
drop procedure if exists  useCursor //
create temporary table if not exists  aop.tmp_table(data bigint(20))//

//建立存储过程
CREATE PROCEDURE useCursor(iid bigint(20))
    BEGIN
       //局部变量定义
         declare tid bigint(20) default -1 ;

       //游标定义
         declare cur1 CURSOR FOR select id from aop.location where fid=iid ;
         //游标介绍定义
         declare CONTINUE HANDLER FOR SQLSTATE '02000' SET tid = null;

         //开游标
         OPEN cur1;
       FETCH cur1 INTO tid;

         WHILE ( tid is not null )
         DO
          insert into aop.tmp_table values(tid);
          //树形结构数据递归收集到建立的临时表中
          call useCursor(tid);
          FETCH cur1 INTO tid ;
       END WHILE;
    END;//
DELIMITER ;

//查询开始，运行是成功的，但用时有10多秒之多，才几百条数据；
//望那个大牛帮帮解决下时间问题！
call useCursor(1);
select * from tmp_table ;
drop temporary table if  exists  aop.tmp_table ;

结果：

|  187 |
|  188 |
|  189 |
|  190 |
|  191 |
|  192 |
|  193 |
|  194 |
|  195 |
|  196 |
|  197 |
|  198 |
|  199 |
|  200 |
|  201 |
|  202 |
|  203 |
|  204 |
|  205 |
|  206 |
|  207 |
|  208 |
|  209 |

.

posted @ 2008-06-08 16:33 G_G 阅读(2771) | 评论 (2) | 编辑收藏

wap 文本展现简单替换

     public static String filter(String input) {
         if (input == null ) {
             return null ;
        }
        StringReader stringReader = new StringReader(input);
        BufferedReader reader = new BufferedReader(stringReader);

        StringBuffer ret = new StringBuffer(input.length() + 200 ); // add more room to the result String

        String line = null ;
         try {
          //换行后添加<br/>
             while ((line = reader.readLine()) != null ) {
                //wap 对 < >的替换
                ret.append(line.replaceAll( " < " , " < " ).replaceAll( " > " , " > " ). replaceAll( "&", "&" ) ).append( " <br/>   " );
            } // while
             // 如果是最后一行
        } catch (IOException ex) {}

        return "    " + ret.toString() ;

    }

posted @ 2008-06-04 17:19 G_G 阅读(234) | 评论 (0) | 编辑收藏

java xml basex 数据库

官方：

eg：xquery使用

import org.basex.core.Commands;
import org.basex.core.proc.Proc;
import org.basex.data.Result;
import org.basex.io.ConsoleOutput;
import org.basex.query.QueryException;
import org.basex.query.QueryProcessor;
import org.basex.query.xquery.XQueryProcessor;

/**
* This class serves an example for executing XQuery requests.
*/
public final class XQueryExample {
  /** Sample query. */
  private static final String XMLFILE = XPathExample.class.getClassLoader().getSystemResource(
              "xx.xml"
         ).getPath();


  private static final String QUERY = " for $x in doc('"+XMLFILE+"')//property " +
                                              " return <child>{data($x/@name)}</child>";

  /** Private constructor. */
  private XQueryExample() { }
  /**
   * Main method of the example class.
   * @param args (ignored) command-line arguments
   * @throws Exception exception
   */
  public static void main(final String[] args) throws Exception {

    // FIRST EXAMPLE:
    System.out.println("First example:");

    // create standard output stream
    final ConsoleOutput out = new ConsoleOutput(System.out);

    // Create a BaseX process
    final Proc proc = Proc.get(Commands.XQUERY, QUERY);
    // launch process
    if(proc.execute()) {
      // successful execution: print result
      proc.output(out);
    } else {
      // execution failed: print result
      proc.info(out);
    }
    out.flush();
    System.out.println();

    // SECOND EXAMPLE (ALTERNATIVE):
    System.out.println("Second example:");

    // Execute XQuery request
    try {
      // create query instance
      final QueryProcessor xquery = new XQueryProcessor(QUERY);
      // execute query; no initial context set is specified (null)
      final Result result = xquery.query(null);
      // print output
      result.serialize(out, false);
      out.println();
    } catch(final QueryException e) {
      // dump stack trace
      e.printStackTrace();
    }

    // close output stream
    out.close();
  }
}

结果：

First example:
<child>connection.datasource</child>
<child>dialect</child>
<child>show_sql</child>
<child>hibernate.cache.provider_class</child>
<child>cache.use_query_cache</child>

Second example:
<child>connection.datasource</child>
<child>dialect</child>
<child>show_sql</child>
<child>hibernate.cache.provider_class</child>
<child>cache.use_query_cache</child>

数据来源：xx.xml

<?xml version='1.0' encoding='utf-8'?>

<hibernate-configuration>

    <session-factory>

        <property name="connection.datasource">java:comp/env/jdbc/USERPORTAL1</property>
        <property name="dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
         <property name="show_sql">true</property>
         <property name="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
         <property name="cache.use_query_cache">true</property>
    

    </session-factory>

</hibernate-configuration>

posted @ 2008-06-04 16:04 G_G 阅读(1754) | 评论 (0) | 编辑收藏

xquery 学习 (简单demo)

xml 数据库使用，和XQuery使用.
环境:
1.xml数据库使用

（参考：eXistQuick Start）
    2.xQuery XQuery 首页

1.测试开始：
    进入：eXist-> http://demo.exist-db.org/xmldb/db/

for $x in doc("/examples2.xml")/exist:result/country return if ($x/population_growth<-1) then <child>{data($x/name)}</child> else <adult>{data($x/name)}</adult>
parent collection: /db
<child > Bosnia and Herzegovina </ child >
<adult > Czech Republic </ adult >
<child > Estonia </ child >
<child > Faroe Islands </ child >
<adult > Hungary </ adult >
<adult > Ireland </ adult >
<child > Latvia </ child >
<adult > Lithuania </ adult >
<child > Romania </ child >
<adult > Russia </ adult >

使用数据：
    http://demo.exist-db.org/xmldb/db/examples2.xml

2：自定义方法：
    使用：http://demo.exist-db.org/sandbox/sandbox.xql

declare function local:minPrice(){
for $x in (1 to 5)
return <test>{$x}</test>
};

<minPrice>{local:minPrice()}</minPrice>

结果：
<minPrice>

</minPrice>

posted @ 2008-05-29 14:49 G_G 阅读(1173) | 评论 (1) | 编辑收藏

数据库表地址数据（中国地区）

摘要: 为方便项目使用，特留！表结构：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> CREATE TABLE `location` ( `id` bigint(20) NOT NULL auto_increment, `name` varchar(50... 阅读全文

posted @ 2008-05-29 10:51 G_G 阅读(5270) | 评论 (6) | 编辑收藏

spring 与 hibernate 整合(事务)

参考：第 9 章事务管理 - Spring Framework reference 2.0.5 参考手册中文版
http://doc.javanb.com/spring-framework-reference-zh-2-0-5/ch09.html

先从配置文件开始：
源码：springAop.rar

需要jar

<?xml version="1.0" encoding="UTF-8"?>
<classpath>
    <classpathentry kind="src" path="java"/>
    <classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
    <classpathentry kind="lib" path="lib/aspectjrt.jar"/>
    <classpathentry kind="lib" path="lib/aspectjweaver.jar"/>
    <classpathentry kind="lib" path="lib/spring.jar"/>
    <classpathentry kind="lib" path="lib/spring-sources.jar"/>
    <classpathentry kind="lib" path="lib/commons-logging-1.0.4.jar"/>
    <classpathentry kind="lib" path="lib/cglib-nodep-2.1_3.jar"/>
    <classpathentry kind="lib" path="lib/hibernate3.jar"/>
    <classpathentry kind="lib" path="lib/log4j-1.2.11.jar"/>
    <classpathentry kind="con" path="org.eclipse.jdt.junit.JUNIT_CONTAINER/4"/>
    <classpathentry kind="lib" path="lib/dom4j-1.6.1.jar"/>
    <classpathentry kind="lib" path="lib/commons-collections-2.1.1.jar"/>
    <classpathentry kind="lib" path="lib/mysql.jar"/>
    <classpathentry kind="lib" path="lib/jta.jar"/>
    <classpathentry kind="lib" path="lib/antlr-2.7.6.jar"/>
    <classpathentry kind="output" path="bin"/>
</classpath>

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: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.0.xsd
  http://www.springframework.org/schema/aop
  http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
  http://www.springframework.org/schema/tx
  http://www.springframework.org/schema/tx/spring-tx-2.0.xsd">

    
    <import resource="demo_spring.xml" />
    

    <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/aop?characterEncoding=utf8">
        </property>
        <property name="username" value="root"></property>
        <property name="password" value=""></property>
    </bean>

    
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        
        <property name="dataSource" ref="dataSource" />
        <property name="configLocation"
            value="classpath:hibernate.cfg.xml" />
    </bean>

    
    <bean id="txManager"
        class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>

    
    <aop:config>
        
        <aop:pointcut id="demoAopBean"
            expression="execution(* demo*.*.*(..))" />
        <aop:advisor advice-ref="demoTxAdvice"
            pointcut-ref="demoAopBean" />
    </aop:config>

    
    <tx:advice id="demoTxAdvice" transaction-manager="txManager">
        <tx:attributes>
            <tx:method name="get*" propagation="SUPPORTS"
                read-only="true" rollback-for="NoProductInStockException" />
            <tx:method name="save*" propagation="REQUIRED"
                rollback-for="NoProductInStockException" />
            <tx:method name="update*" propagation="REQUIRED"
                rollback-for="NoProductInStockException" />
            <tx:method name="remove*" propagation="REQUIRED"
                rollback-for="NoProductInStockException" />
            <tx:method name="*" propagation="SUPPORTS"
                rollback-for="NoProductInStockException" />
        </tx:attributes>
    </tx:advice>

    
    <bean id="beanDao"
        class="demo.springHibernate.dao.imp.BeanDaoImp">
        <property name="sessionFactory">
            <ref bean="sessionFactory"></ref>
        </property>
    </bean>

    <bean id="helloAction" class="demo.struts2Spring.HelloWorld"
        scope="prototype">
        <property name="bds" ref="beanDao"></property>
    </bean>

</beans>

hibernate 配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory name="asdf">
    <property name="hibernate.dialect">mysql</property>
    <property name="myeclipse.connection.profile">
        com.mysql.jdbc.Driver
    </property>
    <property name="connection.url">
        jdbc:mysql://localhost/aop
    </property>
    <property name="show_sql">true</property>

    <property name="connection.username">root</property>
    <property name="connection.password"></property>
    <property name="connection.driver_class">
        com.mysql.jdbc.Driver
    </property>
    <property name="dialect">
        org.hibernate.dialect.MySQLDialect
    </property>

    <mapping resource="bean/UnitBean.hbm.xml" />

</session-factory>
</hibernate-configuration>

dao 类（接口）

package dao.imp;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import bean.UnitBean;

import dao.BeanDao;

public class BeanDaoImp extends HibernateDaoSupport implements BeanDao{
    public void addBean(UnitBean unitBean) {
        this.getHibernateTemplate().save(unitBean);
    }

    public List<UnitBean> getBeanByAll() {
        return this.getHibernateTemplate().find(" from "+UnitBean.class.getName());
    }

    public void removeBean(long beanId) {
        this.getHibernateTemplate().delete(
                getHibernateTemplate().get(UnitBean.class, beanId)
            );
    }

}

Main 类

package unit;

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

import dao.BeanDao;
import bean.UnitBean;

public class Main {
    public static void main(String[] args) {
           ApplicationContext ctx = new ClassPathXmlApplicationContext("beans.xml");
           BeanDao dao = (BeanDao) ctx.getBean("beanDao");
           UnitBean bean = new UnitBean();
           bean.setName("xx");
           bean.setPass("11");
           dao.addBean(bean);

           for(UnitBean unitBean : dao.getBeanByAll() ){
               System.out.println( unitBean.getId() );
           }

           dao.removeBean(bean.getId());

    }
}

结果：
Hibernate: insert into bean (name, pass) values (?, ?)
Hibernate: select unitbean0_.id as id0_, unitbean0_.name as name0_, unitbean0_.pass as pass0_ from bean unitbean0_
1
Hibernate: select unitbean0_.id as id0_0_, unitbean0_.name as name0_0_, unitbean0_.pass as pass0_0_ from bean unitbean0_ where unitbean0_.id=?
Hibernate: delete from bean where id=?

posted @ 2008-05-09 13:47 G_G 阅读(3148) | 评论 (0) | 编辑收藏

spring AspectJ 基本使用

我的aop 基础

AOP(3)

spring 实际使用（这就使用一个例子说明）

测试类以及结果：

package unit;

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

import bean.HelloService;

public class Main {
    public static void main(String[] args) {
           ApplicationContext context = new ClassPathXmlApplicationContext(
                   "beans.xml");
           HelloService service = (HelloService) context.getBean("helloService");
           service.annotationAop();

           System.out.println();

           service.xmlAop();

    }
}
结果：
annotationAop//正常方法运行
aop--AspectJ! //annotation拦截

xmlAop //正常方法运行
aop--XmlAop! //配置拦截

use jar

--aspectjrt.jar
--aspectjweaver.jar
--acglib-nodep-2.1_3.jar
--commons-logging.jar
--spring.jar
--spring-aspects.jar

XML配置

HelloService.java

package bean;

public class HelloService {
    public void annotationAop() {
        System.out.println(" annotationAop ");
    }

    public void xmlAop(){
        System.out.println(" xmlAop ");
    }
}

AnnotationAspectJ.java

package aop;

import org.aspectj.lang.annotation.AfterReturning;
import org.aspectj.lang.annotation.Aspect;
import org.aspectj.lang.annotation.Pointcut;

@Aspect
public class AnnotationAspectJ {
    @Pointcut("execution(* annotationAop(..))")
    public void mainMethod() {}

    @AfterReturning("mainMethod()")
    public void sayHello() {
        System.out.println("aop--AspectJ!");
    }
}

XmlAspectJ.java

package aop;

public class XmlAspectJ {
    public void goXmlAop(){
        System.out.println(" aop--XmlAop! ");
    }
}

posted @ 2008-05-08 10:08 G_G 阅读(4319) | 评论 (1) | 编辑收藏

java regex 正则部分高级特性使用

这就不介绍了代码上：

package unit;

import java.util.regex.Matcher;
import java.util.regex.Pattern;

import org.junit.Assert;
import org.junit.Test;

public class RegexUnit {

    @Test
    /**
     * <p>向前\向后查找</p>
     */
    public void unit9()throws Exception{
        String testStr = "http://www.google.com";

        /* 一般查找
         * .+(:) 查询出结果包含 :
         */
        Pattern pattern = Pattern.compile(".+(:)");
        Matcher matcher =  pattern.matcher(testStr);
            Assert.assertTrue("错误：查找出结果通过 .+(:) 此regex没有包含 : ",
                    matcher.find() && matcher.group().equals("http:") );

        /*  向前查找
         *  .+(?=:) 查询结果不包含 :
         */
        Pattern pattern2 = Pattern.compile(".+(?=:)");
        Matcher matcher2 = pattern2.matcher(testStr);
            Assert.assertTrue("错误：查找出结果通过 .+(?=:) 此regex有包含 : ",
                    matcher2.find()&& matcher2.group().equals("http"));
        /* 向后查找
         * (?<=:).+
         */
        Pattern pattern3 = Pattern.compile("(?<=://).+");
        Matcher matcher3 = pattern3.matcher(testStr);
            Assert.assertTrue("错误：查找出结果包含 http:// 不向后查询",
                    matcher3.find()&& matcher3.group().equals("www.google.com") );
    }

    @Test
    /** 回朔应用
     *  查询回朔、回朔替换、回朔大小写替换
     */
    public void unit8()throws Exception{
        String testStr = "this is a block of of test,"+
                            " several words here are are " +
                            " repeated , and and they should not be. ";

        Pattern pattern = Pattern.compile("[ ]+(\\w+)[ ]+\\1");
        Matcher matcher = pattern.matcher(testStr);
        //查询结果 are are
        Assert.assertTrue("错误：regex 不匹配 ",
                matcher.find()&&matcher.group().split(" ").length>=2 );

        while( matcher.find() ){
            Assert.assertTrue("错误：regex 不匹配 ",
                    matcher.group().split(" ").length>=2 );
        }


        //替换
        String testStr2s = "313-555-1234";
        Pattern pattern2 = Pattern.compile("(\\d{3})(-)(\\d{3})(-)(\\d{4})");
        Matcher mtmp =  pattern2.matcher(testStr2s);
        Assert.assertTrue("错误：没有查替换",
                mtmp.find() &&
                    mtmp.replaceAll("($1) $3-$5").equals("(313) 555-1234") );


        /*大小写替换(java 不能成功)
         *  \E 结束 \L 或 \U转换
         *  \l  \L 把下一个字符(串)换为小写
         *  \ u  \U 把下一个字符(串)转换为大写
       * 此中 (.*?)懒散加载
         */
        String testStr3 = "tt:google:xx";
        Pattern pattern3 = Pattern.compile("(?<=:)(.*?)(?=:)");
        Matcher matcher2 = pattern3.matcher(testStr3);
        if( matcher2.find())
            System.out.println( matcher2.group() ) ;
    }


}

posted @ 2008-05-04 09:59 G_G 阅读(2261) | 评论 (3) | 编辑收藏

mysql 权限控制笔记

MySQL 存取控制包含2个阶段：

阶段1：服务器检查是否允许你连接。
阶段2：假定你能连接，服务器检查你发出的每个请求。看你是否有足够的权限实施它。例如，如果你从数据库表中选择(select)行或从数据库删除表，服务器确定你对表有SELECT权限或对数据库有DROP权限。

参考： 5.8. MySQL用户账户管理

1.权限查看

mysql> show grants for 'root'@'localhost' ;
+---------------------------------------------------------------------+
| Grants for root@localhost |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+
1 row in set (0.06 sec)

2.权限设置
5.8.2. 向MySQL增加新用户账户

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     IDENTIFIED BY 'some_pass';

mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
   其中两个账户有相同的用户名monty和密码some_pass。两个账户均为超级用户账户，具有完全的权限可以做任何事情。一个账户 ('monty'@'localhost')只用于从本机连接时。另一个账户('monty'@'%')可用于从其它主机连接。

mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
该账户只用于从本机连接。授予了RELOAD和PROCESS管理权限。这些权限允许admin用户执行mysqladmin reload、mysqladmin refresh和mysqladmin flush-xxx命令，以及mysqladmin processlist。未授予访问数据库的权限。你可以通过GRANT语句添加此类权限。

mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';
    一个账户有用户名dummy，没有密码。该账户只用于从本机连接。未授予权限。通过GRANT语句中的USAGE权限，你可以创建账户而不授予任何权限。它可以将所有全局权限设为'N'。假定你将在以后将具体权限授予该账户。

下面的例子创建3个账户，允许它们访问专用数据库。每个账户的用户名为custom，密码为obscure。

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    ->     ON bankaccount.*
    ->     TO 'custom'@'localhost'
    ->     IDENTIFIED BY 'obscure';

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    ->     ON expenses.*
    ->     TO 'custom'@'whitehouse.gov'
    ->     IDENTIFIED BY 'obscure';

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    ->     ON customer.*
    ->     TO 'custom'@'server.domain'
    ->     IDENTIFIED BY 'obscure';

这3个账户可以用于：

·         第1个账户可以访问bankaccount数据库，但只能从本机访问。

·         第2个账户可以访问expenses数据库，但只能从主机whitehouse.gov访问。

·         第3个账户可以访问customer数据库，但只能从主机server.domain访问。

要想不用GRANT设置custom账户，使用INSERT语句直接修改授权表：

5.8.3. 从MySQL删除用户账户

DROP USER user;

posted @ 2008-04-29 13:52 G_G 阅读(11665) | 评论 (3) | 编辑收藏

mysql 游标使用

请使用 mysql 1.5 或以上version;
测试表 level ;
create table test.level (name varchar(20));
再 insert 些数据 ;

/*初始化*/
drop procedure if exists  useCursor //

/*建立存储过程 create */
CREATE PROCEDURE useCursor()
    BEGIN
    /*局部变量的定义 declare*/
         declare tmpName varchar(20) default '' ;
         declare allName varchar(255) default '' ;

         declare cur1 CURSOR FOR SELECT name FROM test.level ;

         /*    mysql 不知道为什么用异常加入判断？
          *    此请参考官方文档 20.2.11. 光标光标
          *        这把游标异常后捕捉
          *        并设置循环使用变量 tmpname 为 null 跳出循环。
          */
         declare CONTINUE HANDLER FOR SQLSTATE '02000' SET tmpname = null;


    /*开游标*/
     OPEN cur1;
         /*游标向下走一步*/
         FETCH cur1 INTO tmpName;

         /* 循环体这很明显把游标查询出的 name 都加起并用 ; 号隔开 */
      WHILE ( tmpname is not null) DO
          set tmpName = CONCAT(tmpName ,";") ;
        set allName = CONCAT(allName ,tmpName) ;
        /*游标向下走一步*/
        FETCH cur1 INTO tmpName;
      END WHILE;

    CLOSE cur1;

    select allName ;
END;//
call useCursor()//

运行结果：

mysql> call useCursor()//
+--------------------------------------+
| allName |
+--------------------------------------+
| f1;c3;c6;c5;c2;c4;c1;f1;f3;f4;f2;f5; |
+--------------------------------------+
1 row in set (0.00 sec)

posted @ 2008-04-27 17:05 G_G 阅读(7115) | 评论 (0) | 编辑收藏

Hibernate 数据结构（树、多对多结构表示）

摘要: level 类：Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->package hbm;import java.util.Set;/** * @hibernate.class table = "level" * where = " visible = ... 阅读全文

posted @ 2008-04-26 18:30 G_G 阅读(2394) | 评论 (0) | 编辑收藏

ant hbm 使用

你可以参考：快速修改 xdoclet samples ant -build.xml 适应实际开发
此文档为上面的改进版。

1.在你电脑上建一个 ant第三方扩展文件夹，我这为:D:\ant\lib
2.当使用 eclipse->window->proferences..->ant->Runtime->Global Entries->Add External JARs->选择你建的 ant_lib 下的全部jar;
3.并在Global Entries下加入你的 classpath

使用现成的 xdoclet ant -> 加入自己的 ->

成功后就可以：
    使用 xdoclet 面向对象建表；
    通过 ant -> java2hbn, hbn2ddl,insertSql

在开发过程中当要加 jar 方法为：
    1.在 ant_lib 中加入 jar
    2.eclipse ->> Global Entries->Add External JARs->
工程转换修改 Global Entries中的classpath

例：
java

package hbm;

import java.util.Set;

/**
* @hibernate.class table = "level"
* where = " visible = 0  "
* @author Administrator
*
*/
public class Level {
    private long id ;
    private String name ;
    private Level father ;
    private Set<Level> childSet ;
    private int visible  ;

    public Level(){}
    public Level(String name){  this.name = name ; }

    public Level(String name,int visible){this.visible = visible;  this.name = name ; }
    /**
     * @hibernate.id generator-class = "identity"
     * @return
     */
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    /**
     * @hibernate.property
     * length = "20"
     * @return
     */
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }

    /**
     * @hibernate.many-to-one
     * cascade = "save-update"
     * inverse = "false"
     * column = "fid"
     * @return
     */
    public Level getFather() {
        return father;
    }
    public void setFather(Level father) {
        this.father = father;
    }

    /**
     * @hibernate.set
     * lazy = "true"
     * table = "Level"
     * cascade = "save-update"
     * where = " visible = 0 "
     * @hibernate.collection-key column = "fid"
     * @hibernate.collection-one-to-many class = "hbm.Level"
     * @return
     */
    public Set<Level> getChildSet() {
        return childSet;
    }
    public void setChildSet(Set<Level> childSet) {
        this.childSet = childSet;
    }

    /**
     * @hibernate.property
     * @return
     */
    public int getVisible() {
        return visible;
    }
    public void setVisible(int visible) {
        this.visible = visible;
    }
}

unit

package test;

import java.util.HashSet;
import java.util.List;
import java.util.Set;

import hbm.Level;

import org.hibernate.Hibernate;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.junit.Test;

import unit.HibernateUtil;

public class HbnUnit {
    @Test
    public void level() throws Exception {
        Session session = HibernateUtil.currentSession();
        Transaction tr =  session.beginTransaction();

        Level level = new Level();
        level.setName("f1");

        Set<Level> set = new HashSet<Level>();
            set.add(new Level("c1"));
            set.add(new Level("c2",1));
            set.add(new Level("c3"));
            set.add(new Level("c4",1 ));
            set.add(new Level("c5" ));
            set.add(new Level("c6",1 ));

        level.setChildSet(set);
        session.save(level);
        session.flush() ;
        session.clear();
        tr.commit();


    }

    @Test
    public void sAll() throws Exception {
        Session session = HibernateUtil.currentSession();

        System.out.println("---------------------------------------------");
        List<Level> list =  session.createQuery(" from Level tl where tl.father is null ").list();
        for( Level tmp : list ){
            System.out.println("---->" + tmp.getName()+" visible="+tmp.getVisible()  );

            for(  Level tt : tmp.getChildSet() ){
                System.out.println( tt.getName()+" visible="+tt.getVisible()  );
            }

        }
        System.out.println( list.get(0).getVisible()+":"+ list.size() );
    }

}

结果：

Hibernate: insert into level (name, fid, visible) values (?, ?, ?)
Hibernate: insert into level (name, fid, visible) values (?, ?, ?)
Hibernate: insert into level (name, fid, visible) values (?, ?, ?)
Hibernate: insert into level (name, fid, visible) values (?, ?, ?)
Hibernate: insert into level (name, fid, visible) values (?, ?, ?)
Hibernate: insert into level (name, fid, visible) values (?, ?, ?)
Hibernate: insert into level (name, fid, visible) values (?, ?, ?)
Hibernate: update level set fid=? where id=?
Hibernate: update level set fid=? where id=?
Hibernate: update level set fid=? where id=?
Hibernate: update level set fid=? where id=?
Hibernate: update level set fid=? where id=?
Hibernate: update level set fid=? where id=?
---------------------------------------------
Hibernate: select level0_.id as id0_, level0_.name as name0_, level0_.fid as fid0_, level0_.visible as visible0_ from level level0_ where ( level0_.visible = 0 ) and (level0_.fid is null)
---->f1 visible=0
Hibernate: select childset0_.fid as fid1_, childset0_.id as id1_, childset0_.id as id0_0_, childset0_.name as name0_0_, childset0_.fid as fid0_0_, childset0_.visible as visible0_0_ from level childset0_ where ( childset0_.visible = 0 ) and childset0_.fid=?
c1 visible=0
c5 visible=0
c3 visible=0
0:1

posted @ 2008-04-25 11:31 G_G 阅读(1723) | 评论 (0) | 编辑收藏

开发 javascript div 扩展使用

此代码可以直接使用

<body>
<a id='pi' href="" value="text"> text </a>
<div id='div1'/>
</body>
<script type="text/javascript">

function showByEvent(ev,divId){
        //取得各浏览器 event
        ev = ev || window.event;
        //div
        var useDiv  = document.getElementById(divId);
        useDiv.style.position="absolute";
            if( useDiv.style.left=="" )useDiv.style.left = "50";
            if( useDiv.style.top=="" )useDiv.style.top = "10";
            if( useDiv.style.zIndex=="" )useDiv.style.zIndex = "1000";
            if( useDiv.style.padding=="" )useDiv.style.padding = "0px";
            if( useDiv.style.backgroundColor=="" )useDiv.style.backgroundColor = "#FFFFCC";
            if( useDiv.style.color=="" )useDiv.style.color = "#201000";
            if( useDiv.style.fontSize=="" )useDiv.style.fontSize = "12px";
            if( useDiv.style.border=="" )useDiv.style.border ="1px   solid   #284860";

        //得到处发事件的源element
      var actionBean =  null ;
        if(  ev.srcElement ){
            actionBean = ev.srcElement
        }else{
            actionBean = ev.target;
        }

        //处发事件
        useDiv.onmousemove = function(){
                useDiv.style.visibility  = "";
        }
        useDiv.onmouseout = function(){
                useDiv.style.visibility  = "hidden";

        }
        actionBean.onmouseout =  function mouseOut(ev){
                useDiv.style.visibility  = "hidden";
        }

        //div 定位
        useDiv.style.left = actionBean.offsetTop+15 ;
    useDiv.style.top = actionBean.offsetLeft+15;

        //返回类型为 div 显示的 x , y 和 target 处发源项和 div
        return {
            y:  actionBean.offsetTop+15  ,
            x:  actionBean.offsetLeft+15 ,
            target:actionBean,
            div:useDiv
        }
}

//事件添加
document.getElementById('pi').onmousemove = function(ev){
      var sbv = showByEvent(ev,"div1");
      var bean = sbv.target ;
    var dd = sbv.div;
    dd.style.visibility  = "";
    dd.innerHTML = "<a href=http://www.baidu.com>删除"+bean.value+"</a><br>"+
                                    "<a href=http://www.google.com>详细 by Id "+bean.id+"</a>";

};

</script>

posted @ 2008-04-23 17:41 G_G 阅读(1617) | 评论 (1) | 编辑收藏

struct 2 apps 学习（1）

struts2-blank-2.0.11.1.war

web.xml:

<? xml version="1.0" encoding="UTF-8" ?>
< web-app id ="WebApp_9" version ="2.4" xmlns ="http://java.sun.com/xml/ns/j2ee" xmlns:xsi ="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation ="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" >

     < display-name > Struts Blank </ display-name >

     < filter >
         < filter-name > struts2 </ filter-name >

    
     < filter-class > org.apache.struts2.dispatcher.FilterDispatcher </ filter-class > </ filter >

     
     < filter-mapping >
         < filter-name > struts2 </ filter-name >
         < url-pattern > /* </ url-pattern >
     </ filter-mapping >

     
     < welcome-file-list >
         < welcome-file > index.html </ welcome-file >
     </ welcome-file-list >

</ web-app >

index.html:

< head >
        
        < META HTTP-EQUIV ="Refresh" CONTENT ="0;URL=example/HelloWorld.action" >
    </ head >

struct.xml

< include file ="example.xml" />

example.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
        "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
        "http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
    
    <package name="example" namespace="/example" extends="struts-default">

        
        <action name="HelloWorld" class="example.HelloWorld">
            <result>/example/HelloWorld.jsp</result>
        </action>

<action name="Login_*" method="{1}" class="example.Login">
            <result name="input">/example/Login.jsp</result>
            <result type="redirect-action">Menu</result>
        </action>

java

Login-validation.xml

<action name="*" class="example.ExampleSupport">
            <result>/example/{1}.jsp</result>
        </action>

        
    </package>
</struts>

posted @ 2008-04-21 17:51 G_G 阅读(1210) | 评论 (0) | 编辑收藏

javascript 上传文件大小限定

js 上

限制：<input type="text" size="4" value="10" name="fileSizeLimit" id="fileSizeLimit"/> K
<input type="file" name="file1" id="file1" size="40" onchange="changeSrc(this)"/>
<br>
<img src=http://blog.xunuo.com/blog/images/icons/23.gif id="fileChecker" alt="test"/>

<script type="text/javascript">
var oFileChecker = document.getElementById("fileChecker");

function changeSrc(filePicker)
{
    oFileChecker.src = filePicker.value;
}

oFileChecker.onreadystatechange = function ()
{
    if (oFileChecker.readyState == "complete")
    {
        checkSize();
    }
}

function checkSize()
{
    var limit  = document.getElementById("fileSizeLimit").value * 1024;

    if (oFileChecker.fileSize > limit)
    {
        alert("too large");
    }
    else
    {
        alert("ok");
    }
}
</script>

IE

posted @ 2008-04-15 18:07 G_G 阅读(1600) | 评论 (0) | 编辑收藏

javascript 鼠标跟随+位置显示

参考 :http://www.codebit.cn/pub/html/javascript/tip/mouse_position/

直接运行

posted @ 2008-04-15 13:41 G_G 阅读(3056) | 评论 (2) | 编辑收藏

权限设计的探讨阅读后感

权限设计的探讨阅读后感

文章路径：http://www.chinaitpower.com/A200508/2005-08-07/183934.html

权限设计通常包括数据库设计、应用程序接口(API)设计、程序实现三个部分。

权限分类：

首先是针对数据存取的权限，通常有录入、浏览、修改、删除四种。

其次是功能，它可以包括例如统计等所有非直接数据存取操作，另外，我们还可能对一些关键数据表某些字段的存取进行限制。

权限表及相关内容大体可以用六个表来描述，如下：
1 拥有权限角色（即用户组）：具体拥有权限描述实体。

2 用户表：用户的描述，其它（如地址、电话等信息）；
3 角色-用户对应表：该表记录用户与角色之间的对应关系(多对多关系)，一个用户可以隶属于多个角色，一个角色组也可拥有多个用户。

4 权限列表：程序所有权限列表。该表记录所有要加以控制的权限，如录入、修改、删除、执行等；
5 权限-角色-用户对应表：权限对应角色(多对多关系)再由4表关系到用户。

在探讨文中的第4条，我怎么都不太理解？望大家探讨。反向权限吗？那怎么和系统中的拥有一起描述？

下面提出一些自己的见解：

1 用户表：用户的描述，其它（如地址、电话等信息）；

2 权限列表：程序所有权限列表。该表记录所有要加以控制的权限，如录入、修改、删除、执行等；
3 权限树（模糊看成角色，但有些不同。树性结构，结构数据库中表外键自己）：孩子接点继承父亲接点全部权限，并在次上扩充和删减权限建立自己分支。

4 权限列表-权限树：（多对多关系）用于描述此权限树接点对父亲接点权限继承下，由自己添加和消减的权限；

本表中用一列枚举列用于表示本纪录是添加或删减权限。

5 用户-权限树：权限树接点对应用户（多对一）关系。

感觉自己的这种框架，能很好的扩充（在某接点下增，删某权限或直接找到最向近的一个权限树接点并继承）

大家多说说自己的见解，和对比下这两个框架的一些优缺点把。本人随时恭听。G_G

与2008-4-7 22:50北京

google doc 原稿： http://docs.google.com/Doc?id=dkvfctc_16hgvfkbfs

posted @ 2008-04-07 22:49 G_G 阅读(2808) | 评论 (6) | 编辑收藏

Hibernate 级联添加删除

问题描述：实体类答案从属于实体类问题。（一对多）
效果-》

    /**
     * 添加问题和选项
     * @throws Exception
     */@Test
    public void testQu() throws Exception {
        Session session = HibernateUtil.currentSession();
        Transaction tr = session.beginTransaction();

        //级联添加
        Set options = new HashSet();
        Options op1 = new Options();
        op1.setName("op1");
        options.add(op1);


        Options op2 = new Options();
        op2.setName("op2");
        options.add(op2);


        Options op3 = new Options();
        op3.setName("op3");
        options.add(op3);
        Problems problems = new Problems();

        problems.setName("problem_1");
        problems.setOptions(options);
        problems.setTdesc("tdesc");
        problems.setType(1);

        Long ll = (Long)session.save(problems);


        System.out.println(ll);
        tr.commit();

mysql> select * from options ;
+----+------------+--------+------+---------+
| id | problemsid | answer | name | visible |
+----+------------+--------+------+---------+
| 1 |          1 |   NULL | op2 |       0 |
| 2 |          1 |   NULL | op3 |       0 |
| 3 |          1 |   NULL | op1 |       0 |
+----+------------+--------+------+---------+
3 rows in set (0.00 sec)

mysql> select * from problems ;
+----+-----------+------+-------+------------+---------+
| id | name      | type | tdesc | questionid | visible |
+----+-----------+------+-------+------------+---------+
| 1 | problem_1 |    1 | tdesc |       NULL |       0 |
+----+-----------+------+-------+------------+---------+
1 row in set (0.00 sec)


        //级联删除
        tr.begin();
            session.delete( session.get(Problems.class,ll) );
        tr.commit();

mysql> select * from problems ;
Empty set (0.00 sec)

mysql> select * from options ;
Empty set (0.00 sec)

        HibernateUtil.closeSession();
    }

Options类

.......
    /**
     * @hibernate.many-to-one
     *         cascade = "save-update"
     *         column = "Problemsid"
     *         class = "com.zhongqi.domain.Problems"
     * @return
     */
    public Problems getProblems() {
        return problems;
    }
............

Problems 类

    /**
     * @hibernate.set
     *         cascade="all-delete-orphan"
     *         inverse = "false"
     *         lazy = "true"
     *         @hibernate.collection-key  column = "problemsid"
     *         @hibernate.collection-one-to-many class = "com.zhongqi.domain.Options"
     * @return
     */
    public Set getOptions() {
        return options;
    }

posted @ 2008-04-02 10:07 G_G 阅读(2087) | 评论 (2) | 编辑收藏

分页乱码问题（解决）

上一个blog中粗略的使用了下分页标签使用 pg
使用问题还是有很多如分页中乱码、多java代码块
下面用一个 <jsp:include >来解决这些问题。

<jsp:include page="../jspUtil/page.jsp">
        <jsp:param name="count" value="<%=OrderServiceImp.getOrdersCount(beginTime,endTime,userName,companyName,productName,null,zq)%>"  />
            <jsp:param name="maxPageItems" value="10" />

            <jsp:param name="goUrl" value="/zhongqi/seleProduct.do" />

        <jsp:param name="params" value="beginTime" />
        <jsp:param name="params" value="endTime" />
        <jsp:param name="params" value="userName" />
        <jsp:param name="params" value="companyName"/>
        <jsp:param name="params" value="productName" />

    </jsp:include>

page.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="java.net.URLEncoder"%>
<%@page import="java.net.URLDecoder"%>
<%@ taglib prefix="pg" uri="/WEB-INF/pager-taglib.tld" %>

<%
    int count = Integer.parseInt( request.getParameter("count") );
    int maxPageItems = Integer.parseInt( request.getParameter("maxPageItems")==null?"10":request.getParameter("maxPageItems") );

    //参数设置 <jsp:param name="params" value="xx"  />
    String[] params = (String[])request.getParameterMap().get("params");

    String goUrl = request.getParameter("goUrl");

%>
<div id="bgee">
<div align="center">
<pg:pager
  id="pager"
  url="<%=goUrl%>"
  items='<%=count%>'
  maxPageItems="<%=maxPageItems %>"
  export="offset,currentPageNumber=pageNumber"
  isOffset="false"
  scope="request">

   <%
    for( String str : params ) {
        if (request.getParameter(str) != null && !request.getParameter(str).equals("")) {%>
                <pg:param name="<%=str %>" value='<%= URLEncoder.encode( URLDecoder.decode(request.getParameter(str),"utf-8"),"utf-8")%>'/>
        <% }
    }%>

<pg:index>
<pg:prev ifnull="true">
<span>
      <% if (pageUrl != null) { %>
        <A HREF="<%= pageUrl %>">< 上一页</A>
      <% } %>
</span>
</pg:prev>

  <pg:pages export="pageUrl, pageNumber">
<% if (pageNumber == currentPageNumber) { %>
<span><%= pageNumber %></span>
<%} else {%>
<a href='<%=pageUrl%>'><%= pageNumber %></a>
<%}%>
</pg:pages>
<pg:next ifnull="true">
<% if (pageUrl != null) { %>
  <a href='<%=pageUrl%>'>下一页 ></a>
<%}%>
</pg:next>
</pg:index>
</pg:pager>
    </div>
</div>

posted @ 2008-04-01 16:13 G_G 阅读(2084) | 评论 (1) | 编辑收藏

5.8.3. 从MySQL删除用户账户

DROP USER user;

日历

公告

常用链接

留言簿(13)

随笔分类

随笔档案

文章档案

相册

hibernate

My连接

搜索

最新评论

阅读排行榜

评论排行榜