在网页中输入id点查询,显示id和name,求怎么做??
如下图所示:我做好了输入name,显示id和name的
下面是java代码
public List<JspDepartment> getJspDepartment() throws SQLException
{
List<JspDepartment> jspList = new ArrayList<JspDepartment>();
List<Department> departmentList = departmentManage.queryAll();
for (int i = 0; i < departmentList.size(); i++)
{
JspDepartment jspDepartment = new JspDepartment();
jspDepartment.setId(departmentList.get(i).getId());
jspDepartment.setName(departmentList.get(i).getName());
jspList.add(jspDepartment);
}
return jspList;
}
public List<JspDepartment> getJspDepartment(String departmentName)
throws SQLException
{
List<JspDepartment> jspList = new ArrayList<JspDepartment>();
List<Department> departmentList = departmentManage
.query(departmentName);
for (int i = 0; i < departmentList.size(); i++)
{
JspDepartment jspDepartment = new JspDepartment();
jspDepartment.setId(departmentList.get(i).getId());
jspDepartment.setName(departmentList.get(i).getName());
jspList.add(jspDepartment);
}
return jspList;
}
jsp代码:
<form action="tree2.jsp">
<p class="serial">编号:001</p>
<input class="serial"></input>
<p class="name">机构名:中队1</p>
<input name="name" class="name"></input>
<button id="edit">修改</button>
<button id="del">删除</button>
<input type="submit" name="sub" value="查询" />
</form>
<%
if(request.getParameter("name")!=null)
{
String name =new String(request.getParameter("name").getBytes("iso8859-1"), "utf-8");
JspDepartmentManage jspDepartmentManage=new JspDepartmentManage();
List<JspDepartment> list=jspDepartmentManage.getJspDepartment(name);
%>
<%
for(JspDepartment jspDepartment: list)
{
%>
<div class="enter"></div>
<p class="serial"><%=jspDepartment.getId()%></p>
<p class="name"><%=jspDepartment.getName() %></p>
<p class="end"></p>
<%}
}%>
数据库连接和查询代码已经写好。
用id查询不会写啊 求代码
[解决办法]
select * from Table t where t.id = ?
[解决办法]
select id,name from table where id=? 问号处接收你jsp页面输入框传过来的id值,譬如你id传过来的为tid 那么语句就遮掩写 "select id,name from 表名 where id="+tid 试试看吧!