java 会员管理_Java_Web之俱乐部会员信息管理系统

packageDao_Impl;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.List;importentity.Club_Name;importDao.Club_Name_Select;importDao_Base.Base_Dao;public class Club_Name_Impl extends Base_Dao implementsClub_Name_Select{//创建数据库连接对象

Connection con=this.getConnection();//创建写入sql语句的参数

PreparedStatement ps=null;//创建结果集接收

ResultSet rs=null;//创建sql语句

String sql="";public ListCulb() {//创建数据库查询

sql="select * from memberisnfo";//创建实体类集合接收

List list=new ArrayList();try{//写入sql

ps=con.prepareStatement(sql);//执行sql

rs=ps.executeQuery();//循环输出并存入集合装入实体类

while(rs.next()){//实例化实体类对象

Club_Name name=newClub_Name();//开始存入

name.setId(rs.getString (1));

name.setMname(rs.getString(2));

name.setMgender(rs.getString(3));

name.setMage(rs.getString (4));

name.setMaddress(rs.getString(5));

name.setMemail(rs.getString(6));//将查询的对象存入集合中去

list.add(name);

}

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}returnlist;

}public ListCulb2(String id) {//创建数据库查询

sql="select * from memberisnfo where id=?";//创建实体类集合接收

List list=new ArrayList();try{//写入sql

ps=con.prepareStatement(sql);

ps.setString (1, id);//执行sql

rs=ps.executeQuery();//循环输出并存入集合装入实体类

while(rs.next()){//实例化实体类对象

Club_Name name=newClub_Name();//开始存入

name.setId(rs.getString (1));

name.setMname(rs.getString(2));

name.setMgender(rs.getString(3));

name.setMage(rs.getString (4));

name.setMaddress(rs.getString(5));

name.setMemail(rs.getString(6));//将查询的对象存入集合中去

list.add(name);

}

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}returnlist;

}publicString Culd3(String id,String mname, String mgender, String mage,

String maddress, String memail) {//创建数据库查询

sql="update memberisnfo set mname=?,mgender=?,mage=?,maddress=?,memail=? where id=?";int q=0;try{//写入sql

ps=con.prepareStatement(sql);

ps.setString(1, mname);

ps.setString(2, mgender);

ps.setString (3, mage);

ps.setString(4, maddress);

ps.setString(5, memail);

ps.setString (6, id);//执行sql

q=ps.executeUpdate();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}if(q>0){return "ok";

}else{return "no";

}

}

}