Latest ads

Electronics
Vehicles
Property
Search

Servlet JDBC help

rock pora

rock pora

Well-known member
  • May 18, 2011
    11,951
    2,791
    113
    ###~.:::.සියනෑ කෝරළේ.::.~##
    Ane bn meke validation venne nane
    1st if eka vitharai true venne
    anith eva true venna hadala dammata true venne na

    Code: 
    import java.sql.*;
import java.io.*;

import javax.servlet.*;
import javax.servlet.http.*;

public class registration extends HttpServlet {

protected void doPost(HttpServletRequest request,HttpServletResponse response)throws ServletException,IOException {
     response.setContentType("text/html");
   PrintWriter out = response.getWriter();
     try{
         
         
         String fname =request.getParameter("fname");
         String lname =request.getParameter("lname");
         String email =request.getParameter("email");
         String uname =request.getParameter("uname");
         String pwd =request.getParameter("pass");
         String cpwd =request.getParameter("cpass");
         Class.forName("com.mysql.jdbc.Driver");
         Connection con =DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb1","root","root");
         Statement st =con.createStatement();
         //Statement st2 =con.createStatement();
         ResultSet rs2,rs1;
         
         
         rs1=st.executeQuery("Select * from tb1  where email='"+email+"'");
         rs2=st.executeQuery("Select * from tb1  where uname='"+uname+"'");
         
         
         
         
      
         if(fname.equals("") || lname.equals("") || email.equals("") || uname.equals("") || pwd.equals("")  ){
              out.println("Fill all the fields");
              
              
         }
            if(rs1.next()){
                out.println("Email already registered,try differenet one");
                
            }
            if(rs2.next()){
                out.println("UserName already registered,try differenet one"); 
                
            }
                
            if(!pwd.equals(cpwd)) {
                   out.println("Comfirmation password is not correct"); 
                   
            }
         else{
             int i=st.executeUpdate("insert into tb1(first_name, last_name, email, uname, pass, regdate) values ('" + fname + "','" + lname + "','" + email + "','" + uname + "','" + pwd + "', CURDATE())");
                if (i > 0) {
       
                 response.sendRedirect("welcome.jsp");
       
                }else {
                 response.sendRedirect("index.html");
         }
         }
         
              
             }
      
     catch(SQLException e){
         e.printStackTrace();
     }
     catch(Exception s){
         s.printStackTrace();
     }

   }
}
    mokadda awla kiyapankoooo
     
    විල්සන් මාමා

    විල්සන් මාමා

    Well-known member
  • Apr 2, 2012
    3,392
    845
    113
    දගයාගේ ගේ ගාව
    Code: 
    [COLOR=Blue]rs1.last() [/COLOR]
if([COLOR=Blue]rs1.getRow()>0[/COLOR]){         
        out.println("Email already registered,try differenet one");        
  }
[COLOR=Blue]rs1.beforeFirst();[/COLOR]
[COLOR=Blue]rs2.last()[/COLOR]
 if([COLOR=Blue]rs2.getRow()>0[/COLOR]){         
        out.println("UserName already registered,try differenet one");                }
rs2.beforeFirst();

if(!pwd.equals([COLOR=Blue]"cpwd"[/COLOR])) {         
           out.println("Comfirmation password is not correct");                         }
    Meka poddak try karala balanna :D
     
    Last edited:
    sajithswa

    sajithswa

    Active member
  • Dec 24, 2007
    120
    46
    28
    Code: 
    import java.sql.*;
import java.io.*;

import javax.servlet.*;
import javax.servlet.http.*;

public class registration extends HttpServlet {

    protected void doPost(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        try {

            String fname = request.getParameter("fname");
            String lname = request.getParameter("lname");
            String email = request.getParameter("email");
            String uname = request.getParameter("uname");
            String pwd = request.getParameter("pass");
            String cpwd = request.getParameter("cpass");
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/mydb1", "root", "root");
            Statement st = con.createStatement();
            // Statement st2 =con.createStatement();
            ResultSet rs2, rs1;

[COLOR=RoyalBlue]            System.out.println("request Parameter email ->" + email);
            System.out.println("request Parameter uname ->" + uname);[/COLOR]
            
[COLOR=RoyalBlue]            String selectEmailQuery = "Select * from tb1  where email='" + email + "'";
            String selectuserNameQuery = "Select * from tb1  where uname='" + uname + "'";
            
            System.out.println("selectEmailQuery ->" + selectEmailQuery);
            System.out.println("selectuserNameQuery ->" + selectuserNameQuery);
            
            rs1 = st.executeQuery(selectEmailQuery);
            rs2 = st.executeQuery(selectuserNameQuery);[/COLOR]

            if (fname.equals("") || lname.equals("") || email.equals("")
                    || uname.equals("") || pwd.equals("")) {
                out.println("Fill all the fields");

            }
            if (rs1.next()) {
                out.println("Email already registered,try differenet one");

            }
            if (rs2.next()) {
                out.println("UserName already registered,try differenet one");

            }

            if (!pwd.equals(cpwd)) {
                out.println("Comfirmation password is not correct");

            } else {
                int i = st
                        .executeUpdate("insert into tb1(first_name, last_name, email, uname, pass, regdate) values ('"
                                + fname
                                + "','"
                                + lname
                                + "','"
                                + email
                                + "','"
                                + uname + "','" + pwd + "', CURDATE())");
                if (i > 0) {

                    response.sendRedirect("welcome.jsp");

                } else {
                    response.sendRedirect("index.html");
                }
            }

        }

        catch (SQLException e) {
            e.printStackTrace();
        } catch (Exception s) {
            s.printStackTrace();
        }

    }
}

    Debug the code. Find the request Parameter email and request Parameter uname. Copy and past sql query in mysql client and find out result of those. Always close the DB connection. You can use finally block. :yes::yes::yes::yes::yes:
     
    විල්සන් මාමා

    විල්සන් මාමා

    Well-known member
  • Apr 2, 2012
    3,392
    845
    113
    දගයාගේ ගේ ගාව
    Machan ube IF-Else tikak waradi ne.
    Code: 
     if(!pwd.equals(cpwd)) {                    out.println("Comfirmation password is not correct");                                  }
    Menna meka true wunoth witarai ne else eka wada karanne natte.
    Habai ube Email already registered wage validation errors pennuwath ara ELSE ekata enawa ne. awilla insert eka wenawa ne. Mokada ube ELSE ekata enne natte Confirmation password kiyana IF eka true wunoth witarai. Eka gana poddak hitapan.    :yes:
     
    rock pora

    rock pora

    Well-known member
  • May 18, 2011
    11,951
    2,791
    113
    ###~.:::.සියනෑ කෝරළේ.::.~##
    sajithswa said:
    Code: 
    import java.sql.*;
import java.io.*;

import javax.servlet.*;
import javax.servlet.http.*;

public class registration extends HttpServlet {

    protected void doPost(HttpServletRequest request,
            HttpServletResponse response) throws ServletException, IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        try {

            String fname = request.getParameter("fname");
            String lname = request.getParameter("lname");
            String email = request.getParameter("email");
            String uname = request.getParameter("uname");
            String pwd = request.getParameter("pass");
            String cpwd = request.getParameter("cpass");
            Class.forName("com.mysql.jdbc.Driver");
            Connection con = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/mydb1", "root", "root");
            Statement st = con.createStatement();
            // Statement st2 =con.createStatement();
            ResultSet rs2, rs1;

[COLOR=RoyalBlue]            System.out.println("request Parameter email ->" + email);
            System.out.println("request Parameter uname ->" + uname);[/COLOR]
            
[COLOR=RoyalBlue]            String selectEmailQuery = "Select * from tb1  where email='" + email + "'";
            String selectuserNameQuery = "Select * from tb1  where uname='" + uname + "'";
            
            System.out.println("selectEmailQuery ->" + selectEmailQuery);
            System.out.println("selectuserNameQuery ->" + selectuserNameQuery);
            
            rs1 = st.executeQuery(selectEmailQuery);
            rs2 = st.executeQuery(selectuserNameQuery);[/COLOR]

            if (fname.equals("") || lname.equals("") || email.equals("")
                    || uname.equals("") || pwd.equals("")) {
                out.println("Fill all the fields");

            }
            if (rs1.next()) {
                out.println("Email already registered,try differenet one");

            }
            if (rs2.next()) {
                out.println("UserName already registered,try differenet one");

            }

            if (!pwd.equals(cpwd)) {
                out.println("Comfirmation password is not correct");

            } else {
                int i = st
                        .executeUpdate("insert into tb1(first_name, last_name, email, uname, pass, regdate) values ('"
                                + fname
                                + "','"
                                + lname
                                + "','"
                                + email
                                + "','"
                                + uname + "','" + pwd + "', CURDATE())");
                if (i > 0) {

                    response.sendRedirect("welcome.jsp");

                } else {
                    response.sendRedirect("index.html");
                }
            }

        }

        catch (SQLException e) {
            e.printStackTrace();
        } catch (Exception s) {
            s.printStackTrace();
        }

    }
}
    Debug the code. Find the request Parameter email and request Parameter uname. Copy and past sql query in mysql client and find out result of those. Always close the DB connection. You can use finally block. :yes::yes::yes::yes::yes:
    Click to expand...
    dude this is not exception handling or parameters problem,I found da bug.Itz having in JDBC codes.cant use 1 statement object to many resultSet objcts.thatz da bug :) anyway thanx for your comment



    විල්සන් මාමා;17272555 said:
    Code: 
    [COLOR=Blue]rs1.last() [/COLOR]
if([COLOR=Blue]rs1.getRow()>0[/COLOR]){         
        out.println("Email already registered,try differenet one");        
  }
[COLOR=Blue]rs1.beforeFirst();[/COLOR]
[COLOR=Blue]rs2.last()[/COLOR]
 if([COLOR=Blue]rs2.getRow()>0[/COLOR]){         
        out.println("UserName already registered,try differenet one");                }
rs2.beforeFirst();

if(!pwd.equals([COLOR=Blue]"cpwd"[/COLOR])) {         
           out.println("Comfirmation password is not correct");                         }
    Meka poddak try karala balanna :D
    Click to expand...

    විල්සන් මාමා;17272587 said:
    Machan ube IF-Else tikak waradi ne.
    Code: 
     if(!pwd.equals(cpwd)) {                    out.println("Comfirmation password is not correct");                                  }
    Menna meka true wunoth witarai ne else eka wada karanne natte.
    Habai ube Email already registered wage validation errors pennuwath ara ELSE ekata enawa ne. awilla insert eka wenawa ne. Mokada ube ELSE ekata enne natte Confirmation password kiyana IF eka true wunoth witarai. Eka gana poddak hitapan.    :yes:
    Click to expand...

    macho ube ara kalin ek amn try karala balannam bn.eke methods tika dalath balanna one bn.mn eka danan unne na bn thanx ah :)

    else case eke awlak na bn.
    servlet eke 1st if eka true unoth eke kiyala thiyena error eka display venava.java script vala vage okkoma tika yanne na bn.javascript vala vidiyatath nemei meka venne. thava tikak balannam.mn issellama damme uba kiyana vidiyata thama bn.ethakota athule evata giye nadda koheda.:yes::yes:
     
    විල්සන් මාමා

    විල්සන් මාමා

    Well-known member
  • Apr 2, 2012
    3,392
    845
    113
    දගයාගේ ගේ ගාව
    rock pora said:
    macho ube ara kalin ek amn try karala balannam bn.eke methods tika dalath balanna one bn.mn eka danan unne na bn thanx ah :)

    else case eke awlak na bn.
    servlet eke 1st if eka true unoth eke kiyala thiyena error eka display venava.java script vala vage okkoma tika yanne na bn.javascript vala vidiyatath nemei meka venne. thava tikak balannam.mn issellama damme uba kiyana vidiyata thama bn.ethakota athule evata giye nadda koheda.:yes::yes:
    Click to expand...
    ela ela :D
     
    sajithswa

    sajithswa

    Active member
  • Dec 24, 2007
    120
    46
    28
    rock pora said:
    dude this is not exception handling or parameters problem,I found da bug.Itz having in JDBC codes.cant use 1 statement object to many resultSet objcts.thatz da bug :) anyway thanx for your comment
    Click to expand...

    Ane ban ehenam post eka dapan code eken exception ekak paninawa kiyala. Validation venne ne kiyanne nethuwa. Uba validation wenne ne kuwa nisa thama mm ehema replay kale.
    Docata boru kiyala beheth ganna beri bawa mathaka thiya ganin. :P

    p.s. - Ubata exception ekath print wenna athine neda? :P
     
    rock pora

    rock pora

    Well-known member
  • May 18, 2011
    11,951
    2,791
    113
    ###~.:::.සියනෑ කෝරළේ.::.~##
    sajithswa said:
    Ane ban ehenam post eka dapan code eken exception ekak paninawa kiyala. Validation venne ne kiyanne nethuwa. Uba validation wenne ne kuwa nisa thama mm ehema replay kale.
    Docata boru kiyala beheth ganna beri bawa mathaka thiya ganin. :P

    p.s. - Ubata exception ekath print wenna athine neda? :P
    Click to expand...
    ithin bn mn thread eka damme servlet JDBC kiyalane :D
    eke awla thibbe eka statement 1n resultsets dekak use karapu ekai bn
    uba yatin nil patin highlight karala thibba tika dakke dan pass bn :D
    tharaha ganna epa ithinn ;)
     
    හෙළයෙක්

    හෙළයෙක්

    Well-known member
  • Apr 26, 2014
    48,460
    98,391
    113
    rock pora said:
    ela ela bn :D sathi ganak adda bn oka:rofl:
    Click to expand...
    ehema thama eka paratama owa goda dana be. samahara errors masa1,2 adala thiyenawa ahagana kauruwath nathuwa. mama oka balan ne hadana widiya kiyannan.

    1. Null values enwada check karana.
    2. athatama ena values moanwada kiyala sout gahala hari kamak ne hoya gana ita pase ewa thaman compare karana.
    3. ita pase condition sout walata dala eka eka values input karala balana true false enawada kiyala.

    eka eka ewa anuwa wenas wenawa errors hoyana widiya, meka thama okata karana thiyena weda tika.

    hema ekama mehema thread dala ahana epa. search karalama try karana barima nan witarak ahana. nathan oka purudakata yanawa. ape office eketh ehema kenek awa mula mase patta anayak una pase dan hadala aran thiyene. ubatath oka purudu wenawa.

    oya try karana tharamata wede goda dana puluwan hakiyawa oyage wedi weanwa. ekama wede dethun parakata karala balana hari yanakan.
    nathuwa oka karana be. ehema ahana purudu unama ube weda slow wenawa henatama, amaruwen 3yr adapan ita pase errors kiyana ewa dakinakota solve karana puluwan.
     
    rock pora

    rock pora

    Well-known member
  • May 18, 2011
    11,951
    2,791
    113
    ###~.:::.සියනෑ කෝරළේ.::.~##
    හෙළයෙක්;17273564 said:
    ehema thama eka paratama owa goda dana be. samahara errors masa1,2 adala thiyenawa ahagana kauruwath nathuwa. mama oka balan ne hadana widiya kiyannan.

    1. Null values enwada check karana.
    2. athatama ena values moanwada kiyala sout gahala hari kamak ne hoya gana ita pase ewa thaman compare karana.
    3. ita pase condition sout walata dala eka eka values input karala balana true false enawada kiyala.

    eka eka ewa anuwa wenas wenawa errors hoyana widiya, meka thama okata karana thiyena weda tika.

    hema ekama mehema thread dala ahana epa. search karalama try karana barima nan witarak ahana. nathan oka purudakata yanawa. ape office eketh ehema kenek awa mula mase patta anayak una pase dan hadala aran thiyene. ubatath oka purudu wenawa.

    oya try karana tharamata wede goda dana puluwan hakiyawa oyage wedi weanwa. ekama wede dethun parakata karala balana hari yanakan.
    nathuwa oka karana be. ehema ahana purudu unama ube weda slow wenawa henatama, amaruwen 3yr adapan ita pase errors kiyana ewa dakinakota solve karana puluwan.
    Click to expand...

    හෙළයෙක්;17273572 said:
    = noda like eka dala balapan wedada kiyala. ita pase weda kare nethan row eka print karala balana values match wenawada kiyala.
    Click to expand...

    macho mn uba kiyana vidiyata thama bn sathiyakma check kale.ehema code ekak hamba una gaman thread dala ahanne na bn :rofl:
    barima thana thama bn vena kenekgen ahanne.mata meka vb.net vala db connect karapu vidiyath ekka patalila bn thibbe.

    ada ude thama vade ahu une bn.eka eka vidiyata kara :D

    eka statement ekakin resultSets godak use karanna barida bn??
    ai mevage if condtion eka athule == danna barida
    if(fname == name) vage ohoma dammata mokuth venne nane bn


    uba kiyana kathava attha bn thaniyama kalama thama bn godak deval ahu venne.siravata mata me project eka adagena yaddi marama deval set ekak danagattha bn.nathnm basic valata karana podi examples karala ova allanna ba bn..
     

    Similar threads

    rudr@
    netbeans login help
    Replies
    16
    Views
    1K
    rudr@
    rudr@
    rock pora
    Java Beans,JSP,Servlets help
    Replies
    68
    Views
    7K
    rock pora
    rock pora
    A
    Java Help!
    Replies
    16
    Views
    2K
    niyomax
    niyomax
    sachi911
    Android, JAVA ListView Help
    Replies
    1
    Views
    621
    hodakolla
    hodakolla
    J Sparrow
    java web development 8 කොටස - Hibernate
    Replies
    43
    Views
    8K
    whiteskull
    whiteskull
    Top Bottom