Mybatis和springWord下载.docx
《Mybatis和springWord下载.docx》由会员分享,可在线阅读,更多相关《Mybatis和springWord下载.docx(96页珍藏版)》请在冰豆网上搜索。
4.
5./*****
建立student表
*****/
6.CREATE
TABLE
STUDENT_TBL
7.(
8.
STUDENT_ID
VARCHAR(255)
PRIMARY
KEY,
9.
STUDENT_NAME
VARCHAR(10)
NOT
NULL,
10.
STUDENT_SEX
VARCHAR(10),
11.
STUDENT_BIRTHDAY
DATE,
12.
CLASS_ID
VARCHAR(255)
13.);
14.
15./*插入学生数据*/
16.INSERT
INTO
STUDENT_TBL
(STUDENT_ID,
17.
STUDENT_NAME,
18.
STUDENT_SEX,
19.
STUDENT_BIRTHDAY,
20.
CLASS_ID)
21.
VALUES
(123456,
22.
'
某某某'
23.
女'
24.
1980-08-01'
25.
121546
26.
)
/*建立数据库*/
CREATEDATABASESTUDENT_MANAGER;
USESTUDENT_MANAGER;
/*****建立student表*****/
CREATETABLESTUDENT_TBL
(
STUDENT_IDVARCHAR(255)PRIMARYKEY,
STUDENT_NAMEVARCHAR(10)NOTNULL,
STUDENT_SEXVARCHAR(10),
STUDENT_BIRTHDAYDATE,
CLASS_IDVARCHAR(255)
);
/*插入学生数据*/
INSERTINTOSTUDENT_TBL(STUDENT_ID,
STUDENT_NAME,
STUDENT_SEX,
STUDENT_BIRTHDAY,
CLASS_ID)
VALUES(123456,
'
121546
)
创建连接MySql使用的配置文件mysql.properties。
Mysql.properties代码
1.jdbc.driverClassName=com.mysql.jdbc.Driver
2.jdbc.url=jdbc:
mysql:
//localhost:
3306/student_manager?
user=root&
password=limingnihao&
useUnicode=true&
characterEncoding=UTF-8
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:
characterEncoding=UTF-8
1.2.3搭建MyBatis环境
顺序随便,现在的顺序是因为可以尽量的少的修改写好的文件。
1.2.3.1创建实体类:
StudentEntity
Java代码
1.public
class
StudentEntity
implements
Serializable
{
2.
3.
private
static
final
long
serialVersionUID
=
3096154202413606831L;
ClassEntity
classEntity;
5.
Date
studentBirthday;
6.
String
studentID;
7.
studentName;
studentSex;
public
getClassEntity()
return
}
13.
getStudentBirthday()
15.
16.
getStudentID()
getStudentName()
getStudentSex()
27.
28.
29.
30.
void
setClassEntity(ClassEntity
classEntity)
31.
this.classEntity
32.
33.
34.
setStudentBirthday(Date
studentBirthday)
35.
this.studentBirthday
36.
37.
38.
setStudentID(String
studentID)
39.
this.studentID
40.
41.
42.
setStudentName(String
studentName)
43.
this.studentName
44.
45.
46.
setStudentSex(String
studentSex)
47.
this.studentSex
48.
49.}
publicclassStudentEntityimplementsSerializable{
privatestaticfinallongserialVersionUID=3096154202413606831L;
privateClassEntityclassEntity;
privateDatestudentBirthday;
privateStringstudentID;
privateStringstudentName;
privateStringstudentSex;
publicClassEntitygetClassEntity(){
returnclassEntity;
}
publicDategetStudentBirthday(){
returnstudentBirthday;
publicStringgetStudentID(){
returnstudentID;
publicStringgetStudentName(){
returnstudentName;
publicStringgetStudentSex(){
returnstudentSex;
publicvoidsetClassEntity(ClassEntityclassEntity){
this.classEntity=classEntity;
publicvoidsetStudentBirthday(DatestudentBirthday){
this.studentBirthday=studentBirthday;
publicvoidsetStudentID(StringstudentID){
this.studentID=studentID;
publicvoidsetStudentName(StringstudentName){
this.studentName=studentName;
publicvoidsetStudentSex(StringstudentSex){
this.studentSex=studentSex;
}
1.2.3.2创建数据访问接口
Student类对应的dao接口:
StudentMapper。
interface
StudentMapper
getStudent(String
studentID);
getStudentAndClass(String
List<
StudentEntity>
getStudentAll();
insertStudent(StudentEntity
entity);
deleteStudent(StudentEntity
updateStudent(StudentEntity
14.}
publicinterfaceStudentMapper{
publicStudentEntitygetStudent(StringstudentID);
publicStudentEntitygetStudentAndClass(StringstudentID);
publicList<
getStudentAll();
publicvoidinsertStudent(StudentEntityentity);
publicvoiddeleteStudent(StudentEntityentity);
publicvoidupdateStudent(StudentEntityentity);
1.2.3.3创建SQL映射语句文件
Student类的sql语句文件StudentMapper.xml
resultMap标签:
表字段与属性的映射。
Select标签:
查询sql。
Xml代码
1.<
?
xml
version="
1.0"
encoding="
UTF-8"
>
2.<
!
DOCTYPE
mapper
PUBLIC
"
-//mybatis.org//DTD
Mapper
3.0//EN"
//mybatis.org/dtd/mybatis-3-mapper.dtd"
3.<
namespace="
com.manager.data.StudentMapper"
<
resultMap
type="
StudentEntity"
id="
studentResultMap"
id
property="
studentID"
column="
STUDENT_ID"
/>
result
studentName"
STUDENT_NAME"
studentSex"
STUDENT_SEX"
studentBirthday"
STUDENT_BIRTHDAY"
/resultMap>
--
查询学生,根据id
-->
select
getStudent"
parameterType="
String"
resultType="
resultMap="
[CDATA[
SELECT
*
from
ST
WHERE
ST.STUDENT_ID
#{studentID}
]]>
/select>
查询学生列表
getStudentAll"
com.manager.data.model.StudentEntity"
27.<
/mapper>
xmlversion="
encoding="
?
DOCTYPEmapperPUBLIC"
-//mybatis.org//DTDMapper3.0//EN"
"
mappernamespace="
<
resultMaptype="
id="
<
idproperty="
column="
resultproperty="
--查询学生,根据id-->
selectid="
parameterType="
resultType="
resultMap="
[CDATA[
SELECT*fromSTUDENT_TBLST
WHEREST.STUDENT_ID=#{studentID}
]]>
--查询学生列表-->
SELECT*fromSTUDENT_TBL
1.2.3.4创建MyBatis的mapper配置文件
在src/main/resource中创建MyBatis配置文件:
mybatis-config.xml。
typeAliases标签:
给类起一个别名。
com.manager.data.model.StudentEntity类,可以使用StudentEntity代替。
Mappers标签:
加载MyBatis中实体类的SQL映射语句文件。
configuration
Config
//mybatis.org/dtd/mybatis-3-config.dtd"
configuration>
typeAliases>
typeAlias
alias="
/typeAliases>
mappers>
resource="
com/manager/data/maps/StudentMapper.xml"
/mappers>
10.<
/configuration>
DOCTYPEconfigurationPUBLIC"
-//mybatis.org//DTDConfig3.0//EN"
typeAliasalias="
type="
mapperresource="
/>
1.2.3.5修改Spring的配置文件
主要是添加SqlSession的制作工厂类的bean:
SqlSessionFactoryBean,(在mybatis.spring包中)。
需要指定配置文件位置和dataSource。
和数据访问接口对应的实现bean。
通过MapperFactoryBean创建出来。
需要执行接口类全称和SqlSession工厂bean的引用。
导入属性配置文件
context:
property-placeholder
location="
classpath:
mysql.properties"
4.<
bean
dataSource"
class="
org.springframework.jdbc.datasource.DriverManagerDataSource"
property