Spring+mybatis+mysql/oracle开发

1）创建一个spring-mybatis-mysql这么一个javaweb或java工程

2）导入spring-ioc，spring-aop，spring-transaction，mybatis，c3p0，mysql/oracle相关的jar包和spring整合mybatis的jar包

3）创建students.sql

--mysqlcreatetablestudents(sidint(5)primarykey,snamevarchar(10),ssaldouble(8,2));

4）创建Student.java

/***学生*/publicclassStudent{privateIntegerid;//编号privateStringname;//姓名privateDoublesal;//薪水publicStudent(){}publicStudent(Integerid,Stringname,Doublesal){this.id=id;this.name=name;this.sal=sal;}publicIntegergetId(){returnid;}publicvoidsetId(Integerid){this.id=id;}publicStringgetName(){returnname;}publicvoidsetName(Stringname){this.name=name;}publicDoublegetSal(){returnsal;}publicvoidsetSal(Doublesal){this.sal=sal;}}

5）创建StudentMapper.xml

?xmlversion="1.0"encoding="UTF-8"?!DOCTYPEmapperPUBLIC"-//mybatis.org//DTDMapper3.0//EN""