maven spring mysql_maven+springMVC+mybatis+mysql详细过程

1、工程目录

a、在src/main/java文件夹中，新建包cn.springmvc.model(存放javabean),

cn.springmvc.dao(存放spring与mybatis连接接口),

cn.springmvc.service(service接口),

cn.springmvc.service.impl(service接口的实现)，

b、在src/main/resource文件夹中，新建包conf(存放配置文件)，

mapper(mybatis的mapper文件)

c、在src/test/java文件夹中，新建包cn.springmvc.test(存放测试文件)

2、引入依赖包

a、打开maven的pom文件，对本次开发所需使用的架包依次导入(maven项目管理的优势)

注：查找依赖结构有个不错的网站，http://search.maven.org/   只要输入包名选择相应版本，将代码拷贝到pom文件中，maven将会自动下载包

b、pom包文件;

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

4.0.0

eyas.springmvc

springmvc

war

0.0.1-SNAPSHOT

springmvc Maven Webapp

http://maven.apache.org

3.2.4.RELEASE

3.2.4

1.6.6

1.2.9

org.springframework

spring-core

${spring.version}

org.springframework

spring-web

${spring.version}

org.springframework

spring-oxm

${spring.version}

org.springframework

spring-tx

${spring.version}

org.springframework

spring-jdbc

${spring.version}

org.springframework

spring-webmvc

${spring.version}

org.springframework

spring-aop

${spring.version}

org.springframework

spring-context-support

${spring.version}

org.springframework

spring-aop

${spring.version}

org.springframework

spring-test

${spring.version}

org.mybatis

mybatis

${mybatis.version}

org.mybatis

mybatis-spring

1.2.2

mysql

mysql-connector-java

5.1.29

junit

junit

4.11

test

com.alibaba

druid

1.0.2

org.codehaus.jackson

jackson-mapper-asl

1.9.13

log4j

log4j

${log4j.version}

org.slf4j

slf4j-api

${slf4j.version}

org.slf4j

slf4j-log4j12

${slf4j.version}

springmvc

3、配置数据库链接属性(conf/ jdbc.properties(jdbc配置文件))

jdbc_driverClassName=com.mysql.jdbc.Driver

jdbc_url=jdbc:mysql://localhost:3306/mydays?useUnicode=true&characterEncoding=utf-8

jdbc_username=root

jdbc_password=root

4、配置spring配置文件(conf/spring.xml(spring配置文件的扫描))

xmlns:context="http://www.springframework.org/schema/context"

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-3.0.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context.xsd">

conf/spring-mybatis.xml(spring与mybatis连接属性)

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:p="http://www.springframework.org/schema/p"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:util="http://www.springframework.org/schema/util"

xsi:schemaLocation="http://www.springframework.org/schema/beans

http://www.springframework.org/schema/beans/spring-beans-3.2.xsd

http://www.springframework.org/schema/context

http://www.springframework.org/schema/context/spring-context-3.2.xsd

http://www.springframework.org/schema/tx

http://www.springframework.org/schema/tx/spring-tx-3.2.xsd

http://www.springframework.org/schema/aop

http://www.springframework.org/schema/aop/spring-aop-3.2.xsd

http://www.springframework.org/schema/util

http://www.springframework.org/schema/util/spring-util-3.2.xsd">

destroy-method="close" >

${jdbc_driverClassName}

${jdbc_url}

${jdbc_username}

${jdbc_password}

20

1

60000

20

3

true

180

clientEncoding=UTF-8

class="org.mybatis.spring.SqlSessionFactoryBean"

p:dataSource-ref="dataSource"

p:configLocation="classpath:conf/mybatis-config.xml"

p:mapperLocations="classpath:mapper/*.xml"/>

p:basePackage="cn.springmvc.dao"

p:sqlSessionFactoryBeanName="sqlSessionFactory"/>

class="org.springframework.jdbc.datasource.DataSourceTransactionManager"

p:dataSource-ref="dataSource"/>

5、java代码编写(model，dao，service层代码)( cn.springmvc.model/User.java(用户基本信息))

package cn.springmvc.model;

/**

* 用户表

*/

public class User {

private int id;

private int state;

private String nickname;

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

public int getState() {

return state;

}

public void setState(int state) {

this.state = state;

}

public String getNickname() {

return nickname;

}

public void setNickname(String nickname) {

this.nickname = nickname;

}

}

cn.springmvc.dao/UserDAO.java(dao操作接口)

package cn.springmvc.dao;

import cn.springmvc.model.User;

public interface UserDAO {

/**

* 添加新用户

* @param user

* @return

*/

public int insertUser(User user);

}

cn.springmvc.service/UserService.java(service层接口)

package cn.springmvc.service;

import cn.springmvc.model.User;

public interface UserService {

public int insertUser(User user);

}

cn.springmvc.service.impl/UserServiceImpl.java(service层接口实现)

package cn.springmvc.service.impl;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Service;

import cn.springmvc.dao.UserDAO;

import cn.springmvc.model.User;

import cn.springmvc.service.UserService;

@Service

public class UserServiceImpl implements UserService{

@Autowired

private UserDAO userDAO;

@Override

public int insertUser(User user) {

// TODO Auto-generated method stub

return userDAO.insertUser(user);

}

}

6、mybatis配置

a、conf/mybatis-config.xml(mybatis配置的基本文件))

/p>

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

b、mapper/UserMapper.xml(mybatis的实现)

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

insert into days_user(

state,

nickname)

values

(

#{state},

#{nickname})

7、接下来就可以写测试类了cn.springmvc.test/UserTest.java(用户测试模块)

package cn.springmvc.test;

import org.junit.Before;

import org.junit.Test;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import cn.springmvc.model.User;

import cn.springmvc.service.UserService;

public class UserTest {

private UserService userService;

@Before

public void before(){

@SuppressWarnings("resource")

ApplicationContext context = new ClassPathXmlApplicationContext(new String[]{"classpath:conf/spring.xml"

,"classpath:conf/spring-mybatis.xml"});

userService = (UserService) context.getBean("userServiceImpl");

}

@Test

public void addUser(){

User user = new User();

user.setNickname("你好");

user.setState(2);

System.out.println(userService.insertUser(user));

}

}

测试结果如图：

即完成插入功能！