1.方法
/** 查看全部信息*/
public ListselectByName(String name) {//TODO Auto-generated method stub
List list=new ArrayList();
PreparedStatement pre=null;
ResultSet rs=null;try{
String sql="select*from blog where name=?";
pre=con.prepareStatement(sql);
pre.setString(1, name);
rs=pre.executeQuery();while(rs.next()) {
Member user=newMember();
user.setName(rs.getString("name"));
user.setAge(rs.getString("age"));
list.add(user);
}
}catch(SQLException e) {
e.printStackTrace();
}finally{
Databass.Databass.close(rs, pre, con);
}returnlist;
}public Listselectall(){
List list=new ArrayList();try{
String sql="select * from blog";
PreparedStatement pr