Hello Sir,
when I insert the parameter in run time, weblogic server and JSP show that parameter are saved.
Allthough row increment in database but they not show in database.
Here My Code:
login.html:
<html>
<head>
<title>A simple JSP application</title>
<head>
<body>
<form method="get" action="tmp" >
Name: <input type="text" name="user">
Password: <input type="password" name="pass">
<input type="Submit" value="Submit">
</form>
</body>
</html>
LoginServlet.java:
import javax.servlet.*;
import javax.servlet.http.*;
public class LoginServlet extends HttpServlet{
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException{
try
{
String user=request.getParameter("user");
String pass=request.getParameter("pass");
co.SimpleBean st = new co.SimpleBean();
st.setuserName(user);
st.setpassword(pass);
request.setAttribute("user",st);
request.setAttribute("pass",st);
RequestDispatcher dispatcher1 =request.getRequestDispatcher("submit.jsp");
dispatcher1.forward(request,response);
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
SimpleBean.java:
package co;
import java.util.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.*;
public class SimpleBean {
private String user="";
private String pass="";
private String s="";
public String getuserName() {
return user;
}
public void setuserName(String user) {
this.user = user;
}
public String getpassword() {
return pass;
}
public void setpassword(String Pass) {
this.pass= pass ;
}
public String issueData()
{
try
{
System.out.println("Printed*************************************************************");
Class.forName("oracle.jdbc.driver.OracleDriver");
System.out.println("Connection loaded");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@VijayKumar-PC:1521:XE","SYSTEM","SYSTEM");
System.out.println("Connection created");
PreparedStatement st=con.prepareStatement("insert into vij2 values(?,?)");
System.out.println("~~~~~~~~~~~~~~~~~~~~");
String NAME=getuserName();
st.setString(1,NAME);
String PASSWORD=getpassword();
st.setString(2,PASSWORD);
st.executeUpdate();
System.out.println("Query Executed");
con.close();
s= "Your logging is saved in DB ";
System.out.println("Your logging is saved in DB *****************");
return(s);
}
catch(Exception e)
{
e.printStackTrace();
return "failed";
}
}
}
submit.jsp:
This is Submit page
<jsp:useBean id="st" class="co.SimpleBean"/>
<jsp:setProperty name="st" property="*" />
<jsp:getProperty name="st" property="userName" /> <br>
<jsp:getProperty name="st" property="password" /> <br>
<% st.issueData();%>
<%
out.println("Ur data is saved in DB");
%>
Please Help me.
Thanks.