String sql = "select id,urlid,title,content from picnews order by crtime desc";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
int id = rs.getInt("id");
int urlid = rs.getInt("urlid");
urlidx[count]=urlid;
String title = rs.getString("title");
String content = rs.getString("content");
String sql_= "select distinct picurl from picnews_url where urlid = "+ urlid +"";
ResultSet rsx = stmt.executeQuery(sql_);
out.println(sql_);
//out.println(urlid);
//out.println(urlidx[count]);
count++;
}
请帮忙看看这段代码错在那里了 谢谢!
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
int id = rs.getInt("id");
int urlid = rs.getInt("urlid");
urlidx[count]=urlid;
String title = rs.getString("title");
String content = rs.getString("content");
String sql_= "select distinct picurl from picnews_url where urlid = "+ urlid +"";
ResultSet rsx = stmt.executeQuery(sql_);
out.println(sql_);
//out.println(urlid);
//out.println(urlidx[count]);
count++;
}
请帮忙看看这段代码错在那里了 谢谢!
create table picnews(id INT AUTO_INCREMENT PRIMARY KEY,typeid INT NOT NULL,urlid INT NOT NULL,title varchar(500),content varchar(50000),crtime timestamp NOT NULL default CURRENT_TIMESTAMP)type=MyISAM,default character set utf8;
create table picnews_url(id INT AUTO_INCREMENT PRIMARY KEY,urlid INT NOT NULL,picurl varchar(500),content varchar(50000),crtime timestamp NOT NULL default CURRENT_TIMESTAMP)type=MyISAM,default character set utf8;
我想实现的是取出picnews中的title和urlid 并通过urlid获取picnews_url中的一个picurl。picnews_url中的urlid是重复的
这里的stmt跟第一个语句的stmt要不一样的,这里stmt,应该再createStatement()一下!
意思就是,两个sql不要用一个statement
新建一个Statement执行rsx试试