基于SSM的医院信息管理系统-Java代码类资源

package com.qhit.utils; /** * Created by Administrator on 2018/7/25 0025. */ import java.io.BufferedWriter; import java.io.File; import java.io.FileWriter; import java.io.IOException; import java.sql.*; import java.text.SimpleDateFormat; import java.util.Date; /** * 根据表名，自动生成javabean,dao,mapper,service,service实现类 * * Version 1.5 * 1.自动生成mapper文件 2.自动生成下拉框,实现下拉框的自动化 * */ public class GenerateCode { private static String tableName = "in_patient"; private static String tableChineseName = "病人"; private static String javaBeanName = BaseDao.dbTableToJavaBean(tableName); private static String javaPackageName = BaseDao.toLowerCaseFirstOne(javaBeanName); private static BaseDao dao = new BaseDao(); public static void main(String[] args) throws Exception { //连接 Connection conn = dao.getConn(); String sql = "select * from "+tableName; sql=sql.toLowerCase(); PreparedStatement ps = conn.prepareStatement(sql); ResultSet rs = ps.executeQuery(); //元数据 ResultSetMetaData metaData = rs.getMetaData(); rs.close(); //字段注释 String[] comments = findComments(conn, metaData); //文件输出位置 File dir = new File("C:\\F\\codeout"); if(!dir.exists()){ dir.mkdirs(); } //删除文件夹下的所有文件 delAllFile(dir.getAbsolutePath()); //创建 pojo dao service 文件夹 makeSomeDirs(dir); //javabean String beanName = javaBeanName+".java"; BufferedWriter beanWriter = new BufferedWriter(new FileWriter(dir.getAbsolutePath()+"\\com\\qhit\\"+javaPackageName+"\\pojo\\"+beanName)); //dao String daoName = "I"+javaBeanName+"Dao.java"; BufferedWriter daoWriter= new BufferedWriter(new FileWriter(dir.getAbsolutePath()+"\\com\\qhit\\"+javaPackageName+"\\dao\\"+daoName)); //Mapper文件 String mapperName = javaBeanName+"Mapper.xml"; BufferedWriter mapperWriter= new BufferedWriter(new FileWriter(dir.getAbsolutePath()+"\\com\\qhit\\"+javaPackageName+"\\dao\\"+mapperName)); //service String serviceName = "I"+javaBeanName+"Service.java"; BufferedWriter serviceWriter= new BufferedWriter(new FileWriter(dir.getAbsolutePath()+"\\com\\qhit\\"+javaPackageName+"\\service\\"+serviceName)); //service实现类 String serviceImplName = javaBeanName+"ServiceImpl.java"; BufferedWriter serviceImplWriter= new BufferedWriter(new FileWriter(dir.getAbsolutePath()+"\\com\\qhit\\"+javaPackageName+"\\service\\impl\\"+serviceImplName)); //Controller String controllerName = javaBeanName+"Controller.java"; BufferedWriter controllerWriter = new BufferedWriter(new FileWriter(dir.getAbsolutePath()+"\\com\\qhit\\"+javaPackageName+"\\controller\\"+controllerName)); //list.jsp String listJspName = "list.jsp"; BufferedWriter listJspWriter = new BufferedWriter(new FileWriter(dir.getAbsolutePath()+"\\jsp\\"+javaPackageName+"\\"+listJspName)); //add.jsp String addJspName = "add.jsp"; BufferedWriter addJspWriter = new BufferedWriter(new FileWriter(dir.getAbsolutePath()+"\\jsp\\"+javaPackageName+"\\"+addJspName)); //edit.jsp String editJspName = "edit.jsp"; BufferedWriter editJspWriter = new BufferedWriter(new FileWriter(dir.getAbsolutePath()+"\\jsp\\"+javaPackageName+"\\"+editJspName)); Date date = new Date(); SimpleDateFormat format = new SimpleDateFormat("yyyy/MM/dd"); String now = format.format(date); // dao generateDao(metaData,javaBeanName, daoWriter, now); //mapper文件 generateMapper(metaData,javaBeanName, mapperWriter, now); //javabean generateJavaBean(metaData, javaBeanName, beanWriter, now,comments); // service generateService(metaData,javaBeanName, serviceWriter, now); //dao实现类 generateServiceImpl(metaData,javaBeanName, serviceImplWriter, now); //controller generateController(metaData,javaBeanName, controllerWriter, now); //list.jsp generateListJsp(metaData,javaBeanName, listJspWriter, now,comments); //add.jsp generateAddJsp(metaData,javaBeanName, addJspWriter, now,comments); //edit.jsp generateEditJsp(metaData,javaBeanName, editJspWriter, now,comments); System.out.println("执行成功"); } private static void generateEditJsp(ResultSetMetaData metaData, String javaBeanName, BufferedWriter editJspWriter, String now, String[] comments) throws IOException, SQLException { editJspWriter.write("<%-- \r\n"); editJspWriter.write(" Created by IntelliJ IDEA. \r\n"); editJspWriter.write(" "+now+" \r\n"); editJspWriter.write(" To change this template use File | Settings | File Templates. \r\n"); editJspWriter.write("--%> \r\n"); editJspWriter.write("<%@ page contentType=\"text/html;charset=UTF-8\" language=\"java\" %> \r\n"); editJspWriter.write("<%@include file=\"/common/common.jsp\"%> \r\n"); editJspWriter.write("<html> \r\n"); editJspWriter.write("<head> \r\n"); editJspWriter.write(" <title>Title</title>\r\n"); editJspWriter.write("</head> \r\n"); editJspWriter.newLine(); //主键 String primarykey = metaData.getColumnName(1); String priName = BaseDao.dbColsToJavaCols(primarykey); editJspWriter.write("<body class=\"main\"> \r\n"); editJspWriter.write("<form action=\"${path}/"+javaPackageName+"/update.action\"> \r\n"); editJspWriter.write(" <h1>修改"+tableChineseName+"</h1> \r\n"); editJspWriter.write(" <input type=\"hidden\" name=\""+priName+"\" value=\"${"+javaPackageName+"."+priName+"}\"> \r\n"); editJspWriter.write(" <div class=\"update\"> \r\n"); int count = metaData.getColumnCount(); for(int i=2;i<=count;i++){ String columnName = metaData.getColumnName(i); String javaCol = BaseDao.dbColsToJavaCols(columnName); //列类型 大写 String type = metaData.getColumnTypeName(i); if(i%2==0){ editJspWriter.write(" <div class=\"left\"> \r\n"); }else{ editJspWriter.write(" <div class=\"right\"> \r\n"); } editJspWriter.write(" <span>"+comments[i-1]+"</span> \r\n"); if ("DATE".equals(type) || "DATETIME".equals(type) || "TIMESTAMP".equals(type)){ editJspWriter.write(" <input type=\"date\" name=\""+javaCol+"\" value=\"${"+javaPackageName+"."+javaCol+"}\"> \r\n"); }else{ editJspWriter.write(" <input type=\"text\" name=\""+javaCol+"\" value=\"${"+javaPackageName+"."+javaCol+"}\"> \r\n"); } editJspWriter.write(" </div> \r\n"); } //字段格式是偶数个 后面加上一个空的div 为了好看 if(count%2==0){ editJspWriter.write(" <div class=\"right\"> \r\n"); editJspWriter.write(" </div> \r\n"); } editJspWriter.write(" <div id=\"error\"></div> \r\n"); editJspWriter.write(" <div class=\"buttons\"> \r\n"); editJspWriter.write(" <input type=\"submit\" value=\"提交\"> \r\n"); editJspWriter.write(" <input type=\"button\" onclick=\"history.back()\" value=\"返回\"> \r\n"); editJspWriter.write(" </div> \r\n"); editJspWriter.write(" </div> \r\n"); editJspWrit