mybatis学习（一）

最新推荐文章于 2024-07-12 21:38:37 发布

echo_wjcwjc

最新推荐文章于 2024-07-12 21:38:37 发布

阅读量84

点赞数

分类专栏： mybatis

本文链接：https://blog.csdn.net/qq_35654259/article/details/81837278

版权

mybatis 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

创建maven工程

问题:无法手动创建src/main/java和src/test/java

现象

解决

右击项目点击Build path->Configure Build Path..

2.在界面中找到src/main/java 和 src/test/java 后点击再将这两者Remove掉

3.新建package src/main/java和src/test/java就不会报错了

mybatis下载

mybaits的代码由github.com管理

下载地址：https://github.com/mybatis/mybatis-3/releases

加入配置文件

log4j.properties

# Global logging configuration
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

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>

<!-- resource  url -->
<!-- setting -->
<properties resource="db.properties">
	<property name="" value=""/>
</properties>
 

<!-- 3.定义别名 -->
	<typeAliases>
		<typeAlias type="cn.itcast.bean.DeptmentBean" alias="deptbean"/>
		<typeAlias type="cn.itcast.bean.EmployeeBean" alias="empbean"/>
	</typeAliases>
	<!-- 和spring整合后 environments配置将废除 -->
	<environments default="development">
		<environment id="development">
			<!-- 使用jdbc事务管理 -->
			<transactionManager type="JDBC" />
			<!-- 数据库连接池 -->
			<!-- POOLED|UNPOOLED|JNDI -->
			<dataSource type="POOLED">
				<property name="driver" value="${mysql.driverClassName}" />
				<property name="url"
					value="${mysql.url}" />
				<property name="username" value="${mysql.user}" />
				<property name="password" value="${mysql.password}" />
			</dataSource>
		</environment>
		<environment id="dev_oracle">
			<!-- 使用jdbc事务管理 -->
			<transactionManager type="JDBC" />
			<!-- 数据库连接池 -->
			<!-- POOLED|UNPOOLED|JNDI -->
			<dataSource type="POOLED">
				<property name="driver" value="${oracle.driverClassName}" />
				<property name="url"
					value="${oracle.url}" />
				<property name="username" value="${oracle.user}" />
				<property name="password" value="${oracle.password}" />
			</dataSource>
		</environment>
	</environments>
	<!--  -->
	<databaseIdProvider type="DB_VENDOR">
	  <property name="SQL Server" value="sqlserver"/>
	  <property name="DB2" value="db2"/>        
	  <property name="Oracle" value="oracle" />
	  <property name="MySQL" value="mysql" />
	</databaseIdProvider>
	
	<!-- 映射sql的xml文件 -->
	<mappers>
	  <!--  
		<mapper resource="sqlmap/user.xml"/>
		<mapper resource="cn/itcast/dao/DeptmentMapper.xml"/>
		<mapper resource="cn/itcast/dao/EmployeeMapper.xml"/>
		<mapper resource="cn/itcast/dao/EmployeeMapperParams.xml"/>
		<mapper resource="cn/itcast/dao/EmployeeMapperPlus.xml"/>
	-->
		<package name="cn.itcast.dao"/>
	</mappers>
	
</configuration>

db.properties

mysql.driverClassName=com.mysql.jdbc.Driver
mysql.url=jdbc:mysql://localhost:3306/mybatis2?characterEncoding=utf-8&allowMultiQueries=true
mysql.user=root
mysql.password=admin

oracle.driverClassName=oracle.jdbc.OracleDriver
oracle.url=jdbc:oracle:thin:@localhost:1521:orcl
oracle.user=scott
oracle.password=tiger