Retrieving Form Elements – textfield

Posted on by hrthaker

form.html

<HTML>
<BODY>
 <FORM ACTION="getfield.jsp" METHOD="POST">
 Name:
 <INPUT TYPE="TEXT" NAME="text1">
 <BR>
 <INPUT TYPE="SUBMIT" value="Submit">
 </FORM>
 </BODY>
<HTML>

getfield.jsp

<HTML>
<BODY>
 Your name is
 <% out.println(request.getParameter("text1")); %>
 </BODY>
</HTML>

JDBC Callable Statement example (Calling stored procedure of oracle)

Posted on by hrthaker

stored procedure

CREATE OR REPLACE
PROCEDURE GETEMPLOYEEINFO
( ENO IN VARCHAR2
, OUT_NAME OUT VARCHAR2
, OUT_JOB OUT VARCHAR2
, OUT_SAL OUT VARCHAR2
) AS
BEGIN
  
  SELECT ENAME,JOB,SAL INTO OUT_NAME,OUT_JOB,OUT_SAL 
  FROM EMP WHERE EMPNO=ENO;
EXCEPTION
      WHEN NO_DATA_FOUND THEN
        OUT_NAME := NULL;
END;

package mypackage;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;

public class OracleCallableDemo extends HttpServlet
{
	public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException
	{
		PrintWriter out = res.getWriter();
		res.setContentType("text/html");
		try
		{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			String url = "jdbc:oracle:thin:@//localhost:1521/orcl";
			String unm = "scott";
			String pwd = "tiger";
			Connection con = DriverManager.getConnection(url,unm,pwd);
			CallableStatement cstmt = 
			con.prepareCall("{call GETEMPLOYEEINFO(?,?,?,?)}");
			cstmt.setInt(1,1111);
			cstmt.registerOutParameter(2,java.sql.Types.VARCHAR);
			cstmt.registerOutParameter(3,java.sql.Types.VARCHAR);
			cstmt.registerOutParameter(4,java.sql.Types.INTEGER);
			cstmt.execute();
			
			if (cstmt.getString(2)!=null)
			{
				out.print (cstmt.getString(2) + " " + cstmt.getString(3) + " " + 
				cstmt.getInt(4));
			}
			else
			{
				out.print ("No record found");
			}
			
		}
		catch(Exception e)
		{
			out.print (e);
		}
	}
}