SQLMAP file gadgets for generating Ibatis in Oralce

If the complete code or suggestion is required to send to zhobekui@eyou.com. Metadata class, can achieve corresponding data table information under Oralce, and generate file SQLMAP files * Currently generated IBATIS from database tables to iBATIS SQLMAP types Main SELECT, INSERT, UPDATE * Because of projects, just temporarily, No development of ResultMap and ParameterMap generation * Practice to develop this tool, graphize it, first listen to you, I hope to communicate with you. * Call the program, just call the getMetadata () method * Database configuration cn / card / mofit / demap-config.xml, * Modify the JDBC.Properties database configuration in the current directory It is possible to use its main class implementation method: package cn.com.mofit.util.jdbc; import java.io.File; import java.io.RIXCEPTION; import java.ioException; import java.io.reader; import java .sql.Connection; import java.sql.DatabaseMetaData; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.sql.Types; import java. util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Vector; import org.springframework.dao.DataAccessException; import org.springframework.orm.ibatis.SqlMapClientTemplate; import cn.com. mofit.util.spring.orm.ibatis.SqlMapDaoSupportPlus; import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.engine.builder.xml.XmlSqlMapClientBuilder; / *** * @author Zhou Weikui * 2004-10-15 * @Email: zhobe @DepRecated metadata class, can achieve the corresponding data table information under Oralce, and generate file SQLMAP files * At present, IBATIS can be generated from the database table to the ibatis Sqlmap type. There is mainly SELECT, INSERT, UPDATE * Because the project is too urgent, it is only temporary, there is no development of ResultMap and ParameterMap generation * Practice plan to develop this tool, and graphically, first Listen to you, I hope to communicate with you.

* Call the program, just call the getMetadata () method * Database configuration cn / card / mofit / demap-config.xml, * Modify the JDBC.Properties database configuration in the current directory You can use the path name generated by * / public class rsmetataracle {/ ** filepath sqlmap file, is an absolute path * / private string filepath = "c: /"; / ** maptablename to map the table name * / private string maptablename = "BK_BILL"; // System.getProperty ( "user.dir") "/ config / sqlmap /"; private static SqlMapClientTemplate sqlTemp; static {try {SqlMapDaoSupportPlus sqlsu = new SqlMapDaoSupportPlus (); String resource = "cn / com /mofit/demo/system/dao/maps/sqlMap-config.xml";Reader read; read = Resources.getResourceAsReader (resource); XmlSqlMapClientBuilder xmlBuilder = new XmlSqlMapClientBuilder (); SqlMapClient sqlMap = xmlBuilder.buildSqlMap (read); sqlsu. setSqlMapClient (sqlMap); sqlsu.afterPropertiesSet (); sqlTemp = sqlsu.getSqlMapClientTemplate ();} catch (IOException e1) {e1.printStackTrace ();} catch (Exception e) {e.printStackTrace ();}} private static SqlMapClientTemplate GetsqlmapTempinstance () {return sqltemp;} public void getmetata () T hrows DataAccessException {try {//DaoCommon.startTransaction();SqlMapClientTemplate sqlTemp = RsMetaDataOracle.getSqlMapTempInstance (); // SqlMap sqlMap = DaoCommon.getSqlMap (this); Connection conn = sqlTemp.getDataSource () getConnection ();. Statement stmt = Conn.createStatement (); list list = gettablenames (); for (item t = list.iterator (); it.hasnext () {string element = (String) iter.next (); resultset = stmt.executeQuery (" Select * from " Element); ResultSetMetadata RSMD = rs.getMetadata (); int numberofcolumns = rsmd.getColumnCount ();

IF (Element.startSwith ())) {file file = new file (filepath); if (! file.exists ()) {file.mkdir ();} file = new file (FilePath Element.tolowerCase () ".xml"); string XML = " / n"; XML = " / n"; XML = (" / n"); XML = GetXML (RSMD, Numberofcolumns, ELEMENT); XML = "/ n "; FileWriter Writer = New FileWriter (File); Writer.write (XML); Writer.clush (); Writer.close ();}}} catch DataAccessException e) {e.printStackTrace ();} catch (SQLException e) {e.printStackTrace ();} catch (IOException e) {e.printStackTrace ();}} private String getXml (ResultSetMetaData rsmd, int numberOfColumns, String tableName ) throws sqlexception {string result = ""; result = (CreateFindsql (RSMD, NumberOfColumns, Tablename); Result = (CreateInsertsql (RSMD, Numberofcolumns, Tablena me)); result = (createUpdateSql (rsmd, numberOfColumns, tableName)); return result;} private String createfindSql (ResultSetMetaData rsmd, int numberOfColumns, String tableName) throws SQLException {String result;! result = "<- == =================================================== / n mapped-statement Find / n =

===================================================== -> "; Result = ("/ n "); result = ("/ n SELECT $ listfield $ from " Tablename " / N "); Result = CreatewhereSQL (RSMD, NumberOfColumns," and ", 1); Result =" / n "; result = "/ n / n / n / n"; return result;} private String createColumnsString (ResultSetMetaData rsmd) throws SQLException {String result = ""; int numberOfColumns = rsmd.getColumnCount (); for (int i = 1; i <= numberofcolumns; i ) {string colname = rsmd.getColumnname; string name = rsmd.getColumnPENAME; Result = ((i == 1)? "/ n": "/ n") colname ",");} return result.substring (1, result.length () - 1);} private String createWheremapSql (ResultSetMetaData rsmd, int numberOfColumns) throws SQLException {String result = ""; for (int i = 1; I <= numberofcolumns; i ) {string colname = rsmd.getColumnname; string name = rsmd.getColumnPename; Result = (((i == 1)? "/ n" : "/ N and") colName "= #" colName "#");} return result;} private String createInsertSql (ResultSetMetaData rsmd, int numberOfColumns, String tableName) throws SQLException {String result =

" "; Result = (" / n "); Result = CREATEWHERESQL (RSMD , NumberOfColumns, ", 3) ") "; Result =" / n "; result =" / n / n / n / n "; returnrate;} private string CreateUpdateSQL (ResultSetMetadata RSMD, int Numberofcolumn, string Tablename) throws sqlexception {string results = " "; Result = (" / n <

Update ID = / "update" Tablename.tolowercase () "DAO /" parameterclass = / "java.util.hashmap /"> "); Result = (" / n Update " Tablename " / n " CreatewhereSQL (RSMD, NumberOfColumns,", 4) "/ n / n "); Result = CREATEWHERESQL (RSMD , NumberofColumns, "and", 1); Result = "/ n "; Result = "/ n / n / n / n"; returnrate;} prince createwhereSQL (ResultSetMetadata RSMD , int numberOfColumns, String prepend, int detail) throws SQLException {String result = ""; for (int i = 1; i <= numberOfColumns; i ) {String colName = rsmd.getColumnName; result = ( "/ n "); result = ("/ n "); switch (detail) {case 1: // WHERE statement result = (" / n " colname " = # " colname.tolowercase () " # " ); Break; Case 2: // INSERT statement Result = ("/ n" colname.tolowercase ()); break; case 3: // insert prepared RE SULT = ("/ n #" colname.tolowercase () "#"); break; case 4: // Modified SET statement Result = ("/ n" colname "= #" colname.tolowercase () (Types.varchar == rsmd.getColumnType? ": Varchar": ") " # "

Break; default: Break;} result = ("/ n ";} return result;} private void gettype (ResultsetMetadata RSMD, INT I, Hashmap Colmap) throws SQLException {switch (rsmd.getColumnType) {case Types.VARCHAR: colMap.put ( "COLUMNTYPE", rsmd.getColumnTypeName "(" rsmd.getPrecision ")"); break; case 2: colMap.put ( " COLUMNTYPE ", rsmd.getColumnTypeName " ( " rsmd.getPrecision ", " rsmd.getScale ") "); break; default: colMap.put (" COLUMNTYPE ", rsmd.getColumnTypeName); break;}} private List getTableNames () throws DataAccessException {List result = new Vector (); // sqlMap sqlMap = DaoCommon.getSqlMap (this); Connection conn;.. try {conn = getSqlMapTempInstance () getDataSource () getConnection (); DatabaseMetaData dbmd = conn .getMetadata (); ResultSet RS = dbmd.gettabletypes (); string [] type = {"table"}; = dbmd.gettables (null, dbmd.getusername (), "%", types); while (RS. Next ()) {result.add (rs.getstring ("table_name"));}}} catch (sqlexception e) {E.PrintStackTrace ();} Retur n result;} public String getFilePath () {return filePath;} public void setFilePath (String filePath) {this.filePath = filePath;} public String getMapTablename () {return mapTablename;} public void setMapTablename (String mapTablename) {this.mapTablename = maptablename;}} SQL-Config file configuration is: In the (SqlmapConfig) /> (SqlmapConfigjdbc.properties file configuration: jdbc.driverclassname = Oracle.jdbc.driver. OracleDriverjdbc.url = jdbc: Oracle: Thinip: 1521: Sidjdbc.userName = jdbc.password =

转载请注明原文地址:https://www.9cbs.com/read-105920.html

---

9cbs

New Post(0)