Jsp+Oracle实现多条件动态组合统计查询(框架也一样)

chinalzd · 发表于 2013-2-6 11:10:24

Jsp+Oracle实现多条件动态组合查询(框架也一样)

原文地址：http://www.lizhongda.net/info/news_detail.asp?newsid=541

更多内容请大家访问我的网站[上述链接]，谢谢大家的支持。

<html>

<head>

</head>

<%

request.setCharacterEncoding("GBK");

%>

<%

Connection con = null;

Statement sta = null;

ResultSet rs = null;

%>

<%

String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";

DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

con = DriverManager.getConnection(url, "用户名", "密码");

%>

<%

String regionname = request.getParameter("regionname");

regionname = new String(regionname.getBytes("iso-8859-1"), "GB2312");

String commiteuserid = request.getParameter("commiteuserid");

String sdate = request.getParameter("sdate");

String edate = request.getParameter("edate");

if (regionname != null)

regionname = request.getParameter("regionname").trim();

%>

<%

String sql0 = " 1 = 1 ";

String sql1 = "";

String sql2 = "";

String sql3 = "";

int i = 1;

int j = 0;

if (regionname != null && !regionname.equals("")) {

sql1 = " and regionname = '" + regionname + "' ";

//System.out.println("sql1 = "+sql1);

}

if (commiteuserid != null && !commiteuserid.equals("")) {

sql2 = " and commiteuserid ='" + commiteuserid + "' ";

//System.out.println("sql2 = "+sql2);

}

if (sdate != null && edate != null && !sdate.equals("")

&& !edate.equals("")) {

sql3 = " and commitedate between to_date ('" + sdate

+ "','yyyy-mm-dd') and to_date('" + edate

+ "','yyyy-mm-dd')";

//System.out.println("sql3 = "+sql3);

}

String sql = "select regionname,commiteuserid,count(*) as counts from 表名 where "

+ sql0

+ sql1

+ sql2

+ sql3

+ " group by regionname,commiteuserid order by regionname";

try {

sta = con.createStatement();

rs = sta.executeQuery(sql);

%>

<body>

<tr>

<td>

按地区查看：

请选择地级市

</option>

济南市

</option>

青岛市

</option>

济宁市

</option>

潍坊市

</option>

菏泽市

</option>

枣庄市

</option>

威海市

</option>

日照市

</option>

烟台市

</option>

泰安市

</option>

莱芜市

		自动登录	找回密码
密码			立即注册