当前位置:主页 > 软件编程 > JAVA代码 >

mybatis 使用jdbc.properties文件设置不起作用的解决方法

时间:2021-06-27 08:22:20 | 栏目:JAVA代码 | 点击:

这样写的时候起作用:

<?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> 
 <typeAliases> 
  <typeAlias type="com.hc.entity.UserInfo" alias="UserInfo"/> 
 </typeAliases> 
 <environments default="development"> 
  <environment id="mysql"> 
   <transactionManager type="JDBC"/> 
   <dataSource type="POOLED"> 
    <property name="driver" value="com.mysql.jdbc.Driver"/> 
    <property name="url" value="jdbc:mysql://localhost:3306/db_mybatis"/> 
    <property name="username" value="hhc"/> 
    <property name="password" value="******"/> 
   </dataSource> 
  </environment> 
 </environments> 
 <mappers> 
  <mapper resource="com/hc/mapper/UserInfo.xml"/> 
 </mappers> 
</configuration> 

这样写不起作用:

jdbc.driverClass=com.mysql.jdbc.Driver 
jdbc.url=jdbc:mysql://localhost:3306/db_mybatis 
jdbc.username=hc 
jdbc.password=123456 

<?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> 
 <properties resource="jdbc.properties"/> 
 <typeAliases> 
  <typeAlias type="com.hc.entity.UserInfo" alias="UserInfo"/> 
 </typeAliases> 
 <environments default="development"> 
  <environment id="mysql"> 
   <transactionManager type="JDBC"></transactionManager> 
   <dataSource type="POOLED"> 
    <property name="driver" value="${jdbc.driverClass}"/> 
    <property name="url" value="${jdbc.url}"/> 
    <property name="username" value="${jdbc.username}"/> 
    <property name="password" value="${jdbc.password}"/> 
   </dataSource> 
  </environment> 
 </environments> 
 <mappers> 
  <mapper resource="com/hc/mapper/userinfo.xml"/> 
 </mappers> 
</configuration> 

解决方法:

    1.在jdbc.properties鼠标右键Properties(属性),把ISO-8859-1更改为UTF-8

    2.在整个项目鼠标右键,把ISO-8859-1更改为UTF-8   具体操作如下图

总结

您可能感兴趣的文章:

相关文章