项目地址:
gitHub地址
#使用方法:
- 配置resources/generactor.properties文件
- 在com.dgy.Main中运行main方法
#主要的方法
取得mysql数据库的表的字段信息
/**
* 查询一个表的所有列信息
* @param tablename
* @return
*/
public static Map<String, String> getCloumInfomation(String tablename){
Map<String, String> cloumInfoMap = new HashMap<String, String>();
PreparedStatement preparedStatement = null;
String sql = "select * from "+tablename;
try {
preparedStatement = connection.prepareStatement(sql);
ResultSetMetaData resultSetMetaData = preparedStatement.getMetaData();
for (int i = 0; i < resultSetMetaData.getColumnCount(); i++){
cloumInfoMap.put(resultSetMetaData.getColumnName(i + 1), resultSetMetaData.getColumnTypeName(i + 1));
}
} catch (SQLException e) {
e.printStackTrace();
}
return cloumInfoMap;
}
获取数据库的表名
/**
* 查询所有的表名
* @return
*/
public static List<String> getAllTablesName(){
Connection connection = DBConnectionInfo.getConnection();
List<String> tablesName = new LinkedList<String>();
String sql = "show tables";
try {
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()){
tablesName.add(statement.getResultSet().getString(1));
}
} catch (SQLException e) {
e.printStackTrace();
}
return tablesName;
}