Springboot+hibernate实现简单的增删改查示例

#server

server.port= 8080

server.tomcat.uri-encoding=utf- 8

#mysql

spring.datasource.driver- class -name=com.mysql.jdbc.driver

spring.datasource.url=jdbc:mysql: //localhost:3306/test?characterencoding=utf8

spring.datasource.username=*****

spring.datasource.password=*****

#spring data jpa

spring.jpa.database=mysql

spring.jpa.show-sql= true

spring.jpa. hibernate .ddl-auto=update

# naming strategy

spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.improvednamingstrategy

# stripped before adding them to the entity manager)

spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.mysql5dialect

#视图层控制

spring.mvc.view.prefix=classpath:/templates/

spring.mvc.view.suffix=.html

spring.mvc. static -path-pattern=/ static /**

<dependencies>

     <dependency>

       <groupid>org.springframework.boot</groupid>

       <artifactid>spring-boot-starter-web</artifactid>

     </dependency>

     <!-- https: //mvnrepository.com/artifact/mysql/mysql-connector-java -->

     <dependency>

       <groupid>mysql</groupid>

       <artifactid>mysql-connector-java</artifactid>

       <version> 5.1 . 39 </version>

     </dependency>

     <!-- https: //mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-thymeleaf -->

     <dependency>

       <groupid>org.springframework.boot</groupid>

       <artifactid>spring-boot-starter-thymeleaf</artifactid>

       <version> 1.4 . 0 .release</version>

     </dependency>

     <!-- https: //mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-jdbc -->

<!--    <dependency>

       <groupid>org.springframework.boot</groupid>

       <artifactid>spring-boot-starter-jdbc</artifactid>

       <version> 1.4 . 3 .release</version>

     </dependency>-->

     <!-- https: //mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-data-jpa -->

     <dependency>

       <groupid>org.springframework.boot</groupid>

       <artifactid>spring-boot-starter-data-jpa</artifactid>

       <version> 1.5 . 1 .release</version>

     </dependency>

     <dependency>

       <groupid>com.alibaba</groupid>

       <artifactid>fastjson</artifactid>

       <version> 1.2 . 46 </version>

     </dependency>

   </dependencies>

package com.song.configuration.controller;

import com.alibaba.fastjson.jsonobject;

import com.song.configuration.entity.user;

import com.song.configuration.service.userservice;

import org.springframework.beans.factory.annotation.autowired;

import org.springframework.stereotype.controller;

import org.springframework.web.bind.annotation.requestmapping;

import org.springframework.web.bind.annotation.requestmethod;

import org.springframework.web.bind.annotation.requestparam;

import org.springframework.web.bind.annotation.responsebody;

import java.util.list;

/**

  *

  * user控制层

  */

@controller

@requestmapping (value = "/user" )

public class usercontroller {

   @autowired

   private userservice userservice;

   @requestmapping (value = "/index" )

   public string index(){

     return "user/index" ;

   }

   @requestmapping (value = "/show" ,method = requestmethod.get)

   @responsebody

   public string show( @requestparam (value = "name" )string name){

     user user = userservice.finduserbyname(name);

     if ( null != user)

       return user.getid()+ "/" +user.getname()+ "/" +user.getpassword();

     else return "null" ;

   }

   @requestmapping ( "/showlist" )

   @responsebody

   public jsonobject showlist(){

     list<user> list = userservice.find();

     jsonobject jo = new jsonobject();

     if (list!= null ){

       jo.put( "code" , 0 );

       jo.put( "msg" , true );

       jo.put( "count" ,list.size());

       jo.put( "data" ,list);

     }

     return jo;

   }

   @requestmapping ( "/delete" )

   @responsebody

   public string deleteuserbyid( @requestparam (value = "id" )integer id){

     return userservice.deleteuserbyid(id);

   }

   @requestmapping ( "/update" )

   @responsebody

   public string queryuserbyid( @requestparam (value = "id" )integer id, @requestparam (value = "name" )string name){

     return userservice.queryuserbyid(id,name);

   }

   @requestmapping ( "/add" )

   @responsebody

   public string countuserby( @requestparam (value = "id" )integer id, @requestparam (value = "name" )string name, @requestparam (value = "password" )string password){

     return userservice.countuserby(id,name,password);

   }

}

package com.song.configuration.service;

import com.song.configuration.entity.user;

import com.song.configuration.repository.userrepositoty;

import org.springframework.beans.factory.annotation.autowired;

import org.springframework.stereotype.service;

import java.util.list;

/**

  *

  * user业务逻辑

  */

@service

public class userservice {

   @autowired

   private userrepositoty userrepositoty;

   public user finduserbyname(string name) {

     user user = null ;

     try {

       user = userrepositoty.findbyusername(name);

     } catch (exception e) {

     }

     return user;

   }

   public list<user> find() {

     list<user> list = null ;

     try {

       list = userrepositoty.find();

     } catch (exception e) {

     }

     return list;

   }

   public string deleteuserbyid(integer id){

     int a = userrepositoty.deleteuserbyid(id);

     return "chenggong" ;

   }

   public string queryuserbyid(integer id ,string name){

     int a = userrepositoty.queryuserbyid(id,name);

     return "成功" ;

   }

   public string countuserby(integer id ,string name ,string password){

     int a = userrepositoty.countuserby(id,name,password);

     return "成功" ;

   }

}

package com.song.configuration.repository;

import com.song.configuration.entity.user;

import org.springframework.data.jpa.repository.jparepository;

import org.springframework.data.jpa.repository.modifying;

import org.springframework.data.jpa.repository.query;

import org.springframework.data.repository.query.param;

import org.springframework.stereotype.repository;

import org.springframework.transaction.annotation.transactional;

import java.util.list;

/**

  * created by song on 2017/2/15.

  * user表操作接口

  */

@repository

public interface userrepositoty extends jparepository<user, long >{

   /*

   * 根据用户名查询

   * */

   @query("select t from user t where t.name = :name")

   user findbyusername(@param("name") string name);

   /*

   * 查询全部

   * */

   @query("select t from user t")

   list<user> find();

   /*

   * 删除 必须加入@modifying和@transactional

   * */

   @modifying

   @transactional

   @query ( "delete from user u where u.id=:id" )

   public int deleteuserbyid( @param ( "id" ) integer id);

   @modifying

   @transactional

   @query ( "update user u set u.name = :name where u.id=:id" )

   public int queryuserbyid( @param ( "id" ) integer id, @param ( "name" ) string name);

   @query (value = "insert into user value(?,?,?)" , nativequery = true )

   @transactional

　　 @modifying

   public int countuserby( @param ( "id" )integer id, @param ( "name" ) string name, @param ( "password" ) string password);

}

package com.song.configuration;

import org.springframework.boot.springapplication;

import org.springframework.boot.autoconfigure.springbootapplication;

import org.springframework.context.annotation.componentscan;

/**

  *

  * 项目启动入口，配置包根路径

  */

@springbootapplication

@componentscan (basepackages = "com.song.configuration" )

public class entry {

   public static void main(string[] args) throws exception {

     springapplication.run(entry. class , args);

   }

}

package com.song.configuration;

import org.springframework.boot.autoconfigure.domain.entityscan;

import org.springframework.context.annotation.bean;

import org.springframework.context.annotation.configuration;

import org.springframework.core.ordered;

import org.springframework.core.annotation.order;

import org.springframework.dao.annotation.persistenceexceptiontranslationpostprocessor;

import org.springframework.data.jpa.repository.config.enablejparepositories;

import org.springframework.transaction.annotation.enabletransactionmanagement;

@order (ordered.highest_precedence)

@configuration

@enabletransactionmanagement (proxytargetclass = true )

@enablejparepositories (basepackages = "com.song.configuration.repository" )

@entityscan (basepackages = "com.song.configuration.entity" )

public class jpaconfiguration {

   @bean

   persistenceexceptiontranslationpostprocessor persistenceexceptiontranslationpostprocessor(){

     return new persistenceexceptiontranslationpostprocessor();

   }

}