<%
String idno=request.getParameter("searchidno"); //获取提交的身份证号
String name=request.getParameter("searchname"); //获取提交的姓名
String origin=request.getParameter("searchorigin"); //获取提交的籍贯
if(idno==null){idno="";}
byte b[]=idno.getBytes("ISO-8859-1");
idno=new String(b);
if(name==null){name="";}
byte c[]=name.getBytes("ISO-8859-1");
name=new String(c);
if(origin==null){origin="";}
byte d[]=origin.getBytes("ISO-8859-1");
origin=new String(d);
String sql1="select * from basic where idno='"+idno+"'";
String sql2="select * from basic where name='%"+name+"%'";
String sql3="select * from basic where origin='"+origin+"'";
String sql4="select * from basic where idno='"+idno+"' and name='%"+name+"%'";
String sql5="select * from basic where idno='"+idno+"' and origin='"+origin+"'";
String sql6="select * from basic where name='%"+name+"%' and origin='"+origin+"'";
String sql7="select * from basic where idno='"+idno+"' and name='%"+name+"%' and origin='"+origin+"'";
CONTROLDB con=new CONTROLDB();
ResultSet rs;
if(idno=="" & name=="" & origin==""){response.sendRedirect("basicsearcherror.jsp");}
else if(idno=="" & name=="" & origin!=""){ResultSet rs=con.executeQuery(sql3);}
else if(idno=="" & name!="" & origin==""){ResultSet rs=con.executeQuery(sql2);}
else if(idno!="" & name=="" & origin==""){ResultSet rs=con.executeQuery(sql1);}
else if(idno!="" & name!="" & origin==""){ResultSet rs=con.executeQuery(sql4);}
else if(idno!="" & name=="" & origin!=""){ResultSet rs=con.executeQuery(sql5);}
else if(idno=="" & name!="" & origin!=""){ResultSet rs=con.executeQuery(sql6);}
else {
rs=con.executeQuery(sql7);
}
%><p align=right>AI's Studio</p>
<CENTER>
<P>添加新记录后数据库:</P>
<TABLE border="" >
<TBODY>
<TR>
<TH width="50">身份证号</TH>
<TH width="100">姓名</TH>
<TH width="120">籍贯</TH>
<TH width="50">性别</TH>
<TH width="50">年龄</TH>
</TR>
<% if(rs.next())response.sendRedirect("notfound.jsp");
else {
do{%>
<TR align="center">
<TD><%=rs.getString(1)%></TD>
<TD><%=rs.getString(2)%></TD>
<TD><%=rs.getString(3)%></TD>
<TD><%=rs.getString(4)%></TD>
<TD><%=rs.getString(5)%></TD>
</TR>
<% }while(rs.next());
}%>
</TBODY>
</TABLE>
</CENTER>
<p align=center><a href="basicinfo.jsp">返回</a></p>
<%
con.close();
%>编译通不过,总说rs没有初始化,如果在if中初始化rs问题就变成rs变量未定义,不明白该怎么弄了,请大家帮帮忙拉!
btw,如果可以帮我改进一下if/else那些复杂的逻辑就更好啦
String idno=request.getParameter("searchidno"); //获取提交的身份证号
String name=request.getParameter("searchname"); //获取提交的姓名
String origin=request.getParameter("searchorigin"); //获取提交的籍贯
if(idno==null){idno="";}
byte b[]=idno.getBytes("ISO-8859-1");
idno=new String(b);
if(name==null){name="";}
byte c[]=name.getBytes("ISO-8859-1");
name=new String(c);
if(origin==null){origin="";}
byte d[]=origin.getBytes("ISO-8859-1");
origin=new String(d);
String sql1="select * from basic where idno='"+idno+"'";
String sql2="select * from basic where name='%"+name+"%'";
String sql3="select * from basic where origin='"+origin+"'";
String sql4="select * from basic where idno='"+idno+"' and name='%"+name+"%'";
String sql5="select * from basic where idno='"+idno+"' and origin='"+origin+"'";
String sql6="select * from basic where name='%"+name+"%' and origin='"+origin+"'";
String sql7="select * from basic where idno='"+idno+"' and name='%"+name+"%' and origin='"+origin+"'";
CONTROLDB con=new CONTROLDB();
ResultSet rs;
if(idno=="" & name=="" & origin==""){response.sendRedirect("basicsearcherror.jsp");}
else if(idno=="" & name=="" & origin!=""){ResultSet rs=con.executeQuery(sql3);}
else if(idno=="" & name!="" & origin==""){ResultSet rs=con.executeQuery(sql2);}
else if(idno!="" & name=="" & origin==""){ResultSet rs=con.executeQuery(sql1);}
else if(idno!="" & name!="" & origin==""){ResultSet rs=con.executeQuery(sql4);}
else if(idno!="" & name=="" & origin!=""){ResultSet rs=con.executeQuery(sql5);}
else if(idno=="" & name!="" & origin!=""){ResultSet rs=con.executeQuery(sql6);}
else {
rs=con.executeQuery(sql7);
}
%><p align=right>AI's Studio</p>
<CENTER>
<P>添加新记录后数据库:</P>
<TABLE border="" >
<TBODY>
<TR>
<TH width="50">身份证号</TH>
<TH width="100">姓名</TH>
<TH width="120">籍贯</TH>
<TH width="50">性别</TH>
<TH width="50">年龄</TH>
</TR>
<% if(rs.next())response.sendRedirect("notfound.jsp");
else {
do{%>
<TR align="center">
<TD><%=rs.getString(1)%></TD>
<TD><%=rs.getString(2)%></TD>
<TD><%=rs.getString(3)%></TD>
<TD><%=rs.getString(4)%></TD>
<TD><%=rs.getString(5)%></TD>
</TR>
<% }while(rs.next());
}%>
</TBODY>
</TABLE>
</CENTER>
<p align=center><a href="basicinfo.jsp">返回</a></p>
<%
con.close();
%>编译通不过,总说rs没有初始化,如果在if中初始化rs问题就变成rs变量未定义,不明白该怎么弄了,请大家帮帮忙拉!
btw,如果可以帮我改进一下if/else那些复杂的逻辑就更好啦
解决方案 »
- 特无语的一个中文乱码转换,转换出现一个字乱码,其他字转换成功...特无语
- struts2 中的<c:select>问题
- 求个救 关于java String.equals
- ORACLE数据库问题?这是什么原因啊???
- JBulider2006中怎么在现在Struts工程中添加Validator框架进来啊?
- 几种语言的关系
- 急!!用if 进行条件判断,里面有sql语句 报错
- ----60分向高手紧急求救关于applet画图的问题----
- 帮帮忙,看看我这段代码那里错了
- MyEclipse浏览器和控制台都不报错??
- 我用的是tomcat5.5+eclipse3.21,应该用哪个sysdeo插件,还有就是sysdeo插件与myeclipse插件有冲突吗
- 页面关闭时老是弹出IE (应用程序错误)窗口.是内存不足引起的吗?
我是新手,看不太明白您说的,该怎样捕捉异常?为什么有异常呢?谢谢~~
//>>这里得初始化为null
if(idno=="" & name=="" & origin==""){response.sendRedirect("basicsearcherror.jsp");}
else if(idno=="" & name=="" & origin!="")
{ResultSet rs=con.executeQuery(sql3);}
//>>这里定义重复了,去掉类型声明ResultSet :{ rs=con.executeQuery(sql3);}
//>>是if(!rs.next())吧?
else {
do{%>
<TR align="center">