ibatis mysql 配置文件_mysql数据库自动生成对应的java实体类和ibatis配置文件

package db.tool;

import java.io.File;

import java.io.PrintWriter;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.util.ArrayList;

import java.util.List;

public class Run {

public final static String projectPath =

"E:\\w\\b\\";

public final static String entityPackageName =

"com.entities";

public final static String configPackageName =

"com.config";

public final static String dbDriver =

"com.mysql.jdbc.Driver";

public final static String dbURL =

"jdbc:mysql://127.0.0.1/businessprocess?useUnicode=true&characterEncoding=UTF-8";

public final static String dbUser = "root";

public final static String dbPass = "root";

public static void main(String[] args) throws

Exception {

Run _i_run = new Run();

File _v_folder = new

File(projectPath + "src\\"

+

entityPackageName.replace(".", "\\\\"));

if (!_v_folder.exists())

_v_folder.mkdirs();

_v_folder = new

File(projectPath + "src\\"

+

configPackageName.replace(".", "\\\\"));

if (!_v_folder.exists())

_v_folder.mkdirs();

List

_v_tableNameList = _i_run._m_getDbTableNameList();

File _v_sqlMapFile = new

File(projectPath + "src\\\\autoSqlMap.xml");

if

(!_v_sqlMapFile.exists())

_v_sqlMapFile.createNewFile();

PrintWriter _v_fw = new

PrintWriter(_v_sqlMapFile, "UTF-8");

_v_fw.println("<?xml

version=\"1.0\" encoding=\"UTF-8\"?>\r\n"

+

"/p>

+

" \"-//ibatis.apache.org//DTD SQL Map Config 2.0//EN\""

+

" \"http://ibatis.apache.org/dtd/sql-map-config-2.dtd\">"

+

"\r\n\r\n\r\n\r\n\t

cacheModelsEnabled=\"true\" />");

for (String _v_tblName :

_v_tableNameList) {

_v_fw.println("\t

resource=\""

+

configPackageName.replace(".", "/") + "/"

+

_v_tblName.toLowerCase() + ".xml\" />");

_v_tblName =

_i_run._m_firstToUpperCase(_v_tblName);

System.out.println("table

name:" + _v_tblName);

_i_run._m_packEntityAndConfig(_v_tblName);

}

_v_fw.println("\r\n

");

_v_fw.flush();

_v_fw.close();

}

protected void _m_packEntityAndConfig(String

_v_tblName) throws Exception {

Fields[] _v_fields =

_m_getFields(_v_tblName);

String _v_xmlName =

_v_tblName.toLowerCase();

String _v_fullClsName =

entityPackageName + "." + _v_tblName;

// 打包实体类 start

//

File _v_jFile = new

File(projectPath + "src\\"

+

entityPackageName.replace(".", "\\\\") + "\\\\" +

_v_tblName

+

".java");

if (!_v_jFile.exists())

_v_jFile.createNewFile();

PrintWriter _v_fw = new

PrintWriter(_v_jFile, "UTF-8");

_v_fw.println("package " +

entityPackageName + ";\n");

_v_fw.println("public class

"

+

_v_tblName

+

" implements

com.shareisvalue.framework.BasicEntity,java.io.Serializable

{\n");

_v_fw.println("\tprivate static

final long serialVersionUID=1L;");

for (Fields _v_f :

_v_fields)

_v_fw.println("\tprotected

" + _v_f.getJavaType() + " "

+

_m_toAttributeString(_v_f.getName()) + " = null;");

_v_fw.println("\n\tpublic " +

_v_tblName + "() { }\n"); // 构造函数

_v_fw.println("\tpublic String

getTableName() {"); _v_fw.println("\t\treturn \"" +

_v_xmlName + "\";");

_v_fw.println("\t}\n");

for (Fields _v_f : _v_fields)

{

String

_v_jType = _v_f.getJavaType();

String

_v_sgName = _m_firstToUpperCase(_v_f.getName());

String

_v_fName = _m_toAttributeString(_v_f.getName());

_v_fw.println("\tpublic

" + _v_jType + " get" + _v_sgName + "() {");

_v_fw.println("\t\treturn

" + _v_fName + ";");

_v_fw.println("\t}\n");

_v_fw.println("\tpublic

void set" + _v_sgName + "(" + _v_jType

+

" " + _v_fName + ") {");

_v_fw.println("\t\t

this." + _v_fName + " = " + _v_fName + ";");

_v_fw.println("\t}\n");

}

_v_fw.println("}");

_v_fw.flush();

_v_fw.close();

// 打包实体类 end

//

// 打包sql xml文件 start

//

_v_jFile = new File(projectPath

+ "src\\"

+

configPackageName.replace(".", "\\\\") + "\\\\" +

_v_xmlName

+

".xml");

if (!_v_jFile.exists())

_v_jFile.createNewFile();

_v_fw = new

PrintWriter(_v_jFile, "UTF-8");

_v_fw.println("<?xml

version=\"1.0\" encoding=\"UTF-8\"?>\r\n"

+

""-//ibatis.apache.org//DTD

SQL Map 2.0//EN\""

+

" \"http://ibatis.apache.org/dtd/sql-map-2.dtd\">\r\n\r\n\r\n");

// === select all record

===

String _v_content =

"\t

+

"\" resultClass=\"" + _v_fullClsName

+

"\">\r\n\t\tSELECT * FROM " + _v_xmlName

+

" \r\n\t

\n";

_v_fw.println(_v_content);

// === select by primary key

===

String _v_pkColName =

_m_toAttributeString(_m_getPrimaryKeyColumn(_v_fields));

if (_v_pkColName != null)

{

_v_content =

"\t

_v_xmlName

+

"\" resultClass=\"" + _v_fullClsName

+

"\">\r\n\t\tSELECT * FROM " + _v_xmlName + " WHERE

"

+

_v_pkColName + " = #" + _v_pkColName

+

"# \r\n\t

\r\n";

_v_fw.println(_v_content);

}

// === insert record ===

_v_content =

"\t

+

"\"\r\n\t\tparameterClass=\"" + _v_fullClsName +

"\">\r\n"

+

"\t\tINSERT INTO " + _v_xmlName

+

" \r\n\t\t

prepend=\"(\">";

for (Fields _v_fd : _v_fields)

{

_v_content +=

"\r\n\t\t\t

+

_m_toAttributeString(_v_fd.getName())

+

"\" prepend=\",\">" + _v_fd.getName() +

"

";

}

_v_content +=

"\r\n\t\t\t)\r\n\t\t

\r\n\t\tVALUES \r\n\t\t

prepend=\"(\">";

for (Fields _v_fd : _v_fields)

{

_v_content +=

"\r\n\t\t\t

+

_m_toAttributeString(_v_fd.getName())

+

"\" prepend=\",\">#"

+

_m_toAttributeString(_v_fd.getName()) +

"#

";

}

_v_content +=

"\r\n\t\t\t)\r\n\t\t

\r\n";

if (_v_pkColName != null)

_v_content +=

"\t\t

keyProperty=\""

+

_v_pkColName

+

"\">\r\n\t\t\tSELECT LAST_INSERT_ID() AS

ID\r\n\t\t

\r\n";

_v_content +=

"\t

";

_v_fw.println(_v_content);

// === update record ===

if (_v_pkColName != null)

{

_v_content =

"\r\n\t

_v_xmlName

+

"\" parameterClass=\"" + _v_fullClsName +

"\">\r\n"

+

"\t\tUPDATE " + _v_xmlName

+

"\r\n\t\t

prepend=\"SET\">";

for (Fields

_v_fd : _v_fields) {

if

(!_v_pkColName.equals(_v_fd.getName()))

_v_content

+= "\r\n\t\t\t

+

_m_toAttributeString(_v_fd.getName())

+

"\" prepend=\",\">" + _v_fd.getName() + " = #"

+

_m_toAttributeString(_v_fd.getName())

+

"#

";

}

_v_content +=

"\r\n\t\t

\r\n\t\t

prepend=\"WHERE\">\r\n\t\t\t

property=\""

+

_v_pkColName

+

"\">"

+

_v_pkColName