pathan jilani
1 Answer(s) 2 years and 3 months ago
Posted in : JSP-Servlet
hai friends i am doing a web application in that i have a registration page, after successfully registered it has to display a message like "you have successfully registered" and those values should be saved in to the database.but i am getting an exception like "not enough values" can you please assist how to get rid of this problem what problem i have done if you want i can send sample code.
mycodeimport java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class RNewReg extends HttpServlet
{
public void doGet(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException
{
PrintWriter out=res.getWriter();
res.setContentType("text/html");
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection c=DriverManager.getConnection("jdbc:odbc:online","system","manager");
Statement st=c.createStatement();
String user=req.getParameter("uid");
String passwd=req.getParameter("pw");
String repass=req.getParameter("rpw");
String fname=req.getParameter("fname");
String mname=req.getParameter("mnane");
String lname=req.getParameter("lname");
int mobile=Integer.parseInt(req.getParameter("mobile"));
int land=Integer.parseInt(req.getParameter("land"));
String email=req.getParameter("email");
String empid=req.getParameter("empid");
String compemail=req.getParameter("compemail");
ResultSet rs=st.executeQuery("select userid from RUsersInfo");
boolean exist=false;
while(rs.next())
{
if(rs.getString(1).equals(user))
exist=true;
}
out.println("<html>");
if(exist==false)
{
int i=st.executeUpdate("insert into rusersInfo values('" + user +"','" + passwd + "','"+repass+"," + fname + "','" + mname + "','" + lname + "','" + mobile + "','"+ land+"','" + email+"','"+ empid + "','" + compemail + "')");
out.println("<body bgcolor=\"lightyellow\">");
out.println("<form action=\"./regusers.html\">");
out.println("<font size=4 color=blue>");
out.println(user + " is Created");
out.println("<br><input type=submit name=b2 value=Next>");
out.println("</font></form></body>");
}
else
{
out.println("<body bgcolor=lightyellow><font size=4 color=red> Sorry!. An User with " + user +
" is already existing.Please Choose another login ID.");
out.println("<br><a href=\"newusers.html\">Back..</a>");
out.println("</font></body>");
}
out.println("</html>");
st.close();
c.close();
}
catch(Exception e)
{
out.println(e.toString());
}
}
public void doPost(HttpServletRequest req,HttpServletResponse res)
throws ServletException,IOException
{
doGet(req,res);
}
}
February 8, 2011 at 11:42 AM
Connect Servlet with database and insert data
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class InsertServlet extends HttpServlet {
public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException {
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String name=req.getParameter("name");
String pass=req.getParameter("pass");
String address=req.getParameter("address");
int no=Integer.parseInt(req.getParameter("no"));
String gender=req.getParameter("gender");
String country=req.getParameter("country");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
int i=st.executeUpdate("insert into mail(name,password,address,telno,gender,country) values('"+name+"','"+pass+"','"+address+"',"+no+",'"+gender+"','"+country+"')");
out.println("Data is inserted successfully");
con.close();
}
catch(Exception e){
System.out.println(e);
}
}
}
For more information, visit the following link:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
