求助:一个jsp中<a href="nw/register.jsp? titleId="<%=rst.getString("titleId")%>"">...</a>的传值问题,如何接收???谢谢各位帮帮 同意,大家都是用的它呀。request.getParamter("titleid") 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 request.getParamter("titleid")楼下的注意保持队型 request.getParamter("titleid")楼下的注意保持队型 request.getParamter("titleid")楼下的注意保持队型 request.getParamter("titleid")楼下的注意保持队型 request.getParamter("titleid")我保持队形了:) request.getParamter("titleid")和同志们保持一致... 不知为什么,打印是空值,我的文件如下,请各位看看,指点一下:这是index。jsp文件 <% try { //Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); //Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=CityHuanWei","sa","821121"); Connection con=java.sql.DriverManager.getConnection("jdbc:odbc:CityHuanWei","sa","821121"); Statement stmt=con.createStatement(); ResultSet rst=stmt.executeQuery("SELECT titleId,title FROM titleInfo WHERE titleClass='1'");while(rst.next()) { String id=rst.getString(1); String title=rst.getString(2); System.out.println(id); System.out.println(title);%> <tr> <td><a href="nw/validateTitle.jsp? titleId= <%=id %>"> <%=title %> </a> </td> </tr><% } rst.close(); stmt.close(); con.close(); } catch(Exception e) { e.printStackTrace(); } %> 在接收页面打印到空值,validateTitle.jsp: <% try { String titleId = request.getParameter("titleId"); //Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); //Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=CityHuanWei","sa","821121"); Connection con=java.sql.DriverManager.getConnection("jdbc:odbc:CityHuanWei","sa","821121"); PreparedStatement ps=null; ResultSet rst=ps.executeQuery("SELECT context FROM titleInfo WHERE titleId=?"); ps.setString(1,titleId); while(rst.next()) { out.println("<tr>"); out.println("<td>"+rst.getString("context")+"</td>"); out.println("</tr>"); } rst.close(); ps.close(); con.close(); } catch(Exception e) { e.printStackTrace(); } %> 打印出什么是空值?是<%=id %>和<%=title %>吗?你问问题说明白撒! 在接收页面打印到空值,validateTitle.jsp:System.out.println(titleId); <a href="nw/register.jsp?titleId='<%=rst.getString("titleId")%>'">rst.getString("title")</a> 我觉得rst.getString("titleId")中的titleId应该用大写吧?TITLEID 像这种问题就两种可能:一、String id=rst.getString(1); id就没有取出来,本身就是个null二、如果id不为空那肯定就没有传到下一个页面呗 你在validateTitle.jsp页面中测试一下看有没有接受到参数值:<% String titlevalue=new String(); titlevalue=request.getParameter("titleID"); out.println("titlevalue=" + titlevalue);%>然后再把值传到SQL语句,试试看 我试了,titlevalue=null ,根本没传过去请各位帮帮我!!!index.jsp:<% try { String id = "1001"; String title = "你是谁???"; /* Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); Connection con=java.sql.DriverManager.getConnection("jdbc:odbc:CityHuanWei","sa","821121"); Statement stmt=con.createStatement(); ResultSet rst=stmt.executeQuery("SELECT titleId,title FROM titleInfo WHERE titleClass='1'");while(rst.next()) { String id=rst.getString(1); String title=rst.getString(2);*/ out.println(id); out.println(title);%> <tr> <td><a href="ztx1.jsp? titleId=<%=id%>"> <%=title %> </a> </td> </tr><%/* } rst.close(); stmt.close(); con.close();*/ } catch(Exception e) { e.printStackTrace(); } %> validate.jsp:<% try { String titlevalue=new String(); titlevalue=request.getParameter("titleId"); out.println("titlevalue=" + titlevalue); /*String titleId = request.getParameter("titleId"); System.out.print(titleId); out.print(titleId); out.println("<tr>"); out.println("<td>"+titleId+"</td>"); out.println("</tr>");*/ /* Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); Connection con=java.sql.DriverManager.getConnection("jdbc:odbc:CityHuanWei","sa","821121"); PreparedStatement ps = con.prepareStatement(); Statement stmt=con.createStatement(); ResultSet rst=stmt.executeQuery("SELECT title FROM titleInfo WHERE titleId=?"); ps.setString(1,titleId); while(rst.next()) { out.println("<tr>"); out.println("<td>"+rst.getString("titleId")+"</td>"); out.println("</tr>"); /*} rst.close(); stmt.close(); con.close();*/ } catch(Exception e) { e.printStackTrace(); } %> <a href="ztx1.jsp? titleId=<%=id%>"> 问号后面不要加空格 SpringMVC @ResponseBody JSON AJAX 问题,求高手解决啊 最近要考试,请教一些理论问题 java web权限的问题 如何提取网页中的信息 400分求一个 动态树 带checkbox的 数据库连接问题 怎么才能在2个服务器之间发送内容 mysql中如何使用sql语句,使某一字段重命名;使某一字段数据类型改变 as admin不是内部或外部命令,也不是可运行的程序 jdbc问题 第二次发同样的问题,高手可怜下。15分全给了。快要疯了 头疼:JSP有的页面在IE工具条里点"后退",就发生网页过期
我保持队形了:)
和同志们保持一致...
<%
try
{
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
//Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=CityHuanWei","sa","821121");
Connection con=java.sql.DriverManager.getConnection("jdbc:odbc:CityHuanWei","sa","821121");
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("SELECT titleId,title FROM titleInfo WHERE titleClass='1'");
while(rst.next())
{
String id=rst.getString(1);
String title=rst.getString(2);
System.out.println(id);
System.out.println(title);
%>
<tr>
<td><a href="nw/validateTitle.jsp? titleId= <%=id %>">
<%=title %>
</a>
</td>
</tr>
<%
} rst.close();
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
<%
try
{
String titleId = request.getParameter("titleId");
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
//Connection con=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=CityHuanWei","sa","821121");
Connection con=java.sql.DriverManager.getConnection("jdbc:odbc:CityHuanWei","sa","821121");
PreparedStatement ps=null;
ResultSet rst=ps.executeQuery("SELECT context FROM titleInfo WHERE titleId=?");
ps.setString(1,titleId);
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("context")+"</td>");
out.println("</tr>");
}
rst.close();
ps.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>
System.out.println(titleId);
一、String id=rst.getString(1); id就没有取出来,本身就是个null
二、如果id不为空那肯定就没有传到下一个页面呗
<%
String titlevalue=new String();
titlevalue=request.getParameter("titleID");
out.println("titlevalue=" + titlevalue);
%>
然后再把值传到SQL语句,试试看
<%
try
{
String id = "1001";
String title = "你是谁???";
/* Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con=java.sql.DriverManager.getConnection("jdbc:odbc:CityHuanWei","sa","821121");
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("SELECT titleId,title FROM titleInfo WHERE titleClass='1'");
while(rst.next())
{
String id=rst.getString(1);
String title=rst.getString(2);*/
out.println(id);
out.println(title);
%> <tr>
<td><a href="ztx1.jsp? titleId=<%=id%>">
<%=title %>
</a>
</td>
</tr><%
/* } rst.close();
stmt.close();
con.close();*/
}
catch(Exception e)
{
e.printStackTrace();
}
%>
<%
try
{
String titlevalue=new String();
titlevalue=request.getParameter("titleId");
out.println("titlevalue=" + titlevalue);
/*String titleId = request.getParameter("titleId");
System.out.print(titleId);
out.print(titleId);
out.println("<tr>");
out.println("<td>"+titleId+"</td>");
out.println("</tr>");*/
/* Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con=java.sql.DriverManager.getConnection("jdbc:odbc:CityHuanWei","sa","821121");
PreparedStatement ps = con.prepareStatement();
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("SELECT title FROM titleInfo WHERE titleId=?");
ps.setString(1,titleId);
while(rst.next())
{
out.println("<tr>");
out.println("<td>"+rst.getString("titleId")+"</td>");
out.println("</tr>");
/*}
rst.close();
stmt.close();
con.close();*/
}
catch(Exception e)
{
e.printStackTrace();
}
%>
问号后面不要加空格