将数据库中数据输出到控制台

public class test {
	public static void main(String[] args) {
		Connection con=Ptest.getConnection();
		Statement state=null;
		try {
			state=con.createStatement();
			String sql="select * from person";
			boolean bool=state.execute(sql);
			if(bool){
				ResultSet rs=state.getResultSet();
				while(rs.next()){
					String name=rs.getString("name");
					String id=rs.getString("id");
					String pass=rs.getString("pass");
					System.out.println("姓名："+name+"--id:"+id+"--pass:"+pass);
				}
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
			con.close();
			state.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}