import java.security.NoSuchAlgorithmException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;import liaoliao.app.web.util.DBTool;
import java.util.Vector;
public class ViewnewsService {
String title;
String writer;
String content;
String sort;
String addTime;
int id;
public ViewnewsService(){}
public ViewnewsService(String title,
String writer,
String content,
String sort,
String addTime,
int id){
this.title=title;
this.writer=writer;
this.content=content;
this.sort=sort;
this.addTime=addTime;
this.id=id;
}
private ResultSet res()throws SQLException{
DBTool db=null;
try{
db=new DBTool();
Connection conn=db.getConnection();
Statement stmt=conn.createStatement();
String sql="select * from news";
ResultSet rs=stmt.executeQuery(sql); while(rs.next()){
this.id=rs.getInt("id");
this.title=rs.getString("title");
this.writer=rs.getString("writer");
this.sort=rs.getString("sort");
this.content=rs.getString("content");
this.addTime=rs.getString("addTime");
}
return rs;
}catch (SQLException e){
e.printStackTrace();
throw e;
}finally {
if (db != null) {
db.closeConnection();
}
}
} public String getAddTime() {
return addTime;
} public void setAddTime(String addTime) {
this.addTime = addTime;
} public String getContent() {
return content;
} public void setContent(String content) {
this.content = content;
} public int getId() {
return id;
} public void setId(int id) {
this.id = id;
} public String getSort() {
return sort;
} public void setSort(String sort) {
this.sort = sort;
} public String getTitle() {
return title;
} public void setTitle(String title) {
this.title = title;
} public String getWriter() {
return writer;
} public void setWriter(String writer) {
this.writer = writer;
}
}
*************************************************************************
取到的全是null和0;请问应该怎么弄啊~?
先谢过了~~
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;import liaoliao.app.web.util.DBTool;
import java.util.Vector;
public class ViewnewsService {
String title;
String writer;
String content;
String sort;
String addTime;
int id;
public ViewnewsService(){}
public ViewnewsService(String title,
String writer,
String content,
String sort,
String addTime,
int id){
this.title=title;
this.writer=writer;
this.content=content;
this.sort=sort;
this.addTime=addTime;
this.id=id;
}
private ResultSet res()throws SQLException{
DBTool db=null;
try{
db=new DBTool();
Connection conn=db.getConnection();
Statement stmt=conn.createStatement();
String sql="select * from news";
ResultSet rs=stmt.executeQuery(sql); while(rs.next()){
this.id=rs.getInt("id");
this.title=rs.getString("title");
this.writer=rs.getString("writer");
this.sort=rs.getString("sort");
this.content=rs.getString("content");
this.addTime=rs.getString("addTime");
}
return rs;
}catch (SQLException e){
e.printStackTrace();
throw e;
}finally {
if (db != null) {
db.closeConnection();
}
}
} public String getAddTime() {
return addTime;
} public void setAddTime(String addTime) {
this.addTime = addTime;
} public String getContent() {
return content;
} public void setContent(String content) {
this.content = content;
} public int getId() {
return id;
} public void setId(int id) {
this.id = id;
} public String getSort() {
return sort;
} public void setSort(String sort) {
this.sort = sort;
} public String getTitle() {
return title;
} public void setTitle(String title) {
this.title = title;
} public String getWriter() {
return writer;
} public void setWriter(String writer) {
this.writer = writer;
}
}
*************************************************************************
取到的全是null和0;请问应该怎么弄啊~?
先谢过了~~
解决方案 »
- 先选中一行,把这一行的第一列td的值通过按钮传给后台。这个怎么弄?????
- struts2 中如何通过配置文件连接数据库
- server.xml配置问题,急问大家!
- 使用了struts后,并且将log4j的级别设置为debug,tomcat启动后报太多的debug信息,怎么办?
- 一个计算器数据相加的问题,请各路大侠帮忙!!!
- dreamweaver ultradev4.0中连接数据库问题
- 菜鸟问题,请各位大哥详细解答!谢谢
- 装好ORACLE后,TOMCAT的配置总是不对,怎样才能配对?急~~~~~~
- jsp源程序开发下载????
- 关于tomcat
- web客户端通过applet调dll实现客户端读写卡
- 调用javabean出错,帮帮忙呀
this.id=rs.getInt("id");
this.title=rs.getString("title");
this.writer=rs.getString("writer");
this.sort=rs.getString("sort");
this.content=rs.getString("content");
this.addTime=rs.getString("addTime");
}
这样不是副给成员变量了吗
再通过getter取 不行吗?
rs关闭了 但是值应该副过了啊~
你赋值的代码是写在这个方法里的,你没有调用执行该方法的代码,也就是这段代码没有运行,你只单单写了代码,没有运行,怎么可能有结果?
}
然后没有while 直接this.id=rs.getInt("id");
this.title=rs.getString("title");
this.writer=rs.getString("writer");
this.sort=rs.getString("sort");
this.content=rs.getString("content");
this.addTime=rs.getString("addTime");
这样测试的,可是还是取到的null~
先感谢一下这位大哥~
this.id=rs.getInt("id");
this.title=rs.getString("title");
this.writer=rs.getString("writer");
this.sort=rs.getString("sort");
this.content=rs.getString("content");
this.addTime=rs.getString("addTime");
}while不能去,如果用while ,是取最后一条数据,如果改成if,那么就是取第一条数据在外边new一个对象,然后再调用一下此方法,如:
ViewnewsService vs=new ViewnewsService();vs.res();然后打印,System.out.println(vs.getId());
***************************************************
Severity Description Resource In Folder Location Creation Time Id
2 Unhandled exception type SQLException ViewnewsAction.java liaoliao/src/liaoliao/app/web/news line 18 2006年9月27日 20:23:55 2173
正在改
先再次谢谢这位大哥
ResultSet 也没必要返回
楼主再改改
大家再帮你看看