表结构转为bean.docx

package?mon;????import?java.io.BufferedWriter;??import?java.io.File;??import?java.io.FileWriter;??import?java.io.IOException;??import?java.sql.Connection;??import?java.sql.DriverManager;??import?java.sql.PreparedStatement;??import?java.sql.ResultSet;??import?java.sql.ResultSetMetaData;??import?java.sql.SQLException;??import?java.util.Vector;????public?class?reflectBean?{??????private?Connection?connection;??????private?PreparedStatement?UserQuery;??????/*mysql?url的连接字符串*/??????private?static?String?url?=?jdbc:mysql://:3306/test1?useUnicode=truecharacterEncoding=utf-8useOldAliasMetadataBehavior=true;??????//账号??????private?static?String?user?=?root;??????//密码??????private?static?String?password?=?123;??????private?VectorString?vector?=?new?VectorString();??????//mysql?jdbc的java包驱动字符串??????private?String?driverClassName?=?com.mysql.jdbc.Driver;??????//数据库中的表名??????String?table?=?e_task_result;??????//数据库的列名称??????private?String[]?colnames;?//?列名数组??????//列名类型数组????????private?String[]?colTypes;??????public?reflectBean(){??????????try?{//驱动注册??????????????Class.forName(driverClassName);??????????????if?(connection?==?null?||?connection.isClosed())??????????????????//获得链接??????????????????connection?=?DriverManager.getConnection(url,?user,?password);??????????}?catch?(ClassNotFoundException?ex)?{??????????????????ex.printStackTrace();??????????????????System.out.println(Oh,not);??????????????}?catch?(SQLException?e)?{??????????????????e.printStackTrace();??????????????????System.out.println(Oh,not);??????????????}??????}????????????public?Connection?getConnection()?{??????????return?connection;??????}??????public?void?setConnection(Connection?connection)?{??????????this.connection?=?connection;??????}????????public?void?doAction(){??????????String?sql?=?select?*?from?+table;??????????try?{??????????????PreparedStatement?statement?=?connection.prepareStatement(sql);??????????????//获取数据库的元数据???????????????ResultSetMetaData?metadata?=?statement.getMetaData();??????????????