JDBC Query For List

上一篇 / 下一篇 2012-02-17 16:16:36 / 个人分类：web design

可以使用 dbutils.jar 来实现。(jar 包见附件)

JSP Page:

<%@ page import = "java.util.*" %>

<%@ page import = "java.sql.*" %>

<%@ page import = "org.apache.commons.dbutils.QueryRunner" %>

<%@ page import = "org.apache.commons.dbutils.handlers.MapListHandler" %>

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

Connection dbConn = DriverManager.getConnection("jdbc:sqlserver://IP:1433;DatabaseName=YourDBName", "sa", "password");

QueryRunner qrun = new QueryRunner();

List list = (List)qrun.query(dbConn, "select * from testconfig where configid>504", new MapListHandler());

System.out.println("list:"+list);

TAG: