java初学者求大神

javagoing 2013-01-26 09:57:12

代码
<%@ page language="java" import="java.sql.*"
contentType="text/html; charset=gb2312" pageEncoding="gb2312"%>
<%@page import="java.lang.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Insert title here</title>
</head>
<body>

<%
java.sql.Connection conn;
java.lang.String strConn;
java.sql.PreparedStatement preparedStmt = null;
//语句对象
java.sql.ResultSet sqlRst = null; //结果集对象
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
conn = java.sql.DriverManager.getConnection(
"jdbc:oracle:thin:@10.128.9.239:1522:ADP630",
"javastudy", "javastudy");
//设置参数
String parm = request.getParameter("parm");
String parm1=new String(request.getParameter("parm1").getBytes("iso-8859-1"));
String parm2=new String(request.getParameter("parm2").getBytes("iso-8859-1"));

if (parm != null) {
preparedStmt = conn
.prepareStatement("select * from EMP t where EMPCODE like ?");
preparedStmt.setString(1, "%" + parm + "%");
sqlRst = preparedStmt.executeQuery();
} else if ((parm == null) && (parm1 != null)) {
preparedStmt = conn
.prepareStatement("select * from EMP t where EMPNAME like ?");
preparedStmt.setString(1,"%" + parm1 + "%");
sqlRst = preparedStmt.executeQuery();
} else if ((parm == null) && (parm1 == null) && (parm2 != null)) {
preparedStmt = conn
.prepareStatement("select * from EMP t where SEX like ?");
preparedStmt.setString(1, "%" + parm2 + "%");
sqlRst = preparedStmt.executeQuery();
} else
out.println("请输入：");
//执行SQL 语句
%>
<center>顾客信息表</center>
<table border="1" width="100％" cellspacing="0">
<tr>

<td align="center">编码</td>
<td align="center">姓名</td>
<td align="center">性别</td>
<td align="center">生日</td>
<td align="center">邮编</td>
<td align="center">地址</td>
<td align="center">电话</td>
<td align="center">工资</td>
</tr>
<%
while (sqlRst.next()) { //取得下一条记录
%>
<tr>

<td align="center"><%=sqlRst.getString("empcode")%></td>
<td align="center"><%=new String(sqlRst.getString("EMPNAME").getBytes(
"gb2312"))%></td>
<td align="center"><%=new String(sqlRst.getString("SEX").getBytes(
"gb2312"))%></td>
<td align="center"><%=new String(sqlRst.getString("BIRTHDAY").getBytes(
"iso-8859-1"))%></td>
<td align="center"><%=new String(sqlRst.getString("POSTCODE").getBytes(
"gb2312"))%></td>
<td align="center"><%=new String(sqlRst.getString("ADDRESS").getBytes(
"gb2312"))%></td>
<td align="center"><%=new String(sqlRst.getString("PHONE").getBytes(
"iso-8859-1"))%></td>
<td align="center"><%=new String(sqlRst.getString("WAGE").getBytes(
"iso-8859-1"))%></td>

</tr>
<%
}//out.println(parm1);
%>
</table>
<%
//关闭结果集对象
sqlRst.close();
//关闭语句对象
preparedStmt.close();
//关闭数据库连接
conn.close();
} catch (java.sql.SQLException e) {
out.println(e.toString());
}
%>

</body>
</html>

在连接数据库之后，执行查询时为什么只有输入parm时可以成功，在输入parm1和parm2查询时均不成功呢？？？求大神指教啊！！

...全文

90 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

Effort Rainbow 2013-01-27

打赏
举报

首先你的查询只能支持三个参数的单独查询，其中后面两个查询因为是中文传递，还需要注意编码转化是否正确问题。如果你说的是parm1 和parm2 联合查询，肯定是不行的，会进入else if ((parm == null) && (parm1 != null)) 这个条件。其次你代码条件判断可以改写下面代码


if (parm != null) {
} else if (parm1 != null) {
} else if (parm2 != null) {
} else {
}

javagoing 2013-01-27

打赏
举报

比如查询parm时输入001出来的数据是对的，可是在输入parm1 或者parm2时所有的数据都会显示出来啊

javagoing 2013-01-27

打赏
举报

<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="gb2312"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>列表</title> </head> <body> <form action="result1.jsp" method="post"> <label>编号：</label> <input name="parm" value="null"> <br> <label>名字：</label> <input name="parm1" value="null"> <br> <label>性别：</label> <input name="parm2" value="null"> <br> <label>出生日期：</label> <input name="parm3" value=""> <br> <label>邮政编码：</label> <input name="parm4" value=""> <br> <label>家庭地址：</label> <input name="parm5" value=""> <br> <label>电话：</label> <input name="parm6" value=""> <br> <label>工资：</label> <input name="parm7" value=""> <br> <input type="submit"name="Submit2" value="提交"> <input type="reset" name="Submit"value="清空"> </form> </body> </html> 就是在这个界面中进行查询啊？而且查询的时候只是一个一个来的啊