文章目录
1 项目的创建-common(vo.util) startup good um
父项目不写代码,用于管理jar包,管理依赖
子项目写具体功能
- youping-common(通用)
- youping-goods(商品)
- youping-startup(启动类)
- youping-um(用户管理)
2 实体类(脚本)
- 类jvm语言-groovy
- Generate POJOs.groovy
- 使用idea中Database工具,选中所有表,右键选ScriptedExtension,点击GeneratePOJOs.groovy
import com.intellij.database.model.DasTable
import com.intellij.database.model.ObjectKind
import com.intellij.database.util.Case
import com.intellij.database.util.DasUtil
import java.io.*
import java.text.SimpleDateFormat
/*
* Available context bindings:
* SELECTION Iterable<DasObject>
* PROJECT project
* FILES files helper
*/
packageName = ""
typeMapping = [
(~/(?i)tinyint|smallint|mediumint/) : "Integer",
(~/(?i)int/) : "Long",
(~/(?i)bool|bit/) : "Boolean",
(~/(?i)float|double|decimal|real/) : "Double",
(~/(?i)datetime|timestamp|date|time/) : "Date",
(~/(?i)blob|binary|bfile|clob|raw|image/): "InputStream",
(~/(?i)/) : "String"
]
FILES.chooseDirectoryAndSave("Choose directory", "Choose where to store generated files") { dir ->
SELECTION.filter { it instanceof DasTable && it.getKind() == ObjectKind.TABLE }.each { generate(it, dir) }
}
def generate(table, dir) {
def className = javaName(table.getName(), true)
def fields = calcFields(table)
packageName = getPackageName(dir)
PrintWriter printWriter = new PrintWriter(new OutputStreamWriter(new FileOutputStream(new File(dir, className + ".java")), "UTF-8"))
printWriter.withPrintWriter {out -> generate(out, className, fields,table)}
// new File(dir, className + ".java").withPrintWriter { out -> generate(out, className, fields,table) }
}
// 获取包所在文件夹路径
def getPackageName(dir) {
return dir.toString().replaceAll("\\\\", ".").replaceAll("/", ".").replaceAll("^.*src(\\.main\\.java\\.)?", "") + ";"
}
def generate(out, className, fields,table) {
out.println "package $packageName"
out.println ""
out.println "import java.io.Serializable;"
out.println "import lombok.Data;"
Set types = new HashSet()
fields.each() {
types.add(it.type)
}
if (types.contains("Date")) {
out.println "import java.util.Date;"
}
if (types.contains("InputStream")) {
out.println "import java.io.InputStream;"
}
out.println ""
out.println "@Data"
out.println "public class $className implements Serializable {"
out.println ""
out.println genSerialID()
fields.each() {
out.println ""
// 输出注释
if (isNotEmpty(it.commoent)) {
out.println "\t/**"
out.println "\t * ${it.commoent.toString()}"
out.println "\t */"
}
if (it.annos != "") out.println " ${it.annos.replace("[@Id]", "")}"
// 输出成员变量
out.println "\tprivate ${it.type} ${it.name};"
}
out.println ""
out.println "}"
}
def calcFields(table) {
DasUtil.getColumns(table).reduce([]) { fields, col ->
def spec = Case.LOWER.apply(col.getDataType().getSpecification())
def typeStr = typeMapping.find { p, t -> p.matcher(spec).find() }.value
def comm =[
colName : col.getName(),
name : javaName(col.getName(), false),
type : typeStr,
commoent: col.getComment(),
annos: ""]
if("id".equals(Case.LOWER.apply(col.getName())))
comm.annos +=["@Id"]
fields += [comm]
}
}
def javaName(str, capitalize) {
// def s = str.split(/(?<=[^\p{IsLetter}])/).collect { Case.LOWER.apply(it).capitalize() }
// .join("").replaceAll(/[^\p{javaJavaIdentifierPart}]/, "_")
// capitalize || s.length() == 1? s : Case.LOWER.apply(s[0]) + s[1..-1]
def s = com.intellij.psi.codeStyle.NameUtil.splitNameIntoWords(str)
.collect { Case.LOWER.apply(it).capitalize() }
.join("")
.replaceAll(/[^\p{javaJavaIdentifierPart}[_]]/, "_")
capitalize || s.length() == 1? s : Case.LOWER.apply(s[0]) + s[1..-1]
}
def isNotEmpty(content) {
return content != null && content.toString().trim().length() > 0
}
static String changeStyle(String str, boolean toCamel){
if(!str || str.size() <= 1)
return str
if(toCamel){
String r = str.toLowerCase().split('_').collect{cc -> Case.LOWER.apply(cc).capitalize()}.join('')
return r[0].toLowerCase() + r[1..-1]
}else{
str = str[0].toLowerCase() + str[1..-1]
return str.collect{cc -> ((char)cc).isUpperCase() ? '_' + cc.toLowerCase() : cc}.join('')
}
}
static String genSerialID()
{
return "\tprivate static final long serialVersionUID = "+Math.abs(new Random().nextLong())+"L;"
}
3 um
3.1 整合mybatis-plus、mysql
3.2 dao(引youping-common)
- UserMapper
package com.xzy.um.dao;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xzy.common.entity.User;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface UserMapper extends BaseMapper<User> {
}
3.3 UserService
package com.xzy.um.service;
import com.github.tobato.fastdfs.service.FastFileStorageClient;
import com.xzy.common.entity.User;
import com.xzy.common.util.FdfsUtils;
import com.xzy.um.dao.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;
import java.beans.Transient;
import java.io.File;
import java.io.IOException;
import java.util.List;
@Service
public class UserService {
@Autowired
private UserMapper userMapper;
@Autowired
private FastFileStorageClient fastFileStorageClient;
public List<User> listAll() {
return userMapper.selectList(null);
}
/**
* 添加用户 1. 把头像上传到fdfs中,返回访问路径 2.把用户名和密码添加到数据库
* @param nickname
* @param password
* @return
*/
@Transient
public int add(String nickname, String password, MultipartFile avatarFile) throws IOException {
String fdfsFullPath = FdfsUtils.upLoadFile(fastFileStorageClient, avatarFile.getInputStream(), avatarFile.getOriginalFilename(), avatarFile.getSize());
System.out.println(fdfsFullPath);
User user = new User();
user.setNickname(nickname);
user.setPassword(password);
return userMapper.insert(user);
}
}
3.4 UserController
package com.xzy.um.controller;
import com.xzy.common.entity.User;
import com.xzy.common.entity.vo.Response;
import com.xzy.common.entity.vo.ResponseCode;
import com.xzy.um.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
import java.io.File;
import java.util.List;
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
private UserService userService;
@GetMapping("/all")
public List<User> findAll() {
return userService.listAll();
}
@PostMapping("/regist")
public Response regist(String nickname, String password, MultipartFile avatarFile) throws Exception {
int row = userService.add(nickname, password, null);
Response response = new Response();
if (row > 0) {
//注册成功
response.code(ResponseCode.SUCCESS).msg("注册成功");
} else {
//注册失败
//response.code(ResponseCode.ERROR).msg("注册失败");
throw new Exception("注册失败");
}
return response;
}
}
4 复合项目相互引用
解决
- @ComponentScan(BasePackages=“com.xzy”)
- 在um中引Goods
- ComponentScan扫描不到jar包中的类
把Application.java放到com.xzy
5 启动类
- 新建子项目-startup(启动)
- 引goods和um
- application.properties放启动类中
5.1 配置文件(application.properties)
server.port=8080
#配置数据源
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://10.10.10.21:3306/youping?serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=root123ROOT...
#配置mybatis-plus
mybatis-plus.mapper-locations=classpath:mappers/*.xml
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
#配置fdfs
fdfs.tracker-list=10.10.10.21:22122
5.2 Application.java
package com.xzy;
import com.github.tobato.fastdfs.FdfsClientConfig;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.Import;
@SpringBootApplication
@Import(FdfsClientConfig.class)
public class Application {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}