posts - 9,comments - 3,trackbacks - 0
posted @ 2007-01-16 13:56 freefly 阅读(142) | 评论 (0)编辑 收藏
  1. create view


             SQLSEVER:    IF EXISTS (SELECT 1
                                                            FROM  sysobjects
                                                            WHERE  idobject_id ('V_FA_ADD_CO')
                                                             AND   type = 'V')
                                    DROP VIEW V_FA_ADD_CO;
                                    CREATE VIEW V_FA_ADD_CO AS

2. the equal between join and (+)
       the table(its fields stay with (+)) right  join another  corresponding   table.
       for example: select * from a,b where
               equals  select * from b rigth join a on
               equals  select * from a left join a on


    3. substr,substring
for example: there is a table's field "userName" and it's value is "wanghuiling".
       sqlserver: substring(userName,0,4) = "wan",substring(userName,1,4) = "wang"
       oracle:  substr(userName,0,4)="wang",substr(userName,1,4)="wang"
 4. link sign
     sqlserver: "+"
5. update a table's some fields

     for example:there are two tables: students1 and students2

     sqlserver:update students     (can't use alias)
                   from students s2 where;
     oracle: update students1 s1
               set (name,sex,age,tel)=
               (select name,sex,age,tel from students2 s2 where;

6. Date
    for example:there are a field of  date type:input_date  and its value is 2007-08-09.   
    sqlserver : year(input_date)=2007,month(input_date)=8,day(input_date)=9
     oracle : to_char(input_date,'YYYY')=2007, to_char(input_date,'MM')=8, to_char(input_date,'DD')=9

     sDate : a java String variable
     sqlserver : input_date = '"+sDate+"' 
     oracle : input_date =  to_char( '" + sDate + "',' 'YYYY-MM-DD'')

posted @ 2006-12-31 15:42 freefly 阅读(490) | 评论 (0)编辑 收藏

      Ultimatelly,I solved my problem.    My work is switch my application from mysql to sqlserver database .   At the very start,I forgot start sqlserver service,so the error "refused connect"  always appear,(so stupid error).Next,ther error  "Hibernate operation: could not execute query; uncategorized SQLException for SQL [select user0_.ID as ID, user0_.USERNAME as USERNAME0_, user0_.PASSWORD as PASSWORD0_ from user user0_]; SQL state [S1000]; error code [156]; 在关键字 'user' 附近有语法错误。; nested exception is java.sql.SQLException: 在关键字 'user' 附近有语法错误."   comes out ,  the problem scratchs my head over .this moring i got one friend's help and eventually found the "user" should not be used as a table name,because "user" is a key in sqlserver.  
      Below is work I have done : (Note: my env is eclipse+myeclipse)
      First:modify applicationContext.xml:
      1.<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
           <property name="driverClassName">
           <property name="url">
           <property name="username">
           <property name="password">
     2. <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
        <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
              <property name="driverClassName">
              <property name="url">
               <property name="username">
               <property name="password">

        <prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
      Second: import the sqlserver driver:jtds-1.1.jar

posted @ 2006-04-11 12:41 freefly 阅读(283) | 评论 (0)编辑 收藏
  1. Background

         Usually,When we develop our web application,we need create menu.We can use Javascript to design web menu,but if thus,we have to compile many codes,and our application hasn't good  revisability and maintainability .Struts-menu provides us a convenient web menu design way,we can put our web menu data in  a menu-config.xml configuration file,and read the data with struts-menu lable.

   2.  Struts  Menu Example
        You can go here to see the example;
        Or download the example application,follow the below instruction:  
               Unzip it to a local directory.  
               Download and install Tomcat or another Java Servlet container.  
               Put struts-menu.war in Tomcat's webapps folder and start the server. 
               Go to http://localhost:8080/struts-menu 

 3.   Integrating Struts Menu into your application

      1.  Place struts-menu-2.3.jar into your app's WEB-INF/lib directory.(maybe you also need put common-lang.jar)
      2.  Place struts-menu.tld,and struts-menu-el.tld into your app's WEB-INF directory
      3.  Copy the common,images,scripts,template,styles directory from the above struts-menu.war exmaple application  to your web directory.(if use Myeclipse,put those directorys in webroot directory)
      4.  Add the plug-in settings to your struts-config.xml file.                 
               <plug-in className="">
                         <set-property property="menuConfig"
        5.  You will need to declare your menu's attributes in a your App /WEB-INF/menu-config.xml file.Here's  a short  snippet of what might look like:        
             <Menu name="contactMenu" title="Contact" location="?Contact">
                  <Item name="email" title="E-Mail" location="?EMail"/>
                  <Item name="phone" title="Phone" location="?Phone"/>
         6.   Add a taglib declaration to the top of your JSP: 

        <%@ taglib uri="" prefix="menu" %>

        7.  Add taglib code to render your menu in your JSP: 

               <menu:useMenuDisplayer name="TabbedMenu"
                    <menu:displayMenu name="Home"/>
                    <menu:displayMenu name="About"/>
       8.  Below is a whole test.jsp
            <%@ page contentType="text/html; charset=UTF-8" %>
            <%@ taglib uri="" prefix="html" %>
            <%@ taglib uri="" prefix="menu" %>
             <html:base />
                 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

                 <link rel="stylesheet" type="text/css" media="screen"
                               href="styles/global.css" />
                      <link rel="stylesheet" type="text/css" media="screen"
                              href="styles/coolmenu.css" />
                <script type="text/javascript" src="scripts/coolmenus4.js"></script>
                <script type="text/javascript" src="scripts/cm_addins.js"></script>
               <script type="text/javascript" src="scripts/coolmenu4-config.js"></script> 
               <menu:useMenuDisplayer name="CoolMenu4"
                   <menu:displayMenu name="Home"/>
                  <menu:displayMenu name="About"/>


posted @ 2006-04-05 15:23 freefly 阅读(446) | 评论 (0)编辑 收藏