首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > Java Web开发 >

数据读取有关问题?

2012-02-26 
数据读取问题??运行下代码出现这个:packagech18.JavaBeanNote:D:\jsp\WEB-INF\classes\DB_User.javausesu

数据读取问题??
运行下代码出现这个:
package   ch18.JavaBean;Note:   D:\jsp\WEB-INF\classes\DB_User.java   uses   unchecked   or   unsafe   operations.
Note:   Recompile   with   -Xlint:unchecked   for   details.
请问这回事呢?我的代码没有问题,但就是不能从数据库读取数据
import   java.io.PrintWriter;
import   java.sql.Connection;
import   java.sql.DriverManager;
import   java.sql.ResultSet;
import   java.sql.SQLException;
import   java.sql.Statement;
import   java.util.ArrayList;
import   java.util.Collection;
import   javax.security.sasl.SaslException;

import   sun.jdbc.odbc.ee.ConnectionPool;

import   ch18.JavaBean.User;
import   ch18.JavaBean.DB_Conn;

public   class   DB_User
{

DB_Conn   db_conn=new   DB_Conn();

public   int   getCount()
{
db_conn.ConnectDB();
ResultSet   rs   =   null;
try
{          
String   sql   =   "select   count(id)   from   userinfo ";
rs   =   db_conn.sm.executeQuery(sql);              
if   (rs.next())
  {
return   rs.getInt(6);
}
return   0;
}  
catch   (SQLException   SqlE)  
{
SqlE.printStackTrace();
return   0;
}   catch   (Exception   E)
{
      E.printStackTrace();
return   0;
}   finally  
{

db_conn.CloseDB();
}
}
public   Collection   getAll(int   pagesize,   int   page)
{
                db_conn.ConnectDB();
ResultSet   rs   =   null;
try   {

String   sql   =   "select   *   from   userinfo   order   by   id   desc   limit "
+   (page   -   1)   *   pagesize   +   ", "   +   pagesize;

rs=db_conn.sm.executeQuery(sql);
Collection   c   =   new   ArrayList();
User   user   =   null;
while   (rs.next())
{
user   =   new   User();
user.setId(rs.getInt( "id "));
user.setUsername(rs.getString( "UserName "));
user.setPassword(rs.getString( "Pwd "));
user.setEmail(rs.getString( "Email "));
user.setRealname(rs.getString( "RealName "));
user.setGender(rs.getInt( "Gender "));
                                user.setQuestion(rs.getString( "Question "));
                                user.setAnswer(rs.getString( "Answer "));
user.setPhone(rs.getString( "Phone "));
user.setPage(rs.getString( "MyPage "));
user.setHobbies(rs.getString( "Hobbies "));
user.setSelfintro(rs.getString( "Selfintro "));
c.add(user);
user   =   null;
}
return   c;
}   catch   (SQLException   SqlE)
{
SqlE.printStackTrace();
return   null;
}   catch   (Exception   E)
{
E.printStackTrace();


return   null;
}   finally
{
db_conn.CloseDB();
}
}

}


[解决办法]
String sql = "select count(id) from userinfo ";
rs = db_conn.sm.executeQuery(sql);
if (rs.next())
{
return rs.getInt(6);
}
改成:
return rs.getInt(1);

热点排行