帮忙看一看这段代码,为什么不能够执行查询
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN ">
<%@ page contentType= "text/html;charset=UTF-8 " %>
<%@ page import= "java.sql.* " %>
<html>
<head>
<title> select标签测试 </title>
</head>
<body>
<form name= "form " action= "select.jsp " method= "get ">
<select name= "n1 " size= "1 " onchange= "optt.value=this.options[this.selectedIndex].name ">
<option value=5> </option>
<option name= "id " value=1> 记录编号 </option>
<option name= "name " value=2> 姓名 </option>
<option name= "age " value=3> 年龄 </option>
<option name= "sex " value=4> 性别 </option>
</select>
<input type= "text " name= "user ">
<input name= "optt " type= "text " value= " ">
<input type= "submit " name= "submit " value= "search ">
<table width= "100% ">
<tr>
<td width= "10% " bgcolor= "gray "> 记录编号 </td>
<td width= "10% " bgcolor= "gray "> 姓名 </td>
<td width= "10% " bgcolor= "gray "> 年龄 </td>
<td width= "10% " bgcolor= "gray "> 性别 </td>
<td width= "30% " bgcolor= "gray "> 电子邮箱 </td>
<td width= "30% " bgcolor= "gray "> 地址 </td>
</tr>
</table>
<%!
String s1=null;
String s2=null;
String s3=null;
%>
<% Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ").newInstance();
String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=motivecall ";
String user = "sa ";
String passwd = "123456 ";
Connection conn = DriverManager.getConnection(url,user,passwd);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String s1=(String)request.getParameter( "n1 ");
String s2=(String)request.getParameter( "user ");
String s3=(String)request.getParameter( "optt ");
String sql= "select * from james_user where ' "+s3+ " ' like '% "+s2+ "% ' ";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) { %>
<table width= "100% ">
<tr align=center valign= "middle ">
<td width= "10% "> <%=rs.getString(1)%> </td>
<input type=hidden name= "11 " value= " <%=rs.getString(1)%> ">
<td width= "10% "> <%=rs.getString(2)%> </td>
<input type=hidden name= "12 " value= " <%=rs.getString(2)%> ">
<td width= "10% "> <%=rs.getString(3)%> </td>
<input type=hidden name= "13 " value= " <%=rs.getString(3)%> ">
<td width= "10% "> <%=rs.getString(4)%> </td>
<input type=hidden name= "14 " value= " <%=rs.getString(4)%> ">
<td width= "30% "> <%=rs.getString(5)%> </td>
<input type=hidden name= "15 " value= " <%=rs.getString(5)%> ">
<td width= "30% "> <%=rs.getString(6)%> </td>
<input type=hidden name= "16 " value= " <%=rs.getString(6)%> ">
</tr>
</table>
<% } %> <p>
<% out.print( "数据库操作成功,恭喜你! "); %>
<% rs.close();
stmt.close();
conn.close();
%>
</form>
</body>
</html>
[解决办法]
<input type= "text " name= "user "> value?
代码由点乱 而且在JSPzhong 直接连数据库不好 ，建议还是写个servlet.最好把报的错发出来
[解决办法]
trycatch
看看什么错
