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

时间：2024-10-16 23:48:14

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工程创建

3、选择快速框架

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

5、创建好的目录如下：

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.version>4.1.9.RELEASE</spring.version>  <slf4j.version>1.6.6</slf4j.version> <log4j.version>1.2.12</log4j.version>  <junit.version>4.10</junit.version>  <mybatis.version>3.2.1</mybatis.version> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <jackson.version>1.9.13</jackson.version> </properties> <dependencies>  <dependency> <groupId>javax</groupId> <artifactId>javaee-api</artifactId> <version>6.0</version> <scope>provided</scope> </dependency>  <dependency> <groupId>javax</groupId> <artifactId>javaee-web-api</artifactId> <version>6.0</version> <scope>provided</scope> </dependency>  <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>   <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>   <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>${spring.version}</version> <scope>test</scope> </dependency>  <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>${mybatis.version}</version> </dependency>  <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.2.0</version> </dependency> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc</artifactId> <version>14</version> </dependency> <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四个文件

8、mybatis配置文件mybatis-config.xml<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <settings> <setting name="mapUnderscoreToCamelCase" value="true" /> </settings></configuration>

9、数据源配置文件jdbc.properties以下是oracle配置文件jdbc_driverClassName=oracle.jdbc.driver.OracleDriverjdbc_url=jdbc:oracle:thin:@你的IP:1521:你的实例名jdbc_username=你的数据库用户名jdbc_password=你的数据库密码initialSize=0maxActive=20maxIdle=20minIdle=1maxWait=60000以下是mysql配置文件jdbc_driverClassName=com.mysql.jdbc.Driverjdbc_url=jdbc:mysql://localhost:3306/你的实例名jdbc_username=你的数据库用户名jdbc_password=你的数据库密码initialSize=0maxActive=20maxIdle=20minIdle=1maxWait=60000

10、表映射文件MemberMapper.xml<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" ><mapper namespace="dao.MemberDao"> <select id="getMemberInfo" parameterType="String" resultType="entity.Member"> select ID, PASSPORT, PASSWORD, PHONE, REG_TIME, STATUS from T_PLT_MEMBER where PASSPORT = #{passport,jdbcType=VARCHAR} </select></mapper>

11、spring配置文件applicatio艘绒庳焰n.xml<?xml version="1.0" encod足毂忍珩ing="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd">  <bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="locations"> <list> <value>classpath:properties/*.properties</value>  </list> </property> </bean>  <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">    <property name="driverClassName"> <value>${jdbc_driverClassName}</value> </property> <property name="url"> <value>${jdbc_url}</value> </property> <property name="username"> <value>${jdbc_username}</value> </property> <property name="password"> <value>${jdbc_password}</value> </property> </bean>  <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="dao" /> </bean>  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <property name="mapperLocations" value="classpath:mapper/*.xml"/> <property name="configLocation" value="classpath:mybatis/mybatis-config.xml" />  </bean>  <context:component-scan base-package="service" /></beans>

12、接口和类的配置：在java文件夹下添加 dao、entity、service并分别添加如下类dao(MemberDao.java) entity(Member.java) service(MemberService.java、MemberServiceImpl.java)

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>  <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:spring/application.xml</param-value> </context-param>  <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>  <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>   <listener>  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener>  <listener> <listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class> </listener> <listener> <listener-class> org.springframework.web.context.ContextLoaderListener </listener-class> </listener>  <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> </web-app>