Hi everyone:
I have a javabean that has a executequery method.I use it in
jsp file.I use "select * from statement" for query data in the mysql.But I get nothing in browser!The IE is blank!My javabean code is:
/////////////////////////////Mydata.java////////////////////////////////////////////
public class Mydata {
ResultSet rs;
Statement stm;
Connection conn;
String sql="select * from statement";
String connStr="jdbc:mysql://lyo:3306/test";
String uri="org.gjt.mm.mysql.Driver";
public Mydata(){
}
public ResultSet executequery(String sql){
try{
Class.forName(uri).newInstance();
conn=DriverManager.getConnection(connStr,"lyo","qijiashe");
stm=conn.createStatement();
rs=stm.executeQuery(sql);
rs.close();
}catch(Exception e){
System.out.println("Exception:"+e.toString());
}
return rs;
}
/////////////////////////////////main.jsp/////////////////////////////////////////////////
<%
String sql="select * from statement";
ResultSet rs;
rs = lyo.executequery(sql);
String id="";
String title="";
String statement="";
String name="";
String time="";
String fatherid="";
while(rs.next()){
%>
<td><%=rs.getString("id")%></td>
<td><%=rs.getString("title")%></td>
<td><%=rs.getString("content")%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("time")%></td>
<td><%=rs.getString("fatherid")%></td></tr>
<%
}
rs.close();
Can anyone help me?Where do I mistake?
:roll: