Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package tel.servlets;
- import java.io.IOException;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- import javax.servlet.http.HttpSession;
- import tel.beans.UserData;
- public class ProcessUser extends HttpServlet {
- private static final String ACTION_PARAM = "action";
- private static final String INSERT = "insert";
- private static final String SHOWALL = "showall";
- private static final String SELECTUSER = "selectuser";
- private static final String FORWARD_PARAM = "forward";
- private static final String ERROR_PAGE = "error.jsp";
- private static final String USER_BEAN ="user";
- private static final String ALLUSER_BEAN ="allusers";
- private Connection connection;
- protected void doGet(HttpServletRequest request, HttpServletResponse response)
- throws IOException {
- HttpSession session = request.getSession();
- UserData user = (UserData) session.getAttribute(USER_BEAN);
- if(INSERT.equals(request.getParameter(ACTION_PARAM))){
- //User überprüfen
- System.out.println("INSERT");
- }else if(SELECTUSER.equals(request.getParameter(ACTION_PARAM))){
- //User in DB suchen
- System.out.println("SELECTUSER");
- }
- else if(SHOWALL.equals(request.getParameter(ACTION_PARAM))){
- //Auslesen aller User
- System.out.println("SHOWALL");
- }
- else{
- //weitere actions implementieren
- System.out.println(request.getParameter(ACTION_PARAM));
- }
- String forward = request.getParameter(FORWARD_PARAM);
- if(forward == null){
- forward = ERROR_PAGE;
- }
- response.sendRedirect(forward);
- /*if( user == null ) {
- user = new UserData();
- session.setAttribute("user", user);
- }
- // Benutzereingaben validieren
- if( user.getFirstname() != null && !"".equals(user.getFirstname().trim()) &&
- user.getLastname() != null && !"".equals(user.getLastname().trim()) ) {
- // Benutzer in DB schreiben oder updaten
- response.sendRedirect("showuser.jsp");
- } else {
- // Eingaben nicht korrekt
- response.sendRedirect("userform.jsp");
- }
- */
- }
- protected void doPost(HttpServletRequest request, HttpServletResponse response)
- throws IOException {
- doGet(request, response);
- }
- public void init(){
- String dburl="jdbc:mysql://localhost:3306";
- String dbschema ="userapp";
- String dbuser ="manu";
- String dbpwd="manu";
- System.out.println("init started");
- try{
- Class.forName("com.mysql.jdbc.Driver");
- connection = DriverManager.getConnection(dburl, dbuser, dbpwd);
- System.out.println("connection started");
- }catch(ClassNotFoundException e){
- System.out.println("driver not found");
- throw new RuntimeException(e);
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement