jqGrid分页技术学习（二）spring环境准备

从http://www.springsource.org/download下载spring的lib，拷贝到WebContent/WEB-INF/lib目录下：

spring-aop.jar spring-beans.jar spring-context-support.jar spring-context.jar spring-core.jar spring-jdbc.jar spring-test.jar spring-tx.jar spring-web.jar spring-webmvc.jar spring.tld

我使用的版本比较旧，还是2.5，现在应该是3.0了。还需要下载几个jakata的包、mysql的jdbc、json的包：

commons-beanutils-1.8.0.jar commons-collections-3.2.1.jar commons-lang-2.4.jar commons-logging-1.1.1.jar ezmorph-1.0.6.jar json-lib-2.2.3-jdk15.jar mysql-connector-java-3.0.17-ga-bin.jar

WebContent/WEB-INF/web.xml修改如下：

<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5"> <servlet> <servlet-name>goDispatcher</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>goDispatcher</servlet-name> <url-pattern>*.go</url-pattern> </servlet-mapping> <display-name>JQueryDemo</display-name> <welcome-file-list> <welcome-file>index.html</welcome-file> <welcome-file>index.htm</welcome-file> <welcome-file>index.jsp</welcome-file> <welcome-file>default.html</welcome-file> <welcome-file>default.htm</welcome-file> <welcome-file>default.jsp</welcome-file> </welcome-file-list> </web-app>

增加一个配置文件WebContent/WEB-INF/goDispatcher-servlet.xml如下：

<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property> <property name="url"><value>jdbc:mysql://localhost/monitor?useUnicode=true&characterEncoding=UTF-8</value></property> <property name="username"><value>root</value></property> <property name="password"><value>update</value></property> </bean> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref="dataSource" /> </bean> <bean id="tablePagingDao" class="com.thomas.monitor.dao.TablePagingDao"> <property name="jdbcTemplate" ref="jdbcTemplate" /> </bean> <bean name="tablePagingController" class="com.thomas.monitor.mvc.TablePagingController"> <property name="dao" ref="tablePagingDao" /> </bean> <bean name="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping"> <property name="mappings"> <props> <prop key="paging.go">tablePagingController</prop> </props> </property> </bean> </beans>

使用jqgrid_demo38中的database.sql将数据库初始化：

CREATE TABLE `clients` ( `client_id` int(11) NOT NULL auto_increment, `name` char(120) default NULL, PRIMARY KEY (`client_id`) ) ENGINE=MyISAM; insert into `clients`(`client_id`,`name`) values (1,'Client 1'),(2,'Client 2'),(3,'Client 3'); CREATE TABLE `invheader` ( `id` int(11) NOT NULL, `invdate` date NOT NULL, `client_id` int(11) NOT NULL, `amount` decimal(10,2) NOT NULL default '0.00', `tax` decimal(10,2) NOT NULL default '0.00', `total` decimal(10,2) NOT NULL default '0.00', `note` char(100) default NULL, PRIMARY KEY (`id`) ) ; insert into `invheader`(`id`,`invdate`,`client_id`,`amount`,`tax`,`total`,`note`) values (1,'2007-10-01',1,'100.00','20.00','120.00','note 1'),(2,'2007-10-03',1,'200.00','40.00','240.00','note 2'),(3,'2007-10-02',2,'300.00','60.00','360.00','note for invoice 3'),(4,'2007-10-04',3,'150.00','0.00','150.00','no tax'),(5,'2007-10-05',3,'100.00','0.00','100.00','no tax'),(6,'2007-10-05',1,'50.00','10.00','60.00',NULL),(7,'2007-10-05',2,'120.00','12.00','134.00',NULL),(8,'2007-10-06',3,'200.00','0.00','200.00',NULL),(9,'2007-10-06',1,'200.00','40.00','240.00',NULL),(10,'2007-10-06',2,'100.00','20.00','120.00',NULL),(11,'2007-10-06',1,'600.00','120.00','720.00',NULL),(12,'2007-10-06',2,'700.00','140.00','840.00',NULL),(13,'2007-10-06',3,'1000.00','0.00','1000.00',NULL); CREATE TABLE `invlines` ( `id` int(11) NOT NULL, `num` int(11) NOT NULL auto_increment, `item` char(20) default NULL, `qty` decimal(8,2) NOT NULL default '0.00', `unit` decimal(10,2) NOT NULL, PRIMARY KEY (`id`,`num`) ) ENGINE=MyISAM ; insert into `invlines`(`id`,`num`,`item`,`qty`,`unit`) values (1,1,'item 1','1.00','20.00'),(1,2,'item 2','2.00','40.00'),(2,1,'item 1','2.00','20.00'),(2,2,'item 2','4.00','40.00'),(3,1,'item 3','1.00','100.00'),(3,2,'item 4','1.00','200.00'),(4,1,'item 1','1.00','100.00'),(4,2,'item 2','1.00','50.00'),(5,1,'item 3','1.00','100.00'),(6,1,'item 4','1.00','50.00'),(7,1,'item 5','2.00','10.00'),(7,2,'item 1','1.00','100.00'),(8,1,'item 3','1.00','50.00'),(8,2,'item 2','1.00','120.00'),(8,3,'item 3','1.00','30.00'),(9,1,'item 6','1.00','140.00'),(9,2,'item 3','1.00','60.00'),(10,1,'item 5','3.00','10.00'),(10,2,'item 4','1.00','70.00'),(11,1,'item 1','2.00','100.00'),(11,2,'item 2','3.00','50.00'),(11,3,'item 3','1.00','50.00'),(11,4,'item 4','1.00','200.00'),(12,1,'item 4','1.00','300.00'),(12,2,'item 2','1.00','400.00'),(13,1,'item 13','1.00','1000.00'); CREATE TABLE items (item_id INT UNSIGNED not null AUTO_INCREMENT,item VARCHAR (200),item_cd VARCHAR (15),PRIMARY KEY ( item_id )); alter table `invheader` add column `closed` char (3) DEFAULT 'No' NULL after `note`, add column `ship_via` char (3) NULL after `closed`;