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: