Connection conn = ds.getConnection();
if(conn!=null)
out.println("获得数据库连接,连接池配置成功");Statement stmt = conn.createStatement();// <<<<<
// 上句没有设置任何属性,所以不能用rs.absolute(i)
String strSql = " select * from addressbook ";
ResultSet rs = stmt.executeQuery(strSql);
out.println(obj.toString()); <<<===作何用?
while(rs.next()){
out.println("<tr><td>");
out.println(rs.getString(1));
out.println("</td>");
out.println("<td>");
out.print(rs.getString(2));
out.println("</td>");
out.println("<td>");
out.print(rs.getString(3));
out.println("</td></tr>");
}
if(conn!=null)
out.println("获得数据库连接,连接池配置成功");Statement stmt = conn.createStatement();// <<<<<
// 上句没有设置任何属性,所以不能用rs.absolute(i)
String strSql = " select * from addressbook ";
ResultSet rs = stmt.executeQuery(strSql);
out.println(obj.toString()); <<<===作何用?
while(rs.next()){
out.println("<tr><td>");
out.println(rs.getString(1));
out.println("</td>");
out.println("<td>");
out.print(rs.getString(2));
out.println("</td>");
out.println("<td>");
out.print(rs.getString(3));
out.println("</td></tr>");
}
// 上句没有设置任何属性,所以不能用rs.absolute(i)
<<<能具体说说如何改写吗?我用过conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);不过无效。out.println(obj.toString()); <<<===作何用?
//这种只是调试用,应该不影响把
{
try{
byte[] bytesStr=str.getBytes( "ISO-8859-1" ) ;
return new String( bytesStr, "gb2312" ) ; }
catch( Exception ex)
{ System.out.print("ISOtoGb2312() error"); return str ; }
}
<parameter> <name>url</name>
<value>jdbc:mysql://localhost:3306/addressbook?useUnicode=true&characterEncoding=GBK</value> </parameter>困惑是,我曾在后面加上
<parameter>
<name>useUnicode</name>
<value>true</value>
</parameter> <parameter>
<name>characterEncoding</name>
<value>gb2312</value>
</parameter>
不过好像没起作用的说,为什么呢?
out.println("<table border=1>");
int count = 1;
while(rs.next() != null) {
if (count >= 20) {
break;
}
out.println("<tr><td>"); out.println(rs.getString(1)); out.println("</td>"); out.println("<td>"); out.print(rs.getString(2)); out.println("</td>"); out.println("<td>"); out.print(rs.getString(3)); out.println("</td></tr>");
count++;
}