batis

전에 리스빵스 사용하던건 다 redirect 사용한다고 보면 됨

바티스투타 폼 미쳤다

mysql 연결

<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>5.1.41</version>
</dependency>

BoardDaoxml 파일

필수로 적어둬야함 (아래 )
<!DOCTYPE mapper	
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybats-3-mapper.dtd">

><mapper namespace="kr.co.batis_board2.BoardDao">
<select id="list">
select *from board order by id desc
</select>
</mapper>

SqlSession

<beans:bean name="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
	<beans:property name="driverClassName" value="com.mysql.jdbc.Driver" />
	<beans:property name="url" value="jdbc:mysql://localhost:3306/mydb" />
	<beans:property name="username" value="root" />
	<beans:property name="password" value="1234" />
</beans:bean>

<beans:bean name="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
   <beans:property name="dataSource" ref="dataSource"></beans:property>
   <beans:property name="mapperLocations" value="classpath:kr/co/batis_page/mapper/*.xml"></beans:property>                                                             
</beans:bean>

<beans:bean name="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
    <beans:constructor-arg ref="sqlSessionFactory"></beans:constructor-arg>
</beans:bean>

dependency 파일다운

<dependency>
		<groupId>org.springframework</groupId>
		<artifactId>spring-jdbc</artifactId>
		<version>4.1.4.RELEASE</version>
</dependency>
	
<dependency>
	    <groupId>org.mybatis</groupId>
	    <artifactId>mybatis</artifactId>
	    <version>3.2.8</version>
</dependency>

<dependency>
	   <groupId>org.mybatis</groupId>
	   <artifactId>mybatis-spring</artifactId>
	   <version>1.2.2</version>
</dependency>

mapper 작성

resultType >> 받아서 사용할때

<mapper namespace="kr.co.batis_board2.dao.BoardDao">
<select id="list" resultType="kr.co.batis_board2.dto.BoardDto">
	select *from board order by id desc
</select>

parameterType >> 안에 값 넣을때

<insert id="write_ok" parameterType="kr.co.batis_board2.dto.BoardDto">
	insert into board(title,name,content,pwd,writeday)
	values(#{title},#{name},#{content},#{pwd},now())
</insert>
</mapper>