topicdao3.java

数据库访问通用组件,实现通用的数据库操作,并附有用此通用组件的一个dao类.

package dao;

import javax.sql.RowSet;

public class TopicDao3 {

 
	public RowSet getTitlesByAuthorName(String authorName) {
		SqlBean sb=SqlBean.getInstance();
		return sb.getRowSet("select a.name title,b.name author from topic a,author b where a.user_id=b.id and b.name='"+authorName+"'","");
	}
 
	public static void main(String[] args) {
  
		TopicDao3 app = new TopicDao3();
		try 
		{
			RowSet rs = app.getTitlesByAuthorName("bbb");
			while(rs.next())
			{
				System.out.print("titile="+rs.getString("title")+",author=");
				System.out.println(rs.getString("author"));
			}   
		} 
		catch (Exception e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}  
 	}
}