Maven+Spirng+Mybatis+ORACLE后台项目搭建

1、创建表，并插入数据：create table T_PLT_MEMBER( ID VARCHAR2(32) not null, PASSPORT VARCHAR2(16), PASSWORD VARCHAR2(32), NICK_NAME VARCHAR2(32), PHONE VARCHAR2(11), EMAIL VARCHAR2(32), ACCOUNT VARCHAR2(32), BANK VARCHAR2(32), REG_TIME VARCHAR2(19), AUTH_TYPE VARCHAR2(10), STATUS VARCHAR2(10), BALANCE NUMBER(9,2));INSERT INTO T_PLT_MEMBER (ID,PASSPORT,PASSWORD,NICK_NAME,BALANCE)VALUES('1001','xiaoming','123','小明',200);INSERT INTO T_PLT_MEMBER (ID,PASSPORT,PASSWORD,NICK_NAME,BALANCE)VALUES('1002','xiaomei','123','小美',400);

2、Maven工程创建

4、输出项目名，包（Packaging，如果只是普通的项目，选jar就好了，如果是web项目就选war，这里是web项目，所以选择war）

6、添加包的依赖，编辑pom.xml文件添加如下依赖：<挢旗扦渌;project xmlns="http://mave荏鱿胫协n.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.hello</groupId> <artifactId>first_maven_project</artifactId> <version>0.0.1-SNAPSHOT</version> <packaging>war</packaging> <properties> <webVersion>3.1</webVersion> <!-- spring版本号 --> <spring.version>4.1.9.RELEASE</spring.version> <!-- log4j日志文件管理包版本 --> <slf4j.version>1.6.6</slf4j.version> <log4j.version>1.2.12</log4j.version> <!-- junit版本号 --> <junit.version>4.10</junit.version> <!-- mybatis版本号 --> <mybatis.version>3.2.1</mybatis.version> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <jackson.version>1.9.13</jackson.version> </properties> <dependencies> <!-- javaee-api包 注意和项目使用的JDK版本对应 --> <dependency> <groupId>javax</groupId> <artifactId>javaee-api</artifactId> <version>6.0</version> <scope>provided</scope> </dependency> <!-- javaee-web-api包 注意和项目使用的JDK版本对应 --> <dependency> <groupId>javax</groupId> <artifactId>javaee-web-api</artifactId> <version>6.0</version> <scope>provided</scope> </dependency> <!-- 添加Spring依赖 --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-core</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context-support</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aop</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-aspects</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>${spring.version}</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-web</artifactId> <version>${spring.version}</version> </dependency> <!--单元测试依赖 --> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>${junit.version}</version> <scope>test</scope> </dependency> <!-- 日志文件管理包 --> <!-- log start --> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>${log4j.version}</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>${slf4j.version}</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>${slf4j.version}</version> </dependency> <!-- log end --> <!--spring单元测试依赖 --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>${spring.version}</version> <scope>test</scope> </dependency> <!--mybatis依赖 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>${mybatis.version}</version> </dependency> <!-- mybatis/spring包 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.2.0</version> </dependency><!-- oracle驱动包 --> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc</artifactId> <version>14</version> </dependency><!-- mysql驱动包 --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.29</version> </dependency></dependencies></project>

7、配置文件：在resources目录添加如下mapper、mybatis、properties、spring 四个文件夹并分别创建MemberMapper.xml、mybatis-config.xml、jdbc.properties、application.xml四个文件

13、MemberDao类import entity.Member;public interface MemberDao { Member getMemberInfo(String name);}

14、Member类import java.math.BigDec坡纠课柩imal;public class Member{ private static final long serialVersionUID = 1L; /** * 登录账号 */ private String passport; /** * 登录密码 */ private String password; /** * 昵称 */ private String nickName; /** * 手机号码 */ private String phone; /** * 用户邮箱 */ private String email; /** * 提现账号 */ private String account; /** * 提现银行 */ private String bank; /** * 注册时间 */ private String regTime; /** * 认证类型 */ private String authType; /** * 用户状态：00:停用，01：启用 */ private String status; /** * 电子钱包余额 */ private BigDecimal balance; public String getPassport() { return passport; } public void setPassport(String passport) { this.passport = passport == null ? null : passport.trim(); } public String getPassword() { return password; } public void setPassword(String password) { this.password = password == null ? null : password.trim(); } public String getNickName() { return nickName; } public void setNickName(String nickName) { this.nickName = nickName == null ? null : nickName.trim(); } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone == null ? null : phone.trim(); } public String getEmail() { return email; } public void setEmail(String email) { this.email = email == null ? null : email.trim(); } public String getAccount() { return account; } public void setAccount(String account) { this.account = account == null ? null : account.trim(); } public String getBank() { return bank; } public void setBank(String bank) { this.bank = bank == null ? null : bank.trim(); } public String getRegTime() { return regTime; } public void setRegTime(String regTime) { this.regTime = regTime == null ? null : regTime.trim(); } public String getAuthType() { return authType; } public void setAuthType(String authType) { this.authType = authType == null ? null : authType.trim(); } public String getStatus() { return status; } public void setStatus(String status) { this.status = status == null ? null : status.trim(); } public BigDecimal getBalance() { return balance; } public void setBalance(BigDecimal balance) { this.balance = balance; } @Override public String toString() { return "Member [passport=" + passport + ", password=" + password + ", nickName=" + nickName + ", phone=" + phone + ", email=" + email + ", account=" + account + ", bank=" + bank + ", regTime=" + regTime + ", authType=" + authType + ", status=" + status + ", balance=" + balance + "]"; } }

15、MemberService类import entity.Member;public interface MemberService { String getMemberInfo(String name);}

16、MemberServiceImpl 类import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import dao.MemberDao;import entity.Member;@Servicepublic class MemberServiceImpl implements MemberService { @Autowired MemberDao memberDao; @Override public String getMemberInfo(String name) { return memberDao.getMemberInfo(name).toString(); }}

17、配置web.xml<?xml version="1.0" enco蟠校盯昂ding="UTF-8"?><web-app xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" version="3.0"> <display-name>Archetype Created Web Application</display-name> <!-- 读取spring配置文件 --> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring/application.xml</param-value> </context-param> <!-- Spring字符集过滤器 --> <filter> <filter-name>SpringEncodingFilter</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> <init-param> <param-name>forceEncoding</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>SpringEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- 解决post乱码 --> <filter> <filter-name>CharacterEncodingFilter</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>CharacterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- -监听器配置 --> <!--例:spring监听器 --> <listener> <!--用来设定Listener接口 --> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class><!--定义Listener的类名称 --> </listener> <!-- 防止Spring内存溢出监听器 --> <listener> <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class> </listener> <listener> <listener-class> org.springframework.web.context.ContextLoaderListener </listener-class> </listener> <!-- 配置spring提供的上下文载入器监听器,当项目启动时加载spring配置文件,初始化spring工厂 --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> </web-app>