各路大仙帮帮忙,之前按网上的各招试过,包括:
1.把mapper接口和mapper的xml文件所在包名写一致:
2.pom.xml中build标签下添加依赖,强制将xml文件打到war包中
3.mapper.xml文件中namespace也写正确了
结局都是:
菜鸟哪里写错了吗?部分图片无法上传,只好直接粘代码
1)包结构:
2)我的pom.xml如下:
3)配置文件.properties:
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:orcl
spring.datasource.username=FLW
spring.datasource.password=FLW
spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
spring.datasource.max-idle=10
spring.datasource.max-wait=10000
spring.datasource.min-idle=5
spring.datasource.initial-size=5
server.port=8085
server.session.timeout=10
server.tomcat.uri-encoding=UTF-8
mybatis.mapperLocations=classpath*:com.dadiao.cock.mapper/*.xml
mybatis.typeAliasesPackage=com.dadiao.cock.mapper
4)Mapper接口和xml文件:
<mapper namespace="com.dadiao.cock.mapper.MessageMapper" >
<insert id="registerMember" parameterType="com.dadiao.cock.bean.User">
insert into t_member(user_id,theName,age,sex,tel)
values (seq_mem.nextval,#{theName,jdbcType=VARCHAR},#{age,jdbcType=INTEGER},#{sex,jdbcType=INTEGER},#{tel,jdbcType=INTEGER})
</insert>
</mapper>
5)SpringBootApplication类:
@SpringBootApplication
@MapperScan("com.dadiao.cock.mapper")
public class BootApplication {
public static void main (String[] args){
SpringApplication.run(BootApplication.class, args);
}
}
6)测试类:
@RunWith(SpringRunner.class)
@SpringBootTest
public class DataTest {
@Autowired
private MassageMapper mapper;
@Test
public void contextLoads(){
User user = new User();
user.setAge(18);
user.setSex(2);
user.setTel(110);
user.setTheName("luzhaoli");
int result = mapper.registerMember(user);
System.out.println("结果为:"+result);
}
}