Op.java

package bean;

import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Time;
import java.util.ArrayList;

import javax.swing.JOptionPane;

public class Op{
private PreparedStatement ps=null;
private ResultSet rs=null;
private Connection con=null;
public void close(){
try{
if(ps!=null){
ps.close();
ps=null;
}
if(rs!=null){
rs.close();
rs=null;
}
if(con!=null){
con.close();
con=null;
}
}catch(Exception e){
e.printStackTrace();
}
}
public ArrayList Name_R(String tablename,String name){
ArrayList liuyan=new ArrayList();
try{
con=new Cnectbean().getcon();//建立数据库连接
String sqlstr="select*from"+tablename+"where name=?";
ps=con.prepareStatement(sqlstr);
ps.setString(1, name);
rs=ps.executeQuery();
while(rs.next()){
liuyanbean t=new liuyanbean();
t.setName(rs.getString(1));
t.setContent(rs.getString(2));
t.setDtime(rs.getString(3));
liuyan.add(t);
}
}catch(Exception e){
e.printStackTrace();
}finally{
this.close();
}
return liuyan;
}
}

name_go.jsp


<%
String namego1=new String(request.getParameter("namego").getBytes("ISO-8859-1"),"UTF-8");
Op nameop=new Op();
ArrayList namelist=nameop.Name_R("table1", namego1);
%>


<%
liuyanbean liu;
for(int i=0;i liu=(liuyanbean) namelist.get(i);
%>



<%
}
%>

<%=liu.getName() %>

<%=liu.getContent() %>

<%=liu.getDtime() %>

可以显示name_go.jsp的页面但没有查询结果……