（4.1-4.7）拼团项目进度汇报
1.任务安排
| 计划时间 | 计划任务 | 计划是否完成 |
| 3.22-3.29 | 管理员的增删改查 | 是 |
| 3.29-4.5 | 编写活动模块 | 是 |
| 4.5-4.12 | 完善活动的增删改查 |
2.下周计划完成内容
完善活动的增删改查
3.本周实现功能
- a.编写活动类
- b.完善活动的servlet层代码
- c.基本实现用户的增删改查
4.本周实现代码
整合了仕庄的代码
- servlet类都放在action包里，用于存放增删改查操作
- bean包里放实体类
- dao包里放dao接口类
主要编写了EventthreadServlet类中的doPost()中的增删改查：
1 1 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 2 2 3 3 this.doPost(request, response); 4 4 5 5 } 6 6 7 7 /** 8 8 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) 9 9 */ 10 10 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { 11 11 String action=request.getParameter("action"); 12 12 if(action.equals("query")){//列表 13 13 String sql="select * from pt_eventthreads"; 14 14 ResultSet rs=null; 15 15 List<EventThreads> eventList=new ArrayList<EventThreads>(); 16 16 try { 17 17 rs = dbc.doQueryRS(sql,new Object[]{}); 18 18 19 19 while(rs.next()) 20 20 { 21 21 EventThreads et = new EventThreads(); 22 22 et.setUserID(rs.getInt("UserID")); 23 23 et.setEventID(rs.getInt("EventID")); 24 24 et.setEventName(rs.getString("EventName")); 25 25 et.setEventType(rs.getString("EventType")); 26 26 et.setEventInitiator(rs.getString("EventInitiator")); 27 27 et.setStarTime(rs.getTime("StartTime")); 28 28 et.setEndTime(rs.getTime("EndTime")); 29 29 et.setSignEndTime(rs.getTime("SignEndTime")); 30 30 et.setDateCreated(rs.getTimestamp("DateCreated")); 31 31 et.setLocation(rs.getString("Location")); 32 32 et.setBody(rs.getString("Body")); 33 33 et.setHitTimes(rs.getInt("HitTimes")); 34 34 et.setLimitCount(rs.getInt("LimitCount")); 35 35 eventList.add(et); 36 36 } 37 37 } catch (SQLException e) { 38 38 e.printStackTrace(); 39 39 } 40 40 41 41 HttpSession session=request.getSession(); 42 42 session.setAttribute("eventList", eventList); 43 43 request.getRequestDispatcher("event_list.jsp").forward(request, response); 44 44 }else if(action.equals("del")) 45 45 { 46 46 int id=Integer.parseInt(request.getParameter("EventID")); 47 47 String sql="delete from pt_eventthread where EventID=?"; 48 48 int res=0; 49 49 try { 50 50 res = dbc.doUpdate(sql,new Object[]{id}); 51 51 } catch (SQLException e) { 52 52 e.printStackTrace(); 53 53 } 54 54 if(res>0) 55 55 { 56 56 request.getRequestDispatcher("event?action=query").forward(request, response); 57 57 }else 58 58 { 59 59 PrintWriter out=response.getWriter(); 60 60 out.print("删除失败"); 61 61 out.close(); 62 62 } 63 63 }else if(action.equals("add"))//增加活动 64 64 { 65 65 String id=request.getParameter("EventID"); 66 66 String TYPE=request.getParameter("EventType"); 67 67 String sql="insert into pt_eventthreads(EventID,EventType) values(?,?)"; 68 68 int res=0; 69 69 try { 70 70 res = dbc.doUpdate(sql,new Object[]{id,TYPE}); 71 71 } catch (SQLException e) { 72 72 e.printStackTrace(); 73 73 } 74 74 if(res>0) 75 75 { 76 76 request.getRequestDispatcher("event?action=query").forward(request, response); 77 77 }else 78 78 { 79 79 PrintWriter out=response.getWriter(); 80 80 out.print("添加失败"); 81 81 out.close(); 82 82 } 83 83 84 84 }else if(action.equals("edit"))//修改活动 85 85 { 86 86 int EventID=Integer.parseInt(request.getParameter("EventID")); 87 87 String sql="select * from pt_eventthreads where EventID=?"; 88 88 EventThreads event=null; 89 89 try { 90 90 ResultSet rs=dbc.doQueryRS(sql,new Object[]{EventID}); 91 91 if(rs.next()) 92 92 { 93 93 event=new EventThreads(); 94 94 event.setEventID(rs.getInt("EventID")); 95 95 event.setEventName(rs.getString("EventName")); 96 96 event.setEventInitiator(rs.getString("EventInitiator")); 97 97 event.setUserID(rs.getInt("UserID")); 98 98 event.setEventInitiator(rs.getString("EventInitiator")); 99 99 event.setEventName(rs.getString("EventName")); 100 100 event.setBody(rs.getString("Body")); 101 101 event.setEventType(rs.getString("Type")); 102 102 event.setStarTime(rs.getTime("StarTime")); 103 103 event.setEndTime(rs.getTime("EndTime")); 104 104 event.setDateCreated(rs.getTimestamp("DateCreated")); 105 105 event.setLocation(rs.getString("Location")); 106 106 event.setLimitCount(rs.getInt("LimitCount")) ; 107 107 } 108 108 } catch (SQLException e) { 109 109 e.printStackTrace(); 110 110 } 111 111 HttpSession session=request.getSession(); 112 112 session.setAttribute("event", event); 113 113 request.getRequestDispatcher("event_list.jsp").forward(request, response); 114 114 115 115 }else if(action.equals("update"))//更新活动 116 116 { 117 117 int EventID=Integer.parseInt(request.getParameter("EventID")); 118 118 String EventName=request.getParameter("EventName"); 119 119 String EventInitiator=request.getParameter("EventInitiator"); 120 120 String sql="update pt_eventthreads set EventName=?,EventInitiator=? where EventID=?"; 121 121 int res=0; 122 122 try { 123 123 res = dbc.doUpdate(sql,new Object[]{EventName,EventInitiator,EventID}); 124 124 } catch (SQLException e) { 125 125 e.printStackTrace(); 126 126 } 127 127 if(res>0) 128 128 { 129 129 request.getRequestDispatcher("event?action=query").forward(request, response); 130 130 }else 131 131 { 132 132 PrintWriter out=response.getWriter(); 133 133 out.print("更新失败"); 134 134 out.close(); 135 135 } 136 136 }else 137 137 { 138 138 139 139 } 140 140 } 141 141 142 142 }
package pintuan.action;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import pintuan.bean.User;
import pintuan.db.DBConnection;
public class UserServlet extends HttpServlet {
private DBConnection dbc=new DBConnection();
private static final long serialVersionUID = 1L;
public UserServlet() {
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
this.doPost(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String action=request.getParameter("action");
if(action.equals("query")){
String sql="select * from pt_user";
ResultSet rs=null;
List<User> userList=new ArrayList<User>();
try {
rs = dbc.doQueryRS(sql,new Object[]{});
while(rs.next())
{
User user=new User();
user.setUserName(rs.getString("UserName"));
user.setUserID(rs.getString("UserID"));
user.setId(rs.getInt("id"));
user.setPassword(rs.getString("Password"));
user.setEmail(rs.getString("Email"));
user.setIsDelete(rs.getInt("isDelete"));
user.setIsApplied(rs.getInt("isApplied"));
user.setIsProfile(rs.getInt("isProfile"));
userList.add(user);
}
} catch (SQLException e) {
e.printStackTrace();
}
HttpSession session=request.getSession();
session.setAttribute("userList", userList);
request.getRequestDispatcher("user_list.jsp").forward(request, response);
}else if(action.equals("del"))
{
int id=Integer.parseInt(request.getParameter("id"));
String sql="delete from pt_user where id=?";
int res=0;
try {
res = dbc.doUpdate(sql,new Object[]{id});
} catch (SQLException e) {
e.printStackTrace();
}
if(res>0)
{
request.getRequestDispatcher("user?action=query").forward(request, response);
}else
{
PrintWriter out=response.getWriter();
out.print("删除失败");
out.close();
}
}else if(action.equals("add"))
{
String UserID=request.getParameter("UserID");
String UserName = request.getParameter("UserName");
String Password = request.getParameter("Password");
String email = request.getParameter("email");
int isApplied = Integer.parseInt(request.getParameter("isApplied"));
int isDelete = Integer.parseInt(request.getParameter("isDelete"));
int isProfile = Integer.parseInt(request.getParameter("isProfile"));
String sql="insert into pt_user(UserID,UserName,Password,email,isApplied,isDelete,isProfile) values(?,?,?,?,?,?,?)";
int res=0;
try {
res = dbc.doUpdate(sql,new Object[]{UserID,UserName,Password,email,isApplied,isDelete,isProfile});
} catch (SQLException e) {
e.printStackTrace();
}
if(res>0)
{
request.getRequestDispatcher("user?action=query").forward(request, response);
}else
{
PrintWriter out=response.getWriter();
out.print("添加失败");
out.close();
}
}else if(action.equals("edit"))
{
int id=Integer.parseInt(request.getParameter("id"));
String sql="select * from pt_user where id=?";
User user=null;
try {
ResultSet rs=dbc.doQueryRS(sql,new Object[]{id});
if(rs.next())
{
user = new User();
user.setUserID(rs.getString("UserID"));
user.setUserName(rs.getString("UserName"));
user.setPassword(rs.getString("Password"));
user.setIsApplied(rs.getInt("isApplied"));
user.setIsDelete(rs.getInt("isDelete"));
user.setIsProfile(rs.getInt("isProfile"));
user.setId(rs.getInt("id"));
}
} catch (SQLException e) {
e.printStackTrace();
}
HttpSession session=request.getSession();
session.setAttribute("user", user);
request.getRequestDispatcher("edit_user.jsp").forward(request, response);
}else if(action.equals("update"))
{
int id=Integer.parseInt(request.getParameter("id"));
String UserID=request.getParameter("UserID");
String UserName = request.getParameter("UserName");
String Password = request.getParameter("Password");
String email = request.getParameter("email");
int isApplied = Integer.parseInt(request.getParameter("isApplied"));
int isDelete = Integer.parseInt(request.getParameter("isDelete"));
int isProfile = Integer.parseInt(request.getParameter("isProfile"));
String sql="update pt_user set "
+ "UserID=?,UserName=?,Password=?,email=?,"
+ "isApplied=?,isDelete=?,isProfile = ? where id=?";
int res=0;
try {
res = dbc.doUpdate(sql,new Object[]{UserID,UserName,Password,email,isApplied,isDelete,isProfile,id});
} catch (SQLException e) {
e.printStackTrace();
}
if(res>0)
{
request.getRequestDispatcher("user?action=query").forward(request, response);
}else
{
PrintWriter out=response.getWriter();
out.print("更新失败");
out.close();
}
}else if(action.equals("register"))
{
String UserID=request.getParameter("UserID");
String UserName = request.getParameter("UserName");
String Password = request.getParameter("Password");
String email = request.getParameter("email");
int isApplied = Integer.parseInt(request.getParameter("isApplied"));
int isDelete = Integer.parseInt(request.getParameter("isDelete"));
int isProfile = Integer.parseInt(request.getParameter("isProfile"));
String sql="insert into pt_user(UserID,UserName,Password,email,isApplied,isDelete,isProfile) values(?,?,?,?,?,?,?)";
int res=0;
try {
res = dbc.doUpdate(sql,new Object[]{UserID,UserName,Password,email,isApplied,isDelete,isProfile});
} catch (SQLException e) {
e.printStackTrace();
}
if(res>0)
{
request.getRequestDispatcher("register_result_test.jsp").forward(request, response);
}else
{
PrintWriter out=response.getWriter();
out.print("添加失败");
out.close();
}
}
else
{
}
}
}
5.本周代码实现截图
后续将根据前端设计再修改界面
活动修改类怎么改都会报错，实在找不出到底是哪里错了，说不定睡一觉明天起来就好了呢
6.本周碰到问题及解决方法
根据项目要求实现活动的增删改查说难不难，说简单不简单，有时候试了很多种方法，每次都感觉这一种一定行，但是怎么尝试都会出错，明早起来换一个清醒的头脑再做吧。
7.本周小结
效率这种问题真的是要分时间段，有的时候坐一个下午也没有某一个早上一个小时的成果好。接下来要慢慢把功能初步实现了，现在更难的是跟前端的交接，感觉什么都不懂又要重新开始学起，这周隐隐约约感觉到万一我们写的jsp页面跟前端结合不起来那就有点尴尬了。。。
浙公网安备 33010602011771号