java自动生成代码

1、1.与数据库建立连接在DBUtil中设置数据库相关的参数Class.forName(driverName);conn = DriverManager.getConnection(url, user, password);2.获得数据库中的所有表Mapmaps = new HashMap();PreparedStatement pstate = conn.prepareStatement("show table status");ResultSet results = pstate.executeQuery();while (results.next() String tab

2、leName = results.getString("NAME");String comment = results.getString("COMMENT");maps.put(tableName, comment);3.获得每个表中的信息推荐精选封装一个实体来存储表中的信息PreparedStatement pstate = conn.prepareStatement("show full fields from "        + tableName);   

3、0;ResultSet results = pstate.executeQuery();    List  lists = new ArrayList();while (results.next() Column column = new Column();String field = results.getString("FIELD");column.setFeildMapper(field);String fieldName = processField(field);推荐精选column.setFeild(fieldName);

4、String type = processType(results.getString("TYPE");String comment = results.getString("COMMENT");column.setType(type);column.setComment(comment);lists.add(column);4.拼串输出将固定代码中需要变动的字段从实体中取拼串写入文档中例如给表生成po:public class WritePo     public static void createPo(String p

5、ath,String packageName,String upTable, String lowTable, List columns) throws IOException File folder = new File(path + lowTable + "/po");if (!folder.exists() folder.mkdirs();File beanFile = new File(folder + "/" + upTable + ".java");BufferedWriter bw = new BufferedWrite

6、r(new OutputStreamWriter(推荐精选new FileOutputStream(beanFile);bw.write("package "+packageName+lowTable+".po;");bw.newLine();bw.write("import java.io.Serializable;");bw.newLine();/ bw.write("import lombok.Data;");/ bw.write("import javax.persistence.Entity;&

7、quot;);bw.newLine();bw.write("SuppressWarnings("serial")");bw.newLine();/ bw.write("Entity");/ bw.write("Data");/ bw.newLine();bw.write("public class " + upTable + " implements Serializable ");bw.newLine();bw.newLine();int size = columns.si

8、ze();for (Column vo : columns) / bw.write("t/*" + comments.get(i) + "*/");推荐精选bw.write("t/*");bw.newLine();bw.write("t *" + vo.getComment();bw.newLine();bw.write("t */");bw.newLine();bw.write("tprivate " + vo.getType() + " " + vo.

9、getFeild() + "");bw.newLine();bw.newLine();bw.newLine();/ 生成get 和 set方法String tempField = null;String _tempField = null;String tempType = null;for (Column vo : columns) tempType = vo.getType();_tempField = vo.getFeild();tempField = _tempField.substring(0, 1).toUpperCase()推荐精选+ _tempField.s

10、ubstring(1);bw.newLine();/ bw.write("tpublic void set" + tempField + "(" + tempType + " _" +/ _tempField + ")");bw.write("tpublic void set" + tempField + "(" + tempType + " "+ _tempField + ")");bw.newLine();/ bw.write(&q

11、uot;ttthis." + _tempField + "=_" + _tempField + "");bw.write("ttthis." + _tempField + " = " + _tempField + "");bw.newLine();bw.write("t");bw.newLine();bw.newLine();bw.write("tpublic " + tempType + " get" + tempField + "()");bw.newLine();bw.write("ttreturn this." + _tempField + "");bw.newLin