spring MVC project using mybatis

한글블로그로 보기

testServer.zip 

I based this posting Install spring framework+maven+tomcat in Eclipse  

1. Add dependency in pom.xml file

Searching and add mybatis

Searching and add mybatis-spring

Searching and add mysql-connector-java 

Searching and add spring-jdbc 

2. Add namespace in root-context.xml file.

Click to  src->main->webapp->WEB-INF->spring->root-context.xml  and Namespaces tab

3. Add bean 

Click to Source tab

Add this code

1.     <bean id="dataSource"
2.         class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
3.         <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
4.         <property name="url" value="jdbc:mysql://localhost/netplug"></property>
5.         <property name="username" value="root"></property>
6.         <property name="password" value="1234"></property>
7.     </bean>
8.        
9.     <bean id="sqlSessionFactory"
10.         class="org.mybatis.spring.SqlSessionFactoryBean">
11.         <property name="dataSource" ref="dataSource"></property>
12.         <property name="configLocation"
13.             value="classpath:mybatis/mybatis-config.xml">
14.         </property>
15.     </bean>
16.    
17.     <bean id="transactionManager"
18.         class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
19.         <property name="dataSource" ref="dataSource"></property>
20.     </bean>
21.    
22.     <bean id="sqlSession"
23.         class="org.mybatis.spring.SqlSessionTemplate">
24.         <constructor-arg  ref="sqlSessionFactory"></constructor-arg>
25.     </bean>

Line4~6 : your mysql setting.

My case schema is netplug and table is 0000dc180000

4. mapper config

Make a package for mapper to src->main->resources

package name is mybatis 

make xml files 

file name is mapper.xml and mybatis-config.xml

mybatis-config.xml

1. <?xml version="1.0" encoding="UTF-8"?>
2. <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD config 3.0//EN"
3. "http://mybatis.org/dtd/mybatis-3-config.dtd">
4.          
5. <configuration>
6.     <mappers>
7.         <mapper resource="mybatis/mapper.xml" />
8.     </mappers >
9. </configuration>

mapper.xml

1. <?xml version="1.0" encoding="UTF-8"?>
2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
3. "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
4. <mapper namespace= "userControlMapper" >
5.     <select id ="selectSample" parameterType="java.util.HashMap" resultType= "java.util.HashMap">
6.         select *
7.         from 0000dc180000
8.        
9.     </select >
10. </mapper>

5. Java coding

Click to locate src->main->java->com->answerofgod->spring->HomeController.java

Maybe different folder.

com.answerofgod.spring is my package name.

HomeController.java

1. @Controller
2. public class HomeController {
3.    
4.     private static final Logger logger = LoggerFactory.getLogger(HomeController.class);
5.    
6.     @Autowired
7.       private SqlSession sqlSession;
8.    
9.     /**
10.      * Simply selects the home view to render by returning its name.
11.      */
12.     @RequestMapping(value = "/", method = RequestMethod.GET)
13.     public String home(Locale locale, Model model) {
14.         logger.info("Welcome home! The client locale is {}.", locale);
15.        
16.         Date date = new Date();
17.         DateFormat dateFormat = DateFormat.getDateTimeInstance(DateFormat.LONG, DateFormat.LONG, locale);
18.        
19.         String formattedDate = dateFormat.format(date);
20.        
21.         model.addAttribute("serverTime", formattedDate );
22.        
23.         List<HashMap<String, String>> outputs = sqlSession.selectList("userControlMapper.selectSample");
24.         model.addAttribute("showDB", outputs.toString());
25.        
26.        
27.         return "home";
28.     }
29.    
30. }

add Line 6~7 and Line 23~24 

6. JSP coding

Click to src->main->webapp->WEB-INF->views->home.jsp

home.jsp

1. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
2. <%@ page session="false" %>
3. <%@ page contentType="text/html; charset=UTF-8" %>
4. <html>
5. <head>
6.     <title>Home</title>
7. </head>
8. <body>
9. <h1>
10.     Hello world!  
11. </h1>
13. <P>  The time on the server is ${serverTime}. </P>
14. <p> This is my Database </p>
15. <p> ${showDB}</p>
16. </body>
17. </html>

add Line 14~15

This is my project directory.

run as-> run on server

Install spring framework+maven+tomcat in Eclipse

한글 블로그에서 보기

My eclipse version is 4.4 Luna.

1. Install Eclipse plugin ( spring framework, maven)

Go eclipse menu Help->Market Place.. 

Searching STS

Install Spring Tool Suite (STS) 

If completed install STS then searching maven.

Install Maven Integration for Eclipse를 설치하세요.

2. Install Tomcat 

Click to  Tomcat download 

Click to 32-bit/64-bit Windows Service Installer for download.

And Install!!

Click to Eclipse menu window->Preferences 

Click to tab Server->Runtime Environments

Click to add

Choose Apache Tomcat v8.0 then Click to Finish.

Click to Edit

Click to Browse.. and choose your tomcat folder.

And choose your JRE then Click to Finish

3. Run Server & Spring MVC project

new->others

Server-> Server

Choose Tomcat v8.0 Server and Click to Finish.

new->others

Spring-> Spring Project

Choose Spring MVC Project and write to Project name

Write to package name and Finish

Run As->Run on Server를 누르시면

If you Korean, add this code in home.jsp 

1. <%@ page contentType="text/html; charset=UTF-8" %>

And refresh browser