CRUD工具类

已于 2022-08-15 15:44:53 修改
阅读量172 收藏
点赞数
文章标签： mybatis java spring
于 2022-08-15 15:38:55 首次发布
原文链接：www.xxxxx.com祁大聪讲编程
版权

1.Table2BeanHelper

package com.yh.common.t2b;

import java.io.*;
import java.lang.reflect.Field;
import java.util.LinkedHashMap;
import java.util.List;
import java.util.Map;

/**
 * for SpringMVC、MyBatis
 */
public class Table2BeanHelper {
	
	/**
	 * @param mainDir  源文件绝对路径 如 : D:/workspace/amp/amp.web
	 * @param packageName 项目的package 名称 如： com.yun.amp.web
	 * @param tableName   表名
	 * @param cols        表对应的列
	 */
	public static void convert(String mainDir, String packageName, String tableName, List<TableBean> cols) {
		String javaSrcDir = mainDir + "/java";
		String resourceDir = mainDir + "/resources";

		String className = underscoreToCamelCase(tableName,true);
		String packagePath = packageName.replace(".", "/");
		String packageFilePath = javaSrcDir + "/" + packagePath;

		try {
			File serviceDir = new File(packageFilePath + "/service/");
			if(!serviceDir.exists()){
				serviceDir.mkdir();
			}
			String serviceName = className + "Service.java";
			File serviceFile = new File(packageFilePath + "/service/" + serviceName);
			if (!serviceFile.exists()) {
				createServiceClass(serviceFile, packageName, className);
			}

			File daoDir = new File(packageFilePath + "/dao/");
			if(!daoDir.exists()){
				daoDir.mkdir();
			}
			String daoName = className + "Dao.java";
			File daoFile = new File(packageFilePath + "/dao/" + daoName);
			if (!daoFile.exists()) {
				createDaoClass(daoFile, packageName, className);
			}

			File domainDir = new File(packageFilePath + "/domain/");
			if(!domainDir.exists()){
				domainDir.mkdir();
			}
			String domainName = className  + ".java";
			File domainFile = new File(packageFilePath + "/domain/" + domainName);
			if (!domainFile.exists()) {
				createDomainClass(domainFile, packageName, className, tableName, cols);
			}

			String mapperName = className + "Mapper.xml";
			File mapperFile = new File(resourceDir + "/mybatis/mapper/" + mapperName);
	        if (!mapperFile.exists()) {
	            createMapperXml(mapperFile, packageName, tableName, cols);
	        }

		} catch (Exception e) {
			e.printStackTrace();
		}

	}

	public static Map<String, String> cols2Mapper(List<TableBean> cols) {
		Map<String, String> map = new LinkedHashMap<String, String>();
		for(TableBean bean : cols) {
			String column = bean.getColName();
			String field = underscoreToCamelCase(column);
			map.put(field, column);
		}
		return map;
	}

	public static String jdbcType(String colType) {
		if(colType.indexOf("(") > -1) {
			colType = colType.substring(0, colType.indexOf("("));
		}
		if(colType.equalsIgnoreCase("int")) {
			colType = "INTEGER";
		}else if(colType.equalsIgnoreCase("datetime")) {
			colType = "TIMESTAMP";
		}else if(colType.equalsIgnoreCase("text")) {
			colType = "VARCHAR";
		}else if(colType.equalsIgnoreCase("binary")) {
			colType = "VARCHAR";
		}
		return colType;
	}

	public static String insertSql(String tableName, List<TableBean> cols) {
        Map<String, String> map = cols2Mapper(cols);
        StringBuilder sb = new StringBuilder("INSERT INTO " + tableName + "\n");
        Object[] filedNames = map.keySet().toArray();
        Object[] colNames = map.values().toArray();
        sb.append("		( " + join(colNames) + " ) \n");
        sb.append("		VALUES \n");
        sb.append("		( " + join2(filedNames) + " ) ");
        return sb.toString();
    }

    public static String selectSql(String tableName, List<TableBean> cols) {
        Map<String, String> map = cols2Mapper(cols);
        StringBuilder sb = new StringBuilder("SELECT ");
        Object[] colNames = map.values().toArray();
        sb.append(join(colNames) + "\n		FROM " + tableName);
        return sb.toString();
    }

    public static String updateSql(String tableName, List<TableBean> cols) {
        StringBuilder sb = new StringBuilder("UPDATE " + tableName);
        sb.append("\n		<trim prefix=\"SET\" suffixOverrides=\",\" > ");

        for(TableBean bean : cols) {
    		String jdbcType = jdbcType(bean.getColType().toUpperCase());
    		String field = underscoreToCamelCase(bean.getColName());
    		if("id".equalsIgnoreCase(field)
    				|| "createAt".equalsIgnoreCase(field)) {
    			//pass
    		}else {
    			sb.append("\n			<if test=\"" + field + " != null \">");
        		sb.append("\n			" + bean.getColName() + " = #{" + field + ", jdbcType=" + jdbcType + "},");
    			sb.append("\n			</if>");
    		}
    	}

        sb.append("\n		</trim>");
        sb.append("\n		WHERE id = #{id} ");
        return sb.toString();

    }

    public static String beanMapSql(String packageClass, List<TableBean> cols) {
    	StringBuilder sb = new StringBuilder("<resultMap id=\"bean_map\" type=\"" + packageClass + "\" >");
    	for(TableBean bean : cols) {
    		String jdbcType = jdbcType(bean.getColType().toUpperCase());
    		String field = underscoreToCamelCase(bean.getColName());
    		sb.append("\n		<result column=\""+ bean.getColName() +"\" property=\"" + field + "\"  jdbcType=\"" + jdbcType + "\" />");
    	}
    	sb.append("\n	</resultMap>\n");
    	return sb.toString();
    }

    public static String sqlColumns(String packageClass, List<TableBean> cols) {
    	StringBuilder sb = new StringBuilder("<sql id=\"all_columns\">\n		");
    	for(int i = 0; i< cols.size(); i++) {
    		sb.append(cols.get(i).getColName());
    		if(i != cols.size() - 1) {
    			sb.append(", ");
    		}
    	}
    	sb.append("\n	</sql>\n");
    	return sb.toString();
    }

	public static String join(Object[] arr) {
		StringBuilder sb = new StringBuilder();
		for (Object s : arr) {
			sb.append(s + ",");
		}
		String str = sb.toString();
		return str.substring(0, str.length() - 1);
	}

	public static String join2(Object[] arr) {
		StringBuilder sb = new StringBuilder();
		for (Object s : arr) {
			sb.append("#{" + s + "},");
		}
		String str = sb.toString();
		return str.substring(0, str.length() - 1);
	}

	public static void createDaoClass(File classFile, String packageName, String className) {
		try {
			String tmpPackageName = packageName  + ".dao;";
			String tmpClassName = className + "Dao";
			classFile.createNewFile();

			StringBuilder sb = new StringBuilder();
			sb.append("package " + tmpPackageName + "\n\n");

			sb.append("import java.util.List;\n");
			sb.append("import org.apache.ibatis.annotations.Mapper;\n");
			sb.append("import " + packageName + ".common.page.Pagination;\n");
			sb.append("import " + packageName  + ".domain." + className + ";\n");

			sb.append("\n\n");
			sb.append("@Mapper\n");
			sb.append("public interface " + tmpClassName + " {\n\n");

			sb.append("	public " + className + " getById(Long id);\n\n");

			sb.append("	public List<" + className + "> queryAll(" + className + " queryEntity);\n\n");

			sb.append("	public Integer getTotalItemsCount(" + className + " queryEntity);\n\n");

			sb.append("	public List<" + className + "> queryPage(" + className + " queryEntity , Pagination<"
					+ className + "> page);\n\n");

			sb.append("	public void create(" + className + " entity);\n\n");

			sb.append("	public void update(" + className + " entity);\n\n");

			sb.append("	public void delete(" + className + " entity);\n\n");

			sb.append("\n\n}\n\n");
			OutputStream os = new FileOutputStream(classFile);
			PrintStream ps = new PrintStream(os);
			ps.print(sb);

			os.flush();
			os.close();
			ps.flush();
			ps.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	public static void createDomainClass(File classFile, String packageName, String className, String tableName, List<TableBean> cols) {
		try {
			classFile.createNewFile();
			StringBuilder sb = new StringBuilder();
			sb.append("package " + packageName + ".domain;\n\n");
			sb.append("import java.util.Date;\n");

			sb.append("\n\n");
			sb.append("public class " + className + " extends AbstractEntity{\n\n");

			for (TableBean vo : cols) {
				String col = vo.getColName();
				if(!isPassColumn(col)){
					String type = vo.getColType();
					String javaType = " String ";
					if (type.toLowerCase().contains("smallint") || type.toLowerCase().contains("tinyint")) {
						javaType = " Integer ";
					} else if (type.toLowerCase().contains("date")) {
						javaType = " Date ";
					} else if (type.toLowerCase().contains("int")) {
						javaType = " Long ";
					} else if (type.toLowerCase().contains("decimal")) {
						javaType = " Double ";
					}
					sb.append("	private" + javaType + underscoreToCamelCase(col.toLowerCase()) + ";");
					sb.append("//" + new String(vo.getColComment()) + "\n");
				}
			}

			sb.append("\n");

			// setter & getter
			for (TableBean vo : cols) {
				String col = vo.getColName();
				if(!isPassColumn(col)){
					String type = vo.getColType();
					String javaType = " String ";
					if (type.toLowerCase().contains("smallint") || type.toLowerCase().contains("tinyint")) {
						javaType = " Integer ";
					} else if (type.toLowerCase().contains("date")) {
						javaType = " Date ";
					} else if (type.toLowerCase().contains("int")) {
						javaType = " Long ";
					} else if (type.toLowerCase().contains("decimal")) {
						javaType = " Double ";
					}
					String property = underscoreToCamelCase(col.toLowerCase());
					sb.append("	public" + javaType + "get" + upperCaseFirst(property) + "(){\n");
					sb.append("		return " + property + ";\n");
					sb.append("	}\n");

					sb.append("	public void set" + upperCaseFirst(property) + "(" + javaType.trim() + " " + property
							+ "){\n");
					sb.append("		this." + property + " = " + property + ";\n");
					sb.append("	}\n\n");
				}
			}

			sb.append("\n}\n");
			OutputStream os = new FileOutputStream(classFile);
			PrintStream ps = new PrintStream(os);
			ps.print(sb);

			os.flush();
			os.close();
			ps.flush();
			ps.close();

		} catch (IOException e) {
			e.printStackTrace();
		}

	}

	public static void createServiceClass(File classFile, String packageName, String className) {
		try {
			String tmpPackageName = packageName  + ".service;";
			String tmpClassName = className + "Service";

			classFile.createNewFile();

			StringBuilder sb = new StringBuilder();
			sb.append("package " + tmpPackageName + "\n\n");

			sb.append("import java.util.Date;\n");
			sb.append("import java.util.List;\n");
			sb.append("import " + packageName + ".common.page.Pagination;\n");
			sb.append("import org.springframework.stereotype.Service;\n");
			sb.append("import org.springframework.beans.factory.annotation.Autowired;\n");

			sb.append("import " + packageName  + ".domain." + className + ";\n");
			sb.append("import " + packageName  + ".service." + className + "Service;\n");
			sb.append("import " + packageName  + ".dao." + className + "Dao;\n");

			sb.append("\n\n");

			sb.append("@Service\npublic class " + tmpClassName + " extends AbstractService<" + className + ">{\n\n");

			sb.append("	@Autowired\n	private " + className + "Dao entityDao;\n\n");

			sb.append("	public " + className + " getById(Long id){" + "\n		return entityDao.getById(id);\n"
					+ "	}\n\n");

			sb.append("	public List<" + className + "> queryAll(" + className + " queryEntity){"
					+ "\n		return entityDao.queryAll(queryEntity);\n" + "	}\n\n");

			sb.append("	public Pagination<" + className + "> queryPage(" + className + " queryEntity ,Pagination<"
					+ className + "> page){"
					+ "\n		Integer itemsTotalCount = entityDao.getTotalItemsCount(queryEntity);" + "\n		List<"
					+ className + "> items = entityDao.queryPage(queryEntity,page);"
					+ "\n		page.setItemsTotalCount(itemsTotalCount);" + "\n		page.setItems(items);"
					+ "\n		return page;" + "\n	}\n\n");

			sb.append("	public void create(" + className + " entity){" + "\n		entity.setCreateAt(new Date());\n		entityDao.create(entity);\n"
					+ "	}\n\n");

			sb.append("	public void update(" + className + " entity){" + "\n		entityDao.update(entity);\n"
					+ "	}\n\n");

			sb.append("	public void delete(" + className + " entity){" + "\n		entityDao.delete(entity);\n"
					+ "	}\n\n");

			sb.append("\n\n}\n\n");
			
			OutputStream os = new FileOutputStream(classFile);
			PrintStream ps = new PrintStream(os);
			ps.print(sb);
			
			os.flush();
			os.close();
			ps.flush();
			ps.close();
			
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	public static void createMapperXml(File daoXmlFile, String packageName, String tableName, List<TableBean> cols) {
		try {
			String beanName = underscoreToCamelCase(tableName, true);
			String packageAndDaoClass = packageName + ".dao." + beanName + "Dao";
			String packageAndClass = packageName + ".domain." + beanName;

			StringBuilder sb = new StringBuilder();
			sb.append("<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n");
			sb.append(
					"<!DOCTYPE mapper PUBLIC \"-//mybatis.org//DTD Mapper 3.0//EN\" \"http://10.20.91.130/dtd/mybatis-3-mapper.dtd\" >");

			sb.append("\n\n<mapper namespace=\"" + packageAndDaoClass + "\">\n");

			sb.append("\n	" + beanMapSql(packageAndClass, cols));
			sb.append("\n	" + sqlColumns(packageAndClass, cols));
			
			sb.append("\n	<select id=\"queryAll\" parameterType=\"" + packageAndClass + "\" resultMap=\"bean_map\">");
			sb.append("\n		SELECT ");
			sb.append("\n		<include refid=\"all_columns\"  />");
			sb.append("\n		FROM " + tableName );
			sb.append("\n		ORDER BY id DESC");
			sb.append("\n	</select>");

			sb.append("\n\n	<select id=\"getTotalItemsCount\" parameterType=\"" + packageAndClass + "\" resultType=\"java.lang.Integer\">");
			sb.append("\n		SELECT COUNT(id) FROM " + tableName);
			sb.append("\n	</select>");

			sb.append("\n\n	<select id=\"queryPage\"" + " resultMap=\"bean_map\">");
			sb.append("\n		SELECT");
			sb.append("\n		<include refid=\"all_columns\"  />");
			sb.append("\n		FROM " + tableName);
			sb.append("\n		ORDER BY id DESC");
			sb.append("\n		LIMIT #{param2.startIndex} , #{param2.pageSize} ");
			sb.append("\n	</select>");

			sb.append("\n\n	<select id=\"getById\" parameterType=\"java.lang.Long\" resultMap=\"bean_map\">" );
			sb.append("\n		SELECT");
			sb.append("\n		<include refid=\"all_columns\"  />");
			sb.append("\n		FROM " + tableName);
			sb.append("\n		WHERE id = #{id}");
			sb.append("\n	</select>");

			sb.append("\n\n	<insert id=\"create\" parameterType=\"" + packageAndClass
					+ "\" flushCache=\"true\"  useGeneratedKeys=\"true\" keyProperty=\"id\"  >");
			sb.append("\n		" + insertSql(tableName, cols));
			sb.append("\n	</insert>");

			sb.append("\n\n	<update id=\"update\" parameterType=\"" + packageAndClass + "\" flushCache=\"true\">");
			sb.append("\n		" + updateSql(tableName, cols));
			sb.append("\n	</update>");

			sb.append("\n\n	<delete id=\"delete\" parameterType=\"" + packageAndClass + "\" >");
			sb.append("\n		DELETE FROM " + tableName + "\n		WHERE id = #{id}");
			sb.append("\n	</delete>");

			sb.append("\n\n</mapper>\n");

			OutputStream os = new FileOutputStream(daoXmlFile);
			PrintStream ps = new PrintStream(os);
			ps.print(sb);

			os.flush();
			os.close();
			ps.flush();
			ps.close();
		} catch (Exception e) {
			e.printStackTrace();
		}

	}
	
	public static boolean isPassColumn(String col) {
		if ("CREATETIME".equalsIgnoreCase(col) || "CREATE_USER".equalsIgnoreCase(col)
				|| "CREATE_TIME".equalsIgnoreCase(col) || "UPDATE_USER".equalsIgnoreCase(col)
				|| "UPDATE_TIME".equalsIgnoreCase(col) || "DEL".equalsIgnoreCase(col)
				|| "ID".equalsIgnoreCase(col) 
				|| "CREATEAT".equalsIgnoreCase(col) || "UPDATEAT".equalsIgnoreCase(col) ) {
			return true;
		}
		return false;
	}
	
	public static Map<String, String> getAllFieldColumns(Class<?> clazz) {
		try {
			Map<String, String> map = new LinkedHashMap<String, String>();
			Field[] fields = clazz.getDeclaredFields();
			if (fields != null) {
				for (Field field : fields) {
					if (!"serialVersionUID".equals(field.getName())) {// 序列化ID不需要
						String fieldName = field.getName();
						String colName = camelCase2Underscore(fieldName);
						map.put(fieldName, colName);
					}
				}
			}
			Class<?> superClass = clazz.getSuperclass();// 递归获取父类的Field
			Map<String, String> superMap = getAllFieldColumns(superClass);
			if (superMap != null) {
				map.putAll(superMap);
			}
			if (map.size() == 0) {
				return null;
			}
			return map;
		} catch (Exception e) {
			e.printStackTrace();
			return null;
		}
	}
	
	/**
	 * 转换将第一个字母大写变成小写，并在前面加下划线
	 * @param args
	 */
	public static String camelCase2Underscore(String str) {
		char[] chars = str.toCharArray();
		String rstStr = "";
		for (int i = 0; i < chars.length; i++) {
			if (chars[i] > 64 && chars[i] < 94) {
				rstStr += ("_" + chars[i]).toLowerCase();
			} else {
				rstStr += chars[i];
			}
		}
		return rstStr;
	}
	
	/**
	 * 下划线转骆驼命名法，首字母大写
	 */
	public static String underscoreToCamelCase(String str, boolean upperFirst) {
		if(upperFirst) {//是否首字母大写
			str = underscoreToCamelCase(str);
			return upperCaseFirst(str);
		}else {
			return underscoreToCamelCase(str);
		}
	}
	
	public static String underscoreToCamelCase(String str) {
		String[] arr = str.split("_");
		String rstStr = "";
		if (arr.length > 1) {
			rstStr = arr[0];
			for (int i = 1; i < arr.length; i++) {
				rstStr += upperCaseFirst(arr[i]);
			}
		} else {
			rstStr = str;
		}
		return lowerCaseFirst(rstStr);
	}
	
	/**
	 * 首字母变大写
	 * @param args
	 */
	public static String upperCaseFirst(String str) {
		return Character.toUpperCase(str.charAt(0)) + str.substring(1, str.length());
	}

	/**
	 * 首字母变小写
	 * @param args
	 */
	public static String lowerCaseFirst(String str) {
		return Character.toLowerCase(str.charAt(0)) + str.substring(1, str.length());
	}

	public static String stringCap(String str) {
		return str.substring(0, 1).toLowerCase() + str.substring(1);
	}

}

2.TableBean

package com.yh.common.t2b;

public class TableBean {
	
	private String tableSchema;
	private String tableName;
	
	private String colName;
	private String colType;
	private String colComment;
	
	
	public String getTableSchema() {
		return tableSchema;
	}
	public void setTableSchema(String tableSchema) {
		this.tableSchema = tableSchema;
	}
	public String getTableName() {
		return tableName;
	}
	public void setTableName(String tableName) {
		this.tableName = tableName;
	}
	public String getColName() {
		return colName;
	}
	public void setColName(String colName) {
		this.colName = colName;
	}
	public String getColType() {
		return colType;
	}
	public void setColType(String colType) {
		this.colType = colType;
	}
	public String getColComment() {
		return colComment;
	}
	public void setColComment(String colComment) {
		this.colComment = colComment;
	}

	
}

 3.TableBeanDao接口

package com.yh.common.t2b;

import org.apache.ibatis.annotations.Mapper;

import java.util.List;


@Mapper
public interface TableBeanDao {
	public List<String> listTables(TableBean vo);
	public List<TableBean> listTableCols(TableBean vo);
}

4.TableBeanMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://10.20.91.130/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com....TableBeanDao">
	
	<select id="listTables" parameterType="com....TableBean"  resultType="java.lang.String">
		SELECT Table_Name 
		From information_schema.TABLES 
		WHERE TABLE_SCHEMA = '${tableSchema}';
	</select>
	
	<select id="listTableCols" parameterType="com.......TableBean" resultType="com......TableBean">
		SELECT COLUMN_NAME as colName, COLUMN_TYPE as colType, COLUMN_COMMENT as colComment
		FROM information_schema.COLUMNS 
		WHERE TABLE_SCHEMA = '${tableSchema}'
		AND TABLE_NAME = '${tableName}';
	</select>

</mapper>

5.TableBeanDaoTest 

package com.yh;

import com.yh.common.t2b.Table2BeanHelper;
import com.yh.common.t2b.TableBean;
import com.yh.common.t2b.TableBeanDao;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;


@SpringBootTest
public class TableBeanDaoTest {

    @Autowired
    private TableBeanDao tableBeanDao;

    @Test
    public void createTableBeans(){

        //换成你的项目目录
        String mainDir = "D:\\你的mian目录";
        String packageName = "com.你的项目目录";
        //你的数据库名称
        String database = "studentdb";

        TableBean vo = new TableBean();
        vo.setTableSchema(database);
        //针对整个数据库反转，已经存在了的不会反转和覆盖
        List<String> tables = tableBeanDao.listTables(vo);
        for (String table : tables) {
            System.out.println("table = " + table);
            vo.setTableName(table);
            List<TableBean> cols = tableBeanDao.listTableCols(vo);
            Table2BeanHelper.convert(mainDir, packageName , table, cols);
        }

    }
}

You辉编程分享
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
安卓工具类整理
02-21
在Android开发中，工具类（Util）是一种封装了常用功能的方法集合，可以帮助开发者更高效地编写代码，提高代码的可重用性和可维护性。以下是对"安卓工具类整理"这个主题的详细说明： 1. **字符串处理工具类**： - ...
DBUtilLiubaobao工具类
11-12
DBUtilLiubaobao工具类是Java编程中常见的一种数据库操作辅助类，它的主要功能是简化对数据库的CRUD（创建、读取、更新、删除）操作。在Java开发中，通常会封装这样的工具类，以提高代码的复用性和可维护性。下面将...
Hbase CRUD 工具类
Shawn.Xiao的博客
03-14 263
1、向hbase 中添加数据： /** * by 1022 * @param tableName * @param row * @param columnFamily * @param column * @param data * @throws IOException */ public static void putData(String tableName
Java连接MySQL和CRUD工具类
百味皆苦的博客
01-16 375
获取连接 package com.zhuoer.qmaintance.utils; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBTools { private static final String URL = "jdbc:m...
JavaWeb学习-JDBC系列-8-基于DBUtils工具类的CRUD练习
Anthony_tester的博客
04-26 451
前面我们封装了一个用于连接数据库和关闭资源的DBUtils的类，可以减少很多重复的代码。这个类，提供了连接数据库和关闭资源的两个静态方法。再次复习下这个类中加载properties文件，为什么要使用静态代码块，也就是static{}，因为我们想，这个DBUtils类一加载到JVM虚拟机就里面执行加载解析propertes文件操作。这个技巧，我们之前在Selenium自动化中写driver的初始化也...
数据库CRUD封装
qq_61956639的博客
04-07 461
数据库CRUD封装
Java操作MySQL，创建JDBC工具类、使用Druid连接池技术，实现CRUD(增、删、改、查)
lb_99的博客
06-03 1721
Java操作MySQL，创建JDBC工具类、使用Druid连接池技术，实现CRUD(增、删、改、查)
ElasticSearch组件--RestHighLevelClient工具类
qq_45317823的博客
02-14 1096
es添加、修改文档
使用c#完成数据库的crud操作
weixin_61822456的博客
05-27 463
首先需要向所在项目导入MySql.Data.MySqlClient的netget包,通过该扩展中的操作类操作mysq 首先创建三个变量在之后需要使用 MySqlConnection conn; //连接数据库对象 MySqlDataAdapter adapter; //适配器变量 DataSet set; //临时数据集 在在一个按钮的功能中添加连接数据库的功能 //connStr连接数据库的登录信息 string connSt...
java后端CRUD功能实现
daniaoxp的博客
09-14 3499
1、springboot框架建立 框架建立可参考以下博客，需要把补充部分也完成 https://blog.csdn.net/daniaoxp/article/details/119811741 内容稍有不同，还要做以下改变。 改变1： 下面操作不需要 改变2： 在HelloApplication.java文件中新增**@MapperScan（“com.xp.dao”）** 改变3： application.yml文件内容换成以下内容 server: port: 8888 spring: dat
DBUtils工具类实现CRUD操作
成长，编程，生活
01-26 572
Apache-DBUtils简介 commons-dbutils 是 Apache 组织提供的一个开源 JDBC工具类库，它是对JDBC的简单封装，帮我们简化了CRUD 的代码。其中的主要API，如QueryRunner类简化了SQL查询，它与ResultSetHandler接口（或其实现类）组合在一起使用可以完成大部分的数据库操作，能够大大减少编码量。 主要API简述： QueryRunner...
Android SQLite 抽象出CRUD操作工具类
纸上得来终觉浅，绝知此事要躬行
05-16 892
1, 定义统一的Dao接口 public interface IDao { public abstract T getSingleById(int id); public abstract List getAll(); public abstract boolean update(T video); public abstract int deleteByIds(Collec
一些常用的common工具类
04-23
在IT行业中，工具类是程序员日常开发中不可或缺的一部分。这些工具类通常包含了各种实用方法，可以简化编程工作，提高效率。"一些常用的common工具类"这个主题，涉及到的是那些广泛应用于多个项目，处理通用任务的类...
DBUtil工具类jar包
11-21
DBUtil工具类是Java开发中常见的一种数据库操作辅助类，它的主要目的是为了简化数据库的CRUD（创建、读取、更新、删除）操作，提高开发效率。DBUtil通常集成了连接池技术，如Druid、C3P0或HikariCP等，以优化数据库...
简单crud代码生成工具
03-29
【简单CRUD代码生成工具详解】 在软件开发过程中，尤其是企业级应用开发，CRUD（Create, Read, Update, Delete）操作是最基本的数据操作。这些操作涵盖了创建新记录、读取现有记录、更新记录和删除记录，是数据库...
使用hutool工具判断字符串是否全部是字母(包括大小写)，java判断字符串是否全部是字母(包括大小写)
qq_43700885的博客
07-29 452
1.导入hutool的maven依赖。2.复制一下代码执行。
java判断邮箱地址是否正确，使用hutool工具判断邮箱地址是否正确
qq_43700885的博客
07-29 256
1.导入hutool的maven依赖。2.直接复制一下代码运行。
Swagger使用Map接受参数时，页面如何显示具体参数及说
a1058926697的博客
07-26 624
后端使用Map接受参数，要求在swagger页面上显示具体的参数名称、类型及说明。当Map接受参数数量少时，可以使用Swagger自带的注解。自定义注解 @ApiGlobalModel。编写处理注解对应的插件。
花几千上万学习Java，真没必要！（三十五）
最新发布
wehpd的博客
07-30 296
集合之Map
mongodb工具类
09-07
根据引用和引用的内容可以得知，mongodb工具类是为了方便对MongoDB进行常用操作而封装的一个CRUD的工具类。它可以满足常规的数据查询、数据写入、数据修改和数据删除操作。这个工具类的设计初衷是为了减少学习和维护成本，同时通过直接使用JDBC方式来更方便地控制操作。该工具类并没有使用Spring Data、Morphia等框架，因此在使用之前最好掌握一定的MongoDB查询语法。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值