c 读取mysql中的数据输出到控制台_我想从数据库中查询出信息显示在控制台，该怎么实现代码下面是我写的一些...

packagesuixin.com.dao;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.Collection;importsuixin.com.bean.Goods;importsuixin.c...

package suixin.com.dao;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.ArrayList;

import java.util.Collection;

import suixin.com.bean.Goods;

import suixin.com.sql.DB;

public class ProductDao

{

public ProductDao()

{}

public Collection select(Goods goods)

{

ArrayList list=null;

String sql="select *from product";

DB db=new DB();

ResultSet rs=db.executeQuery(sql);

try{

if(rs!=null)

{

list=new ArrayList();

while(rs.next())

{

Goods goods1=new Goods();

goods1.setId(rs.getString("id"));

goods1.setCount(rs.getString("count"));

goods1.setInfo(rs.getString("info"));

goods1.setName(rs.getString("name"));

list.add(goods1);

}

}

}

catch(SQLException e)

{

e.getStackTrace();

}

return list;

}

public static void main(String args[])

{

ProductDao pd=new ProductDao();

DB db=new DB();

String sql="select *from product";

ResultSet rs=db.executeQuery(sql);

System.out.println(rs);

}

}

展开