报错如下:
org.apache.ibatis.exceptions.PersistenceException:
xml配置文件如下:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.itheima.dao.store.CompanyDao">
<resultMap id="BaseResultMap" type="com.itheima.domain.Company">
<id column="id" property="id"/>
<result column="name" property="name"/>
<result column="expiration_date" property="expirationDate"/>
<result column="address" property="address"/>
<result column="license_id" property="licenseId"/>
<result column="representative" property="representative"/>
<result column="phone" property="phone"/>
<result column="company_size" property="companySize"/>
<result column="industry" property="industry"/>
<result column="remarks" property="remarks"/>
<result column="state" property="state"/>
<result column="city" property="city"/>
</resultMap>
<!-- <sql id="Base_Column_List">-->
<!-- id,name,expiration_date,address,license_id,representative,phone,company_size,industry,remarks,state,city-->
<!-- </sql>-->
<select id="findAll" resultMap="BaseResultMap">
select
*
from st_company
</select>
<!--配置根据ID查询-->
<select id="findById" resultMap="BaseResultMap" parameterType="java.lang.String">
select * from st_company
where id = #{id}
</select>
<!--配置根据id删除-->
<delete id="delete" parameterType="java.lang.String">
delete from st_company where id = #{id}
</delete>
<!--配置全字段插入-->
<insert id="save" parameterType="com.itheima.domain.Company">
insert into st_company (id, name, expiration_date,address, license_id,
representative,phone, company_size, industry,remarks,
state,city)
values (#{id}, #{name}, #{expirationDate},#{address},
#{licenseId}, #{representative},#{phone}, #{companySize},
#{industry},#{remarks}, #{state,jdbcType=INTEGER},#{city})
</insert>
<!--配置全字段更新-->
<update id="update" parameterType="com.itheima.domain.Company">
update st_company set name= #{name},
expiration_date = #{expirationDate},address = #{address},
license_id = #{licenseId},representative = #{representative},
phone = #{phone},company_size = #{companySize},industry = #{industry},
remarks = #{remarks},state = #{state,jdbcType=INTEGER},city = #{city}
where id = #{id} </update>
</mapper>
实体类:
package com.itheima.domain.store;
import java.util.Date;
public class Company {
private String id; //id
private String name; //名称
private Date expirationDate; //注册日期
private String address; //地址
private String licenseId; //营业执照编号
private String representative; //法人
private String phone; //电话
private String companySize; //规模
private String industry; //所属行业
private String remarks; //备注、描述
private Integer state; //状态
private String city; //所在地
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Date getExpirationDate() {
return expirationDate;
}
public void setExpirationDate(Date expirationDate) {
this.expirationDate = expirationDate;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getLicenseId() {
return licenseId;
}
public void setLicenseId(String licenseId) {
this.licenseId = licenseId;
}
public String getRepresentative() {
return representative;
}
public void setRepresentative(String representative) {
this.representative = representative;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getCompanySize() {
return companySize;
}
public void setCompanySize(String companySize) {
this.companySize = companySize;
}
public String getIndustry() {
return industry;
}
public void setIndustry(String industry) {
this.industry = industry;
}
public String getRemarks() {
return remarks;
}
public void setRemarks(String remarks) {
this.remarks = remarks;
}
public Integer getState() {
return state;
}
public void setState(Integer state) {
this.state = state;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
}
映射类
import com.itheima.domain.store.Company;
import java.util.List;
public interface CompanyDao {
void save (Company company);
void delete (Company company);
void update (Company company);
Company findById (String id);
List<Company> findAll();
}
自己创建测试方法 为什么xml文件找不到我的实体类呢
这个实体类包名和你填的不一样,少了一个store