本文整理汇总了Java中org.apache.commons.dbutils.handlers.MapListHandler类的典型用法代码示例。如果您正苦于以下问题:Java MapListHandler类的具体用法?Java MapListHandler怎么用?Java MapListHandler使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
MapListHandler类属于org.apache.commons.dbutils.handlers包,在下文中一共展示了MapListHandler类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的Java代码示例。
示例1: main
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
public static void main(String[] args) {
Connection conn = null;
final String url = "jdbc:h2:./target/test;AUTO_SERVER=TRUE";
final String driver = "org.h2.Driver";
final String usr = "sa";
final String pwd = "";
try {
DbUtils.loadDriver(driver);
conn = DriverManager.getConnection(url, usr, pwd);
QueryRunner query = new QueryRunner();
List<Map<String, Object>> mapList = (List<Map<String, Object>>) query
.query(conn, "select * from user", new MapListHandler());
for (int i = 0; i < mapList.size(); i++) {
Map<String, Object> map = (Map<String, Object>) mapList.get(i);
System.out.println("------> " + map.get("userId") + "\t"
+ map.get("firstName") + "\t" + map.get("emailId"));
}
} catch (SQLException se) {
se.printStackTrace();
} finally {
DbUtils.closeQuietly(conn);
}
}
开发者ID:v5developer,项目名称:maven-framework-project,代码行数:26,代码来源:DbUtilsMapListHandler.java
示例2: main
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
public static void main(String[] args) throws SQLException {
final String url = "jdbc:h2:./target/test;AUTO_SERVER=TRUE";
final String driver = "org.h2.Driver";
final String usr = "sa";
final String pwd = "";
QueryRunner run = new QueryRunner();
DbUtils.loadDriver(driver);
Connection conn = DriverManager.getConnection(url, usr, pwd);
// -----------------------------------------------------------------------------------
try {
List<Map<String, Object>> maps = run.query(conn,
"SELECT * FROM employee", new MapListHandler());
System.out.println(maps);
} finally {
DbUtils.close(conn);
}
}
开发者ID:v5developer,项目名称:maven-framework-project,代码行数:23,代码来源:MapListHandlerExample.java
示例3: getPersistedEntries
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Override
public ImmutableCollection<ChecksumEntry> getPersistedEntries(final PhysicalSchema physicalSchema) {
return sqlExecutor.executeWithinContext(physicalSchema, new ThrowingFunction<Connection, ImmutableCollection<ChecksumEntry>>() {
@Override
public ImmutableCollection<ChecksumEntry> safeValueOf(Connection conn) throws Exception {
return ListAdapter.adapt(jdbc.query(conn, "SELECT * FROM " + platform.getSchemaPrefix(physicalSchema) + checksumTableName, new MapListHandler())).collect(new Function<Map<String, Object>, ChecksumEntry>() {
@Override
public ChecksumEntry valueOf(Map<String, Object> result) {
return ChecksumEntry.createFromPersistence(
physicalSchema,
(String) result.get(objectTypeColumnName),
(String) result.get(objectName1ColumnName),
blankToNull((String) result.get(objectName2ColumnName)),
(String) result.get(checksumColumnName)
);
}
}).toImmutable();
}
});
}
开发者ID:goldmansachs,项目名称:obevo,代码行数:21,代码来源:SameSchemaDbChecksumDao.java
示例4: searchRules
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Override
public ImmutableCollection<DaRule> searchRules(final DaSchema schema, Connection conn) throws SQLException {
QueryRunner query = new QueryRunner(); // using queryRunner so that we can reuse the connection
// Do not use ANSI JOIN as it does not work in Sybase 11.x - the SQL below works across all versions
String sql = "SELECT rul.name as RULE_NAME\n" +
"FROM " + schema.getName() + "..sysobjects rul\n" +
" , sys.schemas sch\n" +
"WHERE rul.type = 'R'\n" +
" and rul.uid = sch.schema_id and sch.name = '" + schema.getSubschemaName() + "' " +
"and not exists (\n" +
"\t-- Ensure that the entry is not attached to a table; otherwise, it is a regular table constraint, and will already be dropped when the table is dropped\n" +
"\tselect 1 from " + schema.getName() + "..sysconstraints c\n" +
"\twhere c.constid = rul.id\n" +
")\n";
ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(query.query(conn, sql, new MapListHandler())).toImmutable();
return maps.collect(new Function<Map<String, Object>, DaRule>() {
@Override
public DaRule valueOf(Map<String, Object> map) {
return new DaRuleImpl((String) map.get("RULE_NAME"), schema);
}
});
}
开发者ID:goldmansachs,项目名称:obevo,代码行数:25,代码来源:MsSqlMetadataDialect.java
示例5: searchUserTypes
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Override
public ImmutableCollection<DaUserType> searchUserTypes(final DaSchema schema, Connection conn) throws SQLException {
QueryRunner query = new QueryRunner();
String sql = "SELECT DOMAIN_NAME as USER_TYPE_NAME " +
"FROM INFORMATION_SCHEMA.DOMAINS " +
"WHERE DOMAIN_CATALOG = '" + schema.getName() + "' " +
"AND DOMAIN_SCHEMA = '" + schema.getSubschemaName() + "'";
ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(query.query(conn, sql, new MapListHandler())).toImmutable();
return maps.collect(new Function<Map<String, Object>, DaUserType>() {
@Override
public DaUserType valueOf(Map<String, Object> map) {
return new DaUserTypeImpl((String) map.get("USER_TYPE_NAME"), schema);
}
});
}
开发者ID:goldmansachs,项目名称:obevo,代码行数:18,代码来源:MsSqlMetadataDialect.java
示例6: searchUserTypes
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Override
public ImmutableCollection<DaUserType> searchUserTypes(final DaSchema schema, Connection conn) throws SQLException {
QueryRunner query = new QueryRunner();
ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(query.query(conn,
"select dom.DOMAIN_NAME AS USER_TYPE_NAME\n" +
"from INFORMATION_SCHEMA.DOMAINS dom\n" +
"WHERE dom.DOMAIN_SCHEMA = ucase('" + schema.getName() + "')\n",
new MapListHandler()
)).toImmutable();
return maps.collect(new Function<Map<String, Object>, DaUserType>() {
@Override
public DaUserType valueOf(Map<String, Object> map) {
return new DaUserTypeImpl((String) map.get("USER_TYPE_NAME"), schema);
}
});
}
开发者ID:goldmansachs,项目名称:obevo,代码行数:19,代码来源:HsqlMetadataDialect.java
示例7: searchRules
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Override
public ImmutableCollection<DaRule> searchRules(final DaSchema schema, Connection conn) throws SQLException {
QueryRunner query = new QueryRunner(); // using queryRunner so that we can reuse the connection
// Do not use ANSI JOIN as it does not work in Sybase 11.x - the SQL below works across all versions
ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(query.query(conn,
"SELECT rul.name as RULE_NAME\n" +
"FROM " + schema.getName() + "..sysobjects rul\n" +
" , " + schema.getName() + "..sysusers sch\n" +
"WHERE rul.type = 'R'\n" +
" and rul.uid = sch.uid and sch.name = '" + schema.getSubschemaName() + "' " +
"and not exists (\n" +
"\t-- Ensure that the entry is not attached to a table; otherwise, it is a regular table constraint, and will already be dropped when the table is dropped\n" +
"\tselect 1 from " + schema.getName() + "..sysconstraints c\n" +
"\twhere c.constrid = rul.id\n" +
")\n",
new MapListHandler()
)).toImmutable();
return maps.collect(new Function<Map<String, Object>, DaRule>() {
@Override
public DaRule valueOf(Map<String, Object> map) {
return new DaRuleImpl((String) map.get("RULE_NAME"), schema);
}
});
}
开发者ID:goldmansachs,项目名称:obevo,代码行数:27,代码来源:SybaseAseMetadataDialect.java
示例8: searchUserTypes
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Override
public ImmutableCollection<DaUserType> searchUserTypes(final DaSchema schema, Connection conn) throws SQLException {
QueryRunner query = new QueryRunner();
ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(query.query(conn,
"SELECT s1.name as USER_TYPE_NAME\n" +
"FROM " + schema.getName() + "..systypes s1\n" +
" , " + schema.getName() + "..sysusers sch\n" +
"WHERE s1.usertype>100 " +
"AND s1.uid = sch.uid and sch.name = '" + schema.getSubschemaName() + "' "
, new MapListHandler()
)).toImmutable();
return maps.collect(new Function<Map<String, Object>, DaUserType>() {
@Override
public DaUserType valueOf(Map<String, Object> map) {
return new DaUserTypeImpl((String) map.get("USER_TYPE_NAME"), schema);
}
});
}
开发者ID:goldmansachs,项目名称:obevo,代码行数:21,代码来源:SybaseAseMetadataDialect.java
示例9: createEntityNet
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Override
public <T> T createEntityNet(SqlBoxContext ctx, boolean loadKeyOnly, Object... configObjects) {
if (configObjects == null || configObjects.length == 0)
throw new TinyNetException("LoadNet() does not support empty netConfigs parameter");
TableModel[] models = EntityNetSqlExplainer.objectConfigsToModels(ctx, configObjects);
EntityNet net = new TinyNet();
String starOrSharp = loadKeyOnly ? ".##" : ".**";
for (TableModel t : models) {
List<Map<String, Object>> mapList = null;
String alias = t.getAlias();
if (StrUtils.isEmpty(alias))
alias = t.getTableName();
try {
mapList = ctx.nQuery(new MapListHandler(SqlBoxContext.netProcessor(t)),
"select " + alias + starOrSharp + " from " + t.getTableName() + " as " + alias);
} finally {
EntityNetSqlExplainer.removeBindedTableModel(mapList);
}
net.addMapList(mapList, t);
}
return (T) net;
}
开发者ID:drinkjava2,项目名称:jSqlBox,代码行数:23,代码来源:TinyEntityNetBuilder.java
示例10: testJoinFields
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Test
public void testJoinFields() {
System.out.println("==============testJoinFields================ ");
new User().put("id", "u1").put("userName", "user1").insert();
new User().put("id", "u2").put("userName", "user2").insert();
TinyNet net = ctx.netLoadSketch(User.class);
Assert.assertEquals(2, net.size());
List<User> users = net.getAllEntityList(User.class);
Assert.assertNull(users.get(0).getUserName());
User u = new User();
u.tableModel().setAlias("u");
List<Map<String, Object>> listMap = ctx.nQuery(new MapListHandler(),
netConfig(u) + "select u.id as u_id, u.userName as u_userName from usertb as u");
ctx.netJoinList(net, listMap);// not userName be joined
Assert.assertEquals(2, net.size());
users = net.getAllEntityList(User.class);
Assert.assertNotNull(users.get(0).getUserName());
}
开发者ID:drinkjava2,项目名称:jSqlBox,代码行数:21,代码来源:TinyNetTest.java
示例11: testJoinParents
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Test
public void testJoinParents() {
System.out.println("==============testJoinParents================ ");
new User().put("id", "u1").put("userName", "user1").insert();
new User().put("id", "u2").put("userName", "user2").insert();
new Email().putFields("id", "emailName", "userId");
new Email().putValues("e1", "email1", "u1").insert();
new Email().putValues("e2", "email2", "u1").insert();
List<Map<String, Object>> listMap = ctx.nQuery(new MapListHandler(),
netConfig(new Email().alias("e")) + "select e.id as e_id from emailtb e");
TinyNet net = (TinyNet) ctx.netCreate(listMap);
Assert.assertEquals(2, net.size());
Node emailNode = net.getOneNode(Email.class, "e1");
Assert.assertNull(emailNode.getParentRelations());// e1 have no userId
// field
List<Map<String, Object>> listMap2 = ctx.nQuery(new MapListHandler(),
netConfig(Email.class) + "select e.** from emailtb e");
ctx.netJoinList(net, listMap2);
Assert.assertEquals(2, net.size());
emailNode = net.getOneNode(Email.class, "e1");
Assert.assertNotNull(emailNode.getParentRelations());
}
开发者ID:drinkjava2,项目名称:jSqlBox,代码行数:25,代码来源:TinyNetTest.java
示例12: testManualLoadAndJoin
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Test
public void testManualLoadAndJoin() {
insertDemoData();
List<Map<String, Object>> mapList1 = ctx.nQuery(new MapListHandler(netProcessor(User.class, Address.class)),
"select u.**, a.** from usertb u, addresstb a where a.userId=u.id");
TinyNet net = ctx.netCreate(mapList1);
Assert.assertEquals(10, net.size());
List<Map<String, Object>> mapList2 = ctx.nQuery(new MapListHandler(),
netConfig(Email.class) + "select e.** from emailtb as e");
ctx.netJoinList(net, mapList2);
Assert.assertEquals(15, net.size());
List<Map<String, Object>> mapList3 = ctx.nQuery(
new MapListHandler(netProcessor(Role.class, UserRole.class, RolePrivilege.class, Privilege.class)),
"select r.**, ur.**, rp.**, p.** from roletb r, userroletb ur, RolePrivilegetb rp, privilegetb p");
Assert.assertEquals(900, mapList3.size());
ctx.netJoinList(net, mapList3);
Assert.assertEquals(37, net.size());
}
开发者ID:drinkjava2,项目名称:jSqlBox,代码行数:21,代码来源:TinyNetDemo.java
示例13: selectBySql
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Override
public <T> List<T> selectBySql(String sql, Object[] params, Class<T> modelType) {
QueryRunner queryRunner = new QueryRunner();
Connection conn = getDbConnectionFactory().getConnection();
printSQL(sql, params);
try {
if (Model.class.isAssignableFrom(modelType)) {
return (List<T>) queryRunner.query(conn, sql, new AnnotationBeanListHandler(modelType), params);
} else if (Map.class.isAssignableFrom(modelType)) {
return (List<T>) queryRunner.query(conn, sql, new MapListHandler(), params);
} else {
throw new RuntimeException("未知的映射类型:" + modelType);
}
} catch (SQLException e) {
throw new RuntimeException(e);
} finally {
getDbConnectionFactory().releaseConnection(conn);
}
}
开发者ID:treeleafj,项目名称:treeleaf,代码行数:22,代码来源:DefaultDBOperator.java
示例14: findPage
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
/**
* //TODO 分页查询List<Map>
*
* @param sql
* @param page
* @param pageSize
* @param params
* @return
*/
public static List<Map<String, Object>> findPage(String sql, Integer page, Integer pageSize, Object... params) {
List<Map<String, Object>> fieldMapList;
try {
sql = sql + " LIMIT ?,?";
List<Object> list = null;
if (!CollectionUtil.isEmpty(params)) {
list = CollectionUtil.newArrayList(params.length + 2);
list.addAll(Arrays.asList(params));
} else{
list = CollectionUtil.newArrayList(2);
}
list.add(page);
list.add(pageSize);
params = list.toArray();
fieldMapList = getQueryRunner().query(sql, new MapListHandler(), params);
} catch (SQLException e) {
logger.error("queryMapListPage.map数据分页查询错误:" + sql, e);
throw new QueryException(e);
}
logger.debug("sql:" + sql + "\n params:" + Arrays.toString(params));
return fieldMapList;
}
开发者ID:mattxia,项目名称:unique-web,代码行数:32,代码来源:DB.java
示例15: queryMapList
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
/**
* 查询对应的数据,返回多条记录(列名 => 数据)
*/
public List<Map<String, Object>> queryMapList(String sql, Object... params) {
List<Map<String, Object>> fieldMapList;
try {
fieldMapList = queryRunner.query(sql, new MapListHandler(), params);
} catch (SQLException e) {
logger.error("查询出错!");
throw new RuntimeException(e);
}
printSQL(sql);
return fieldMapList;
}
开发者ID:smxc,项目名称:garlicts,代码行数:15,代码来源:JdbcTemplate.java
示例16: resultSetToJson
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
public static String resultSetToJson(Connection connection, String query) {
List<Map<String, Object>> listOfMaps = null;
try {
QueryRunner queryRunner = new QueryRunner();
listOfMaps = queryRunner.query(connection, query, new MapListHandler());
} catch (SQLException se) {
throw new RuntimeException("Couldn't query the database.", se);
} finally {
DbUtils.closeQuietly(connection);
}
return new Gson().toJson(listOfMaps);
}
开发者ID:deivisvieira,项目名称:PosJava,代码行数:13,代码来源:DAOCotacao.java
示例17: executeQuery
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
/**
* 执行查询语句
*
* @param sql
* @param params
* @return
*/
public static List<Map<String, Object>> executeQuery(String sql,
Object... params) {
List<Map<String, Object>> result;
Connection conn = getConnection();
try {
result = QUERY_RUNNER
.query(conn, sql, new MapListHandler(), params);
} catch (SQLException e) {
LOGGER.error("execute query failure", e);
throw new RuntimeException(e);
}
return result;
}
开发者ID:longjiazuo,项目名称:light-framework,代码行数:21,代码来源:DataBaseHelper.java
示例18: searchExtraRoutines
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Override
public ImmutableCollection<DaRoutine> searchExtraRoutines(final DaSchema schema, String procedureName, Connection conn) throws SQLException {
String nameClause = procedureName != null ? " and ROUTINE_NAME = '" + procedureName + "'\n" : " ";
String query = "SELECT" +
" ROUTINE_CATALOG," +
" ROUTINE_SCHEMA," +
" ROUTINE_NAME," +
" SPECIFIC_NAME," +
" ROUTINE_TYPE," +
" OBJECT_DEFINITION(OBJECT_ID(ROUTINE_CATALOG + '.' + ROUTINE_SCHEMA + '.' + ROUTINE_NAME)) AS ROUTINE_DEFINITION" +
" FROM INFORMATION_SCHEMA.ROUTINES" +
" WHERE ROUTINE_CATALOG = '" + schema.getName() + "'" +
" AND ROUTINE_SCHEMA = '" + schema.getSubschemaName() + "'" +
nameClause;
QueryRunner qr = new QueryRunner(); // using queryRunner so that we can reuse the connection
ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(qr.query(conn, query, new MapListHandler())).toImmutable();
return maps.collect(new Function<Map<String, Object>, DaRoutine>() {
@Override
public DaRoutine valueOf(Map<String, Object> object) {
DaRoutineType routineType = DaRoutineType.valueOf(((String) object.get("ROUTINE_TYPE")).toLowerCase());
return new DaRoutinePojoImpl(
(String) object.get("ROUTINE_NAME"),
schema,
routineType,
(String) object.get("SPECIFIC_NAME"),
(String) object.get("ROUTINE_DEFINITION")
);
}
});
}
开发者ID:goldmansachs,项目名称:obevo,代码行数:33,代码来源:MsSqlMetadataDialect.java
示例19: searchExtraConstraintIndices
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
@Override
public ImmutableCollection<ExtraIndexInfo> searchExtraConstraintIndices(DaSchema schema, String tableName, Connection conn) throws SQLException {
QueryRunner query = new QueryRunner(); // using queryRunner so that we can reuse the connection
// Do not use ANSI JOIN as it does not work in Sybase 11.x - the SQL below works across all versions
String tableClause = tableName == null ? "" : " AND tab.name = '" + tableName + "'";
ImmutableList<Map<String, Object>> maps = ListAdapter.adapt(query.query(conn,
"select tab.name TABLE_NAME, ind.name INDEX_NAME, status2 & 8 IS_CONSTRAINT, status2 & 512 IS_CLUSTERED " +
"from " + schema.getName() + "..sysindexes ind" +
", " + schema.getName() + "..sysobjects tab " +
", " + schema.getName() + "..sysusers sch " +
"where ind.id = tab.id " +
"and tab.uid = sch.uid and sch.name = '" + schema.getSubschemaName() + "'\n" +
tableClause,
new MapListHandler()
)).toImmutable();
return maps.collect(new Function<Map<String, Object>, ExtraIndexInfo>() {
@Override
public ExtraIndexInfo valueOf(Map<String, Object> map) {
return new ExtraIndexInfo(
(String) map.get("TABLE_NAME"),
(String) map.get("INDEX_NAME"),
(Integer) map.get("IS_CONSTRAINT") != 0,
(Integer) map.get("IS_CLUSTERED") != 0
);
}
});
}
开发者ID:goldmansachs,项目名称:obevo,代码行数:30,代码来源:SybaseAseMetadataDialect.java
示例20: resultSetToJson
import org.apache.commons.dbutils.handlers.MapListHandler; //导入依赖的package包/类
public static String resultSetToJson(String query) {
Connection connection = null;
List<Map<String, Object>> listOfMaps = null;
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306?"
+ "useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries"
+ "=true", "root", "123456");
} catch (Exception ex) {
System.err.println("***exception trying to connect***");
ex.printStackTrace();
}
try {
QueryRunner queryRunner = new QueryRunner();
listOfMaps = queryRunner.query(connection, query, new MapListHandler());
} catch (SQLException se) {
throw new RuntimeException("Couldn't query the database.", se);
} finally {
DbUtils.closeQuietly(connection);
}
try {
return new ObjectMapper().writeValueAsString(listOfMaps);
} catch (JsonProcessingException e) {
System.out.println(e.toString());
}
return null;
}
开发者ID:warlock-china,项目名称:wisp,代码行数:33,代码来源:JDBCExample.java
注:本文中的org.apache.commons.dbutils.handlers.MapListHandler类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论