jsp servlet MVC Demo

package name.chenye.friends.servlet; import java.sql.*; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import name.chenye.friends.common.*; /** * Servlet implementation class for Servlet: AddFriends * */ public class AddFriend extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet { static final long serialVersionUID = 1L; /* (non-Java-doc) * @see javax.servlet.http.HttpServlet#HttpServlet() */ public AddFriend() { super(); } /* (non-Java-doc) * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub } /* (non-Java-doc) * @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub request.setCharacterEncoding("GBK"); //System.out.println(request.getAttribute("")); //System.out.println(friendBean.); Statement stat=new DatabaseService().getStatement(); String name =request.getParameter("name"); String birthday=request.getParameter("birthday"); String livenow=request.getParameter("liveNowProvince")+ "-"+request.getParameter("liveNowCity")+ "-"+request.getParameter("liveNowCounty")+ "-"+request.getParameter("liveNowStreet"); String hometown=request.getParameter("hometownProvince")+ "-"+request.getParameter("hometownCity")+ "-"+request.getParameter("hometownCounty")+ "-"+request.getParameter("hometownStreet"); String resume=request.getParameter("resume"); Integer groupId=Integer.parseInt(request.getParameter("groupId")); int sex=Integer.parseInt(request.getParameter("sex")); int relationLevel=Integer.parseInt(request.getParameter("relationLevel")); String photo=request.getParameter("photo"); String phone=request.getParameter("phone"); String email=request.getParameter("email"); String graduateFrom=request.getParameter("graduateFrom"); String major=request.getParameter("major"); String company=request.getParameter("company"); String job=request.getParameter("job"); String expectedJob=request.getParameter("expectedJob"); String music=request.getParameter("music"); String movie=request.getParameter("movie"), book=request.getParameter("book"), travel=request.getParameter("travel"), food=request.getParameter("food"), digitalProduct=request.getParameter("digitalProduct"), star=request.getParameter("star"), sport=request.getParameter("sport"); String sql="insert into friends(name,birthday,livenow,resume,groupid,sex,relationLevel,photo,phone,email,hometown,graduateFrom,major,company,job,expectedJob," + "music,movie,book,travel,food,digitalProduct,star,sport) " + "values('"+name+"','"+birthday+"','"+livenow+"','"+resume+"','"+groupId+"'" + ",'"+sex+"','"+relationLevel+"','"+photo+"','"+phone+"','"+email+"'" + ",'"+hometown+"','"+graduateFrom+"','"+major+"','"+company+"','"+job+"','"+expectedJob+"','"+music+"'" + ",'"+movie+"','"+book+"','"+travel+"','"+food+"','"+digitalProduct+"','"+star+"','"+sport+"')"; try { stat.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } //System.out.println("执行"+sql); request.setAttribute("notice", "插入数据："+name+birthday+livenow+resume); request.getRequestDispatcher("/addFriend.jsp").forward(request, response); } }