1、4. 5. /*建立student表*/ 6. CREATETABLESTUDENT_TBL 7. ( 8. STUDENT_IDVARCHAR(255)PRIMARYKEY, 9. STUDENT_NAMEVARCHAR(10)NOTNULL, 10. STUDENT_SEXVARCHAR(10), 11. STUDENT_BIRTHDAYDATE, 12. CLASS_IDVARCHAR(255) 13. );14. 15. /*插入学生数据*/ 16. INSERTINTOSTUDENT_TBL(STUDENT_ID, 17. STUDENT_NAME, 18. STUDENT_SEX,
2、 19. STUDENT_BIRTHDAY, 20. CLASS_ID) 21. VALUES(123456, 22. 某某某, 23. 女24. 1980-08-0125. 121546 26. )/* 建立数据库 */CREATE DATABASE STUDENT_MANAGER;USE STUDENT_MANAGER;/* 建立student表 */CREATE TABLE STUDENT_TBL( STUDENT_ID VARCHAR(255) PRIMARY KEY, STUDENT_NAME VARCHAR(10) NOT NULL, STUDENT_SEX VARCHAR(10)
3、, STUDENT_BIRTHDAY DATE, CLASS_ID VARCHAR(255);/*插入学生数据*/INSERT INTO STUDENT_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:/loc
4、alhost:3306/student_manager?user=root&password=limingnihao&useUnicode=true&characterEncoding=UTF-8jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:characterEncoding=UTF-81.2.3搭建MyBatis环境顺序随便,现在的顺序是因为可以尽量的少的修改写好的文件。1.2.3.1创建实体类: StudentEntityJava代码 1. publicclassStudentEntityimplementsSerializ
5、able 2. 3. privatestaticfinallongserialVersionUID=3096154202413606831L;ClassEntityclassEntity;5. DatestudentBirthday;6. StringstudentID;7. studentName;studentSex;publicgetClassEntity()return 13. getStudentBirthday()15. 16. getStudentID()getStudentName()getStudentSex()27. 28. 29. 30. voidsetClassEnti
6、ty(ClassEntityclassEntity)31. this.classEntity32. 33. 34. setStudentBirthday(DatestudentBirthday)35. this.studentBirthday36. 37. 38. setStudentID(StringstudentID)39. this.studentID40. 41. 42. setStudentName(StringstudentName)43. this.studentName44. 45. 46. setStudentSex(StringstudentSex)47. this.stu
7、dentSex48. 49. public class StudentEntity implements Serializable private static final long serialVersionUID = 3096154202413606831L; private ClassEntity classEntity; private Date studentBirthday; private String studentID; private String studentName; private String studentSex; public ClassEntity getC
8、lassEntity() return classEntity; public Date getStudentBirthday() return studentBirthday; public String getStudentID() return studentID; public String getStudentName() return studentName; public String getStudentSex() return studentSex; public void setClassEntity(ClassEntity classEntity) this.classE
9、ntity = classEntity; public void setStudentBirthday(Date studentBirthday) this.studentBirthday = studentBirthday; public void setStudentID(String studentID) this.studentID = studentID; public void setStudentName(String studentName) this.studentName = studentName; public void setStudentSex(String stu
10、dentSex) this.studentSex = studentSex;1.2.3.2创建数据访问接口Student类对应的dao接口:StudentMapper。interfaceStudentMappergetStudent(StringstudentID);getStudentAndClass(StringListgetStudentAll();insertStudent(StudentEntityentity);deleteStudent(StudentEntityupdateStudent(StudentEntity14. public interface StudentMapp
11、er public StudentEntity getStudent(String studentID); public StudentEntity getStudentAndClass(String studentID); public List getStudentAll(); public void insertStudent(StudentEntity entity); public void deleteStudent(StudentEntity entity); public void updateStudent(StudentEntity entity);1.2.3.3创建SQL
12、映射语句文件Student类的sql语句文件StudentMapper.xmlresultMap标签:表字段与属性的映射。Select标签:查询sql。Xml代码 1. 2. !DOCTYPEmapperPUBLIC-/mybatis.org/DTDMapper3.0/EN/mybatis.org/dtd/mybatis-3-mapper.dtd3. namespace=com.manager.data.StudentMapperresultstudentNameSTUDENT_NAMEstudentSexSTUDENT_SEXstudentBirthdaySTUDENT_BIRTHDAY/r
13、esultMap-查询学生,根据id-selectgetStudentparameterType=StringresultType=resultMap=CDATA SELECT*fromST WHEREST.STUDENT_ID#studentID/select查询学生列表getStudentAllcom.manager.data.model.StudentEntity27. xml version= encoding= ?DOCTYPE mapper PUBLIC -/mybatis.org/DTD Mapper 3.0/EN mapper namespace= resultMap type
14、= id= select id= parameterType= resultType= resultMap=CDATA SELECT * from STUDENT_TBL ST WHERE ST.STUDENT_ID = #studentID - 查询学生列表 - SELECT * from STUDENT_TBL1.2.3.4创建MyBatis的mapper配置文件在src/main/resource中创建MyBatis配置文件:mybatis-config.xml。typeAliases标签:给类起一个别名。com.manager.data.model.StudentEntity类,可以使
15、用StudentEntity代替。Mappers标签:加载MyBatis中实体类的SQL映射语句文件。configurationConfig/mybatis.org/dtd/mybatis-3-config.dtdconfigurationtypeAliasestypeAliasalias=/typeAliasesmappersresource=com/manager/data/maps/StudentMapper.xml/mappers10. DOCTYPE configuration PUBLIC -/mybatis.org/DTD Config 3.0/ENtypeAlias alias
16、= type=mapper resource= /1.2.3.5修改Spring 的配置文件主要是添加SqlSession的制作工厂类的bean:SqlSessionFactoryBean,(在mybatis.spring包中)。需要指定配置文件位置和dataSource。和数据访问接口对应的实现bean。通过MapperFactoryBean创建出来。需要执行接口类全称和SqlSession工厂bean的引用。导入属性配置文件context:property-placeholderlocation=classpath:mysql.properties4. beandataSourceclass=org.springframework.jdbc.datasource.DriverManagerDataSourceproperty
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1