如题,刚刚接触,不知道怎么根据id的值取出mysql中的其他数据 “select * from article where id=” 写到这样就不会写了 id的值是另外一个jsp页面指定的 具体代码如下: <%
int a=Integer.parseInt(request.getParameter("action"));
Context ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/news");
Connection conn=ds.getConnection();
//创建可滚动的结果集
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select * from article where id=";
ResultSet rs=stmt.executeQuery("select * from article where id=a");
%>
<%
request.setCharacterEncoding("UTF-8");
String articlet="",articleb="";
if(rs.next()){
// String articlet=request.getParameter("action2");
articlet=rs.getString("title");
articleb=rs.getString("body");
}
%>
<h3><%out.println(articlet); %></h3>
<h5><%out.println(articleb);%></h5><br/>
int a=Integer.parseInt(request.getParameter("action"));
Context ctx=new InitialContext();
DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/news");
Connection conn=ds.getConnection();
//创建可滚动的结果集
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="select * from article where id=";
ResultSet rs=stmt.executeQuery("select * from article where id=a");
%>
<%
request.setCharacterEncoding("UTF-8");
String articlet="",articleb="";
if(rs.next()){
// String articlet=request.getParameter("action2");
articlet=rs.getString("title");
articleb=rs.getString("body");
}
%>
<h3><%out.println(articlet); %></h3>
<h5><%out.println(articleb);%></h5><br/>
ResultSet rs=stmt.executeQuery(sql);