velocity java web代码生成器（controller、service、model）

于 2017-01-10 16:47:18 发布
阅读量2.3k 收藏
点赞数
分类专栏： java心得 文章标签： velocity 代码生成 mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/ardo_pass/article/details/54315374
版权
介绍了一款能够根据模板自动生成JavaWeb项目的Controller、Service、Model等代码的工具。该工具利用反射机制从MySQL数据库表中获取信息，并通过Velocity模板引擎生成代码。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

最新写了一个java web代码生成器，主要可以根据模板生成对应的controller、service、model。尤其是在做毕业设计时，很多code都是类似，这样就少去了ctrl+c/v的时间。

其核心是根据反射mysql数据表clum映射到实体中，然后遍历velocity自定义的模板文件，生成代码。

操作界面：


生成代码：


对应表实体：



/**
 * 数据库信息获得操作类
 * 
 * @ClassName: DatabaseInfoOp
 * @author ardo
 */
public class DatabaseInfoOp {

	Connection conn = null;

	private String classDriver;
	private String url;
	private String username;
	private String password;
	private String schema;

	/**
	 * 获得表数据
	 * 
	 * @Title: getDbInfo
	 * @return
	 * @throws SQLException
	 */
	public Database getDbInfo(String tableNamePattern) throws SQLException {
		Database databaseBean = new Database();
		// 表队列
		List<Table> tableList = new ArrayList<Table>();
		// 初始化数据库
		getConnectionByJDBC();
		// 获取数据库信息
		DatabaseMetaData dbmd = conn.getMetaData();
		databaseBean.setDatabaseProductName(dbmd.getDatabaseProductName());
		// 获得数据库表
		ResultSet rs = dbmd.getTables(null, null, tableNamePattern, new String[] { "TABLE", "VIEW" });
		// String tableName = "";
		while (rs.next()) {
			Table table = new Table();

			table.setTableName(rs.getString("TABLE_NAME"));
			table.setTableComment(rs.getString("REMARKS"));
			table.setTableSchem(rs.getString(1));

			// 设置列信息
			ResultSet rscol = dbmd.getColumns(null, null, table.getTableName(), null);
			Column tempColumn;
			while (rscol.next()) {
				tempColumn = new Column();
				tempColumn.setColumnName(rscol.getString("COLUMN_NAME"));
				tempColumn.setColumnType(Integer.parseInt(rscol.getString("DATA_TYPE")));

				String remarks = rscol.getString("REMARKS");
				if (remarks.length() < 1)
					remarks = "";
				tempColumn.setColumnComment(remarks);
				tempColumn.setAutoIncrement(rscol.getString("IS_AUTOINCREMENT").equals("YES"));
				tempColumn.setNullAble(rscol.getString("IS_AUTOINCREMENT").equals("YES"));

				// 添加列到表中
				table.getColumnList().add(tempColumn);

			}
			// 设置主键列
			ResultSet rsPrimary = dbmd.getPrimaryKeys(null, null, table.getTableName());
			while (rsPrimary.next()) {
				if (rsPrimary.getString("COLUMN_NAME") != null) {

					for (int i = 0; i < table.getColumnList().size(); i++) {
						Column coltemp = table.getColumnList().get(i);
						if (coltemp.getColumnName().equals(rsPrimary.getString("COLUMN_NAME"))) {
							coltemp.setPrimary(true);
						}
					}

				}
			}

			// 设置外键列
			ResultSet rsFPrimary = dbmd.getImportedKeys(null, null, table.getTableName());
			while (rsFPrimary.next()) {

				for (int i = 0; i < table.getColumnList().size(); i++) {
					Column coltemp = table.getColumnList().get(i);
					if (coltemp.getColumnName().equals(rsFPrimary.getString("FKCOLUMN_NAME"))) {
						coltemp.setForeignKey(true);
					}
				}
			}
			tableList.add(table);
		}
		databaseBean.setTableList(tableList);
		return databaseBean;
	}

	public Database getDbInfo() throws SQLException {
		Database databaseBean = new Database();
		// 表队列
		List<Table> tableList = new ArrayList<Table>();
		// 初始化数据库
		getConnectionByJDBC();
		// 获取数据库信息
		DatabaseMetaData dbmd = conn.getMetaData();
		databaseBean.setDatabaseProductName(dbmd.getDatabaseProductName());
		// 获得数据库表
		ResultSet rs = dbmd.getTables(null, this.schema, null, new String[] { "TABLE", "VIEW" });
		// String tableName = "";
		while (rs.next()) {
			Table table = new Table();
			table.setTableName(rs.getString("TABLE_NAME"));
			table.setTableComment(rs.getString("REMARKS"));
			table.setTableSchem(rs.getString(1));

			// 设置列信息
			ResultSet rscol = dbmd.getColumns(null, null, table.getTableName(), null);

			Column tempColumn;

			while (rscol.next()) {
				tempColumn = new Column();
				tempColumn.setColumnName(rscol.getString("COLUMN_NAME"));
				tempColumn.setColumnType(Integer.parseInt(rscol.getString("DATA_TYPE")));

				String remarks = rscol.getString("REMARKS");
				if (remarks.length() < 1)
					remarks = "";
				tempColumn.setColumnComment(remarks);
				tempColumn.setAutoIncrement(rscol.getString("IS_AUTOINCREMENT").equals("YES"));
				tempColumn.setNullAble(rscol.getString("IS_AUTOINCREMENT").equals("YES"));

				// 添加列到表中
				table.getColumnList().add(tempColumn);

			}

			// 设置主键列
			ResultSet rsPrimary = dbmd.getPrimaryKeys(null, null, table.getTableName());
			while (rsPrimary.next()) {
				if (rsPrimary.getString("COLUMN_NAME") != null) {

					for (int i = 0; i < table.getColumnList().size(); i++) {
						Column coltemp = table.getColumnList().get(i);
						if (coltemp.getColumnName().equals(rsPrimary.getString("COLUMN_NAME"))) {
							coltemp.setPrimary(true);
						}
					}

				}
			}

			// 设置外键列
			ResultSet rsFPrimary = dbmd.getImportedKeys(null, null, table.getTableName());
			while (rsFPrimary.next()) {

				for (int i = 0; i < table.getColumnList().size(); i++) {
					Column coltemp = table.getColumnList().get(i);
					if (coltemp.getColumnName().equals(rsFPrimary.getString("FKCOLUMN_NAME"))) {
						//System.out.println("FKCOLUMN_NAME "+rsFPrimary.getString("FKCOLUMN_NAME"));
						coltemp.setForeignKey(true);
					}
				}
			}
			tableList.add(table);

		}

		databaseBean.setTableList(tableList);
		return databaseBean;
	}
	
}

以下是生成service及持久层代码：

package com.exemple.service.impl;

import java.util.List;
import java.util.Map;
import org.apache.log4j.Logger;
import com.exemple.model.Product;
import com.exemple.service.ProductService;
import com.exemple.util.BeanUtil;

import org.unique.tools.StringUtils;
import org.unique.ioc.annotation.Autowired;
import org.unique.ioc.annotation.Service;
import org.unique.support.orm.dao.Page;
import org.unique.support.orm.dao.SqlBase;
import org.unique.support.orm.exception.UpdateException;
import org.unique.tools.CollectionUtil;

@Service
public class ProductServiceImpl implements ProductService{
	
	@Override
	public Product get(Integer id){
		return Product.db.findByPK(id);		
	}
	
	@Override
	public Map<String, Object> getMap(Product product, Integer id){
		Map<String, Object> resultMap = CollectionUtil.newHashMap();
		if (null == product) {
			product = this.get(id);
		}
		if (null != product) {
			resultMap = BeanUtil.toMap(product);
		}
		return resultMap;
	}
	
	@Override
	public boolean save( String productName, Integer classify, String pic, String describ, String price ){
		int count = 0;
		
		return count > 0;
	}
		
	@Override
	public boolean update(Integer id, String productName, Integer classify, String pic, String describ, String price ){
		int count = 0;
		Product product = this.get(id);
		if (null != product) {
			try {
				
			} catch (UpdateException e) {
				count = 0;
			}
		}
		return count > 0;
	}
	
	@Override
	public boolean delete(Integer id){
		int count = 0;
		if (null != id) {
			Product product = this.get(id);
			if (null != product) {
				try {
					count = Product.db.delete("delete from product where id = ?", id);
				} catch (UpdateException e) {
					count = 0;
				}
			}
		}
		return count > 0;
	}
	
	@Override
	public List<Map<String, Object>> getList(String productName,Integer classify,String pic,String describ,String price, String order){
		SqlBase base = SqlBase.select("select t.* from product t");
		base.eq("t.product_name", productName);
		base.eq("t.classify", classify);
		base.eq("t.pic", pic);
		base.eq("t.describ", describ);
		base.eq("t.price", price);
		base.order(order);
		List<Product> list = Product.db.findList(base.getSQL(), base.getParams());
		return this.getProductMapList(list);
	}
	
	@Override
	public Page<Product> getPageList(String productName,Integer classify,String pic,String describ,String price, Integer page, Integer pageSize, String order){
		SqlBase base = SqlBase.select("select t.* from product t");
		base.eq("t.product_name", productName);
		base.eq("t.classify", classify);
		base.eq("t.pic", pic);
		base.eq("t.describ", describ);
		base.eq("t.price", price);
		base.order(order);
		return Product.db.findListPage(page, pageSize, base.getSQL(), base.getParams());
	}
	
	@Override
	public Page<Map<String, Object>> getPageMapList(Page<Product> pageEntity){

		List<Product> productList = pageEntity.getResults();
		Page<Map<String, Object>> pageMap = new Page<Map<String, Object>>(pageEntity.getTotalCount() , pageEntity.getPage(), pageEntity.getPageSize());

		List<Map<String, Object>> listMap = this.getProductMapList(productList);
		pageMap.setResults(listMap);
		return pageMap;
	}
	
	private List<Map<String, Object>> getProductMapList(List<Product> productList){
		List<Map<String, Object>> mapList = CollectionUtil.newArrayList();
		for (int i = 0, len = productList.size(); i < len; i++) {
			Product product = productList.get(i);
			if (null != product) {
				Map<String, Object> map = this.getMap(product, null);
				mapList.add(map);
			}
		}
		return mapList;
	}
	
}

项目源码下载地址： http://download.youkuaiyun.com/detail/ardo_pass/9733984

评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值