페이징 처리 1! 현재 볼 페이지 정보와 디비에 게시물 갯수 정보를 가지고
현재페이지 -> 현재, 처음, 끝
맨처음페이지 ->>>이 정보들을 찾아내는거
맨끝페이지
페이징 처리 2! 현재 페이지에 해당하는 게시물들을 쿼리하기
웹프로젝트 생성
Spring Core
Spring Context
Spring JDBC
MySQL JDBC Type 4 driver
1. Mybatis132 usages
org.mybatis » mybatisapache
The MyBatis SQL mapper framework makes it easier to use a relational database with object-oriented applications. MyBatis couples objects with stored procedures or SQL statements using a XML descriptor or annotations. Simplicity is the biggest advantage of the MyBatis data mapper over object relational mapping tools.
2. Mybatis Spring53 usages
org.mybatis » mybatis-springapache
An easy-to-use Spring bridge for MyBatis sql mapping framework.
The runtime needed to execute a program using AspectJ
The AspectJ weaver introduces advices to java classes
The Apache Commons IO library contains utility classes, stream implementations, file filters, file comparators, endian transformation classes, and much more.
The Apache Commons FileUpload component provides a simple yet flexible means of adding support for multipart file upload functionality to servlets and web applications.
Tags: apache
라이브러리 셋팅
dispatcher-servlet, encodingFilter, contextLoaderListener를 web.xml에 등록
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | <servlet> <servlet-name>dispatcher</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/dispatcher-servlet.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>dispatcher</servlet-name> <url-pattern>*.do</url-pattern> </servlet-mapping> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/applicationContext.xml</param-value> </context-param> <filter> <filter-name>encodingFilter</filter-name> <filter-class> org.springframework.web.filter.CharacterEncodingFilter </filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>encodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> | cs |
dispatcher-servlet파일 생성, ViewResolver등록// applicationContext.xml 파일 생성, dataSource, sqlSessionFactory 등록
1 2 3 4 5 | <context:component-scan base-package="controller"></context:component-scan> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="jsp/"></property> <property name="suffix" value=".jsp"></property> </bean> | cs |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | <context:component-scan base-package="service"></context:component-scan> <bean class="org.apache.commons.dbcp.BasicDataSource" id="dataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <property name="url" value="jdbc:mysql://localhost/주소"></property> <property name="username" value="root"></property> <property name="password" value="비밀번호"></property> <property name="maxActive" value="8"></property> <property name="maxIdle" value="8"></property> <property name="minIdle" value="0"></property> <property name="initialSize" value="0"></property> </bean> <!-- <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> --> <!-- </bean> --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="mapperLocations" value="classpath:dao/mapper"></property> <property name="typeAliasesPackage" value="model"></property> <property name="dataSource" ref="dataSource"></property> </bean> <bean class="org.mybatis.spring.mapper.MapperFactoryBean"> <property name="mapperInterface" value="dao.BoardDao"></property> <property name="sqlSessionFactory" ref="sqlSessionFactory"></property> </bean> | cs |
' IOT 기반 응용 SW과정 > Web Programing' 카테고리의 다른 글
| Day73 (0) | 2016.07.01 |
|---|---|
| Day72 스프링 게시판 (0) | 2016.06.30 |
| Day69 API -jason (1) | 2016.06.27 |
| Day68 네이버 API - 책검색 (0) | 2016.06.24 |
| Day67 네이버 API (0) | 2016.06.23 |