JPA全称JAVA Persistence API,是一个数据持久化类和方法的集合。
JPA的目标是制定一个由很多数据库供应商实现的API,开发人员可以通过编码实现该API.
目前,在JAVA项目开发中提高的JPA一般是只用Hibernate的实现,因为在JAVA的ORM框架中,只有Hibernate实现的最好。
1.新建一个springboot项目:
<!-- Spring-data-jpa依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
2.配置数据源:
spring.datasource.nc.password=
spring.datasource.nc.driver-class-name=oracle.jdbc.driver.OracleDriver
server.port=8080
#配置文件
spring.profiles.active=dev,host
spring.datasource.wms.maximum-pool-size=20
spring.datasource.wms.minimum-idle=5
spring.jpa.database-platform=org.hibernate.dialect.Oracle10gDialect
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
3.创建实体对象
*/
@Entity
@Table(name = "TB_COMPANY_INFO")
public class WmsCompanyEntity extends BaseNoIdEntity{
/**公司名称*/
@Column(name="name",columnDefinition="varchar(225)")
private String name;
/**公司编码*/
@Column(name="code",columnDefinition="varchar(225)")
private String code;
/**公司描述*/
@Column(name="description",columnDefinition="varchar(225)")
private String description;
4.创建dao
5.创建service;
6.创建Controller;
@Controller
@RequestMapping("/wmsCompanyManage")
public class WmsCompanyManageController {
private static final Logger logger = LoggerFactory.getLogger(WmsCompanyManageController.class);
@Autowired
private IWmsCompanyInfoService wmsCompanyInfoService;
@Autowired
private INcCompanyInfoService ncCompanyInfoService;
@Resource
private CodeTableUtil codeTableUtil;
@RequestMapping(value="/queryWmsCompanyList",method=RequestMethod.POST)
public String queryUserList(HttpServletResponse response,HttpServletRequest request,@RequestBody Map<String, Object> queryParams)throws Exception{
JSONObject json = new JSONObject();
response.setContentType("application/json;charset=UTF-8");
Map<String, Object> searchParams=CommonUtil.getSearchParameters("search_", queryParams);
int[] pageParams =CommonUtil.initPage(StringHelper.null2String(queryParams.get("currentPage")),StringHelper.null2String(queryParams.get("pageSize")));
searchParams.put("limit", pageParams[1]);
searchParams.put("offset", pageParams[0]);
7.启动应用程序;控制台输出日志。
JPA在启动时创建了表