java代码生成
使用idea的插件codehelper.generator进行代码生成,可以根据entity,生成对应的
建表sql语句
dao.java文件
dao.xml文件
service.java文件
同时这个插件还能在new了entity之后生成所有的set方法
多次生成,不会影响自己手动添加的代码
安装
安装插件codehelper.generator
案例
@Data
@AllArgsConstructor
@NoArgsConstructor
public class UserEntity {
@Id
private Integer id;
private String name;
/**
* 1启用,0停用
*/
private Integer state;
private String remark;
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date addtime;
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date stoptime;
}
生成set
UserEntity user=new UserEntity();
//new了之后在下一行:点击tool--codeHelper--GenAllSetter
生成代码
点击tool--codeHelper--tox Boxes--在弹窗中输入entity,多个使用'|'分隔,就会在当前文件夹生成代码
sql
-- auto Generated on 2020-01-14 12:49:57
-- DROP TABLE IF EXISTS `user_entity`;
CREATE TABLE user_entity(
`id` INTEGER(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
`name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'name',
`state` INTEGER(12) NOT NULL DEFAULT -1 COMMENT '1启用,0停用',
`remark` VARCHAR(50) NOT NULL DEFAULT '' COMMENT 'remark',
`addtime` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT 'addtime',
`stoptime` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00' COMMENT 'stoptime',
PRIMARY KEY (`id`)
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT 'user_entity';
dao
package com.ucare.invoice.entity.user;
import org.apache.ibatis.annotations.Param;
import java.util.List;
import com.ucare.invoice.entity.user.UserEntity;
public interface UserEntityDao {
int insert(@Param("pojo") UserEntity pojo);
int insertList(@Param("pojos") List< UserEntity> pojo);
List select(@Param("pojo") UserEntity pojo);
int update(@Param("pojo") UserEntity pojo);
}
xml
id,
name,
state,
remark,
addtime,
stoptime
INSERT INTO user_entity
id,
name,
state,
remark,
addtime,
stoptime,
VALUES
#{pojo.id},
#{pojo.name},
#{pojo.state},
#{pojo.remark},
#{pojo.addtime},
#{pojo.stoptime},
INSERT INTO user_entity(
)VALUES
(
#{pojo.id},
#{pojo.name},
#{pojo.state},
#{pojo.remark},
#{pojo.addtime},
#{pojo.stoptime}
)
UPDATE user_entity
id = #{pojo.id},
name = #{pojo.name},
state = #{pojo.state},
remark = #{pojo.remark},
addtime = #{pojo.addtime},
stoptime = #{pojo.stoptime}
WHERE id = #{pojo.id}
SELECT
FROM user_entity
AND id = #{pojo.id}
AND name = #{pojo.name}
AND state = #{pojo.state}
AND remark = #{pojo.remark}
AND addtime = #{pojo.addtime}
AND stoptime = #{pojo.stoptime}
LIMIT 1000
DELETE FROM user_entity where id = #{id}
service
package com.ucare.invoice.entity.user;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.List;
import com.ucare.invoice.entity.user.UserEntity;
import com.ucare.invoice.entity.user.UserEntityDao;
@Service
public class UserEntityService {
@Resource
private UserEntityDao userEntityDao;
public int insert(UserEntity pojo){
return userEntityDao.insert(pojo);
}
public int insertList(List< UserEntity> pojos){
return userEntityDao.insertList(pojos);
}
public List select(UserEntity pojo){
return userEntityDao.select(pojo);
}
public int update(UserEntity pojo){
return userEntityDao.update(pojo);
}
}