Hello.jsp
<%@page language="Java" %>
<html>
<body>
<% out.println("<b> Its a Hello From the JSP World! </b></br><hr>"); %>
<form method="POST" action="setCookie.jsp">
Enter Your Name : <input type='text' name='username' /></br>
<input type='submit' />
</form>
</body>
</html>
SetCookie.jsp
<%@page language="java" import="java.util.*" %>
<%
String username=request.getParameter("username");
if(username==null) username="nothing";
Cookie cookie=new Cookie("username",username);
response.addCookie(cookie);
%>
<html>
<head>
<title>Cookie Saved</title>
</head>
<body>
<p><a href="showcookievalue.jsp">Next Page to view the cookie Value</a><p>
</body>
</html>
showcookievalue.jsp
<%@page language="java" %>
<%
String cookieName="username";
Cookie cookies[]=request.getCookies();
Cookie myCookie=null;
if(cookies!=null)
{
for(int i=0;i<cookies.length;i++)
{
if(cookies[i].getName().equals(cookieName))
{
myCookie=cookies[i];
break;
}
}
}
%>
<html>
<head>
<title>Show saved Cookie </title>
</head>
<body>
<%
if(myCookie==null)
{
%>
No Cookie found with the name<%=cookieName%>
<%
}
else
{
%>
<p>Welcome : <%="<b>"+myCookie.getValue()+"</b>"%>
<%
}
%>
</body>
</html>
NOTE : Has practised from : http://www.roseindia.net/jsp/jspcookies.shtml
Saturday, October 6, 2007
Saturday, September 15, 2007
How foreign key can have null values where as primary key can't have?
How foreign key can have null values where as primary key can't have?
--------------------------------------------------------------------------------
the Trick here is to create the key as a unique key :
create table dept_1
(
deptno number,
dname varchar2(10)
)
alter table dept_1 add constraint uq_1 unique(deptno);
create emp_1
(
empno number,
ename varchar2(20),
deptno number references dept_1(deptno)
)
insert into dept_1 values(10,'ope');
insert into dept_1 values(null,'Hyd');
SQL> select * from dept_1;
DEPTNO DNAME
--------- --------------------
10 ope
Hyd
insert into emp_1 values(10,'Ajith',null);
insert into emp_1 values(10,'Ajith',20); -- Violates constraint
insert into emp_1 values(10,'Ajith',10); -- Works
SQL> select * from emp_1;
EMPNO ENAME DEPTNO
--------- ---------- ---------
10 Ajith
10 Ajith 10
--------------------------------------------------------------------------------
the Trick here is to create the key as a unique key :
create table dept_1
(
deptno number,
dname varchar2(10)
)
alter table dept_1 add constraint uq_1 unique(deptno);
create emp_1
(
empno number,
ename varchar2(20),
deptno number references dept_1(deptno)
)
insert into dept_1 values(10,'ope');
insert into dept_1 values(null,'Hyd');
SQL> select * from dept_1;
DEPTNO DNAME
--------- --------------------
10 ope
Hyd
insert into emp_1 values(10,'Ajith',null);
insert into emp_1 values(10,'Ajith',20); -- Violates constraint
insert into emp_1 values(10,'Ajith',10); -- Works
SQL> select * from emp_1;
EMPNO ENAME DEPTNO
--------- ---------- ---------
10 Ajith
10 Ajith 10
Thursday, August 30, 2007
Persist data in the form to recreate using same data
<html>
<head>
</head>
<BODY bgcolor=LightGoldenrodYellow>
<script type="text/javascript" language="javascript">
function fillVals(col_var_arr,val_i)
{
//document.frm_Objects.v_column_name.value();
var coll_1=document.getElementsByName("v_column_name");
//alert(coll_obj.length);
//for(var i=0;i<col_var_arr.length;i++)
//{
if(col_var_arr==undefined||val_i==undefined)
{
//do nothing
}
else
{
str_tmp="";
// str_tmp="document.frm_Objects.v_column_value"+val_i+".value='"+col_var_arr+"';";
// alert(str_tmp);
// eval(str_tmp);
str_tmp="document.frm_Objects.v_column_value["+val_i+"].value='"+col_var_arr+"';";;
// alert(str_tmp);
eval(str_tmp);
//alert(str_tmp);
}
//}
}
</script>
<%@ page language="java" import="java.sql.*,java.io.*,java.util.*,SQLUTF.*" %>
<%
// Cokumn Count
//int col_count;
//String get_col_count=null;
//get_col_count=request.getParameter("col_count");
//int col_count;
/*if(get_col_count==null)
{
col_count=0;
}
else
{
col_count=Integer.parseInt(request.getParameter("col_count"));
}
*/
//Enumeration e=request.getParameters();
// Gets all parameter values
String[] col_var=request.getParameterValues("v_column_value");
String button_val=request.getParameter("submit");
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con;
int flag=0;
//con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:AMOORCL","hr","hr");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:AMOORCL","scott","tiger");
//con=DriverManager.getConnection("jdbc:oracle:thin:@ap6267rt.us.oracle.com:1612:PQD12MS1","apps","pqeapps");
//con=DriverManager.getConnection("jdbc:oracle:thin:@ap6264rt.us.oracle.com:1617:PQD12MS1","apps","pqeapps");
PreparedStatement stmt;
ResultSet rs;
ResultSetMetaData rsmd;
%>
<form name="frm_Objects" >
<table border=1>
<%
//stmt=con.prepareStatement("SELECT column_name,data_type,data_length,data_precision,nullable FROM all_tab_cols where table_name = 'emp'");
stmt=con.prepareStatement("SELECT column_name,data_type,data_length,data_precision,nullable FROM all_tab_cols where table_name = 'DEPT'");
flag=0;
rs=stmt.executeQuery();
//Printing volumn names using meta data
rsmd=rs.getMetaData();
int numcols=rsmd.getColumnCount();
%>
<%= "<TR>" %>
<%
for(int i=1;i<=numcols;i++)
{
%>
<%= "<TH align='center'> <font color=blue>"+rsmd.getColumnLabel(i)+"</font></TH>" %>
<%
}
%>
<%= "<TH aligh='center'> <font color=blue>ENTER VALUE</font></TH></TR>" %>
<%
// Closing result set meta data
// Printing Argument Names
while(rs.next())
{
String getColumnName= rs.getString(1);
String getDataType=rs.getString(2);
String getDataLength=rs.getString(3);
String getPrecision=rs.getString(4);
String getNullable=rs.getString(5);
%>
<%= "<tr align='center'><td><input type='text' name='v_column_name' readonly='true' value='"+getColumnName+"'/></td>"%>
<%= "<td><input type='text' name='v_data_type' readonly='true' value='"+getDataType+"' /></td>"%>
<%= "<td><input type='text' name='v_data_length' readonly='true' value='"+getDataLength+"' /></td>"%>
<%= "<td><input type='text' name='v_data_precision' readonly='true' value='"+getPrecision+"' /></td>"%>
<%= "<td><input type='text' name='v_nullable' readonly='true' value='"+getNullable+"' /></td>"%>
<%= "<td><input type='text' name='v_column_value' /></td>"%>
<%
}
rs.close();
}
catch(IOException e)
{
out.println("1 IOException Occurred : "+e);
}
catch(SQLException s)
{
out.println("2 SQLException Occurred : "+s);
}
catch(Exception e)
{
out.println("Exception Occurred : "+e);
}
%>
</table>
<input type="submit" name="submit" value="Clicked" />
<%
if(button_val!=null)
{
for(int i=0;i<col_var.length;i++)
// call javascript function passing the entire col_var
{
System.out.println("Length is : "+col_var.length);
%>
<%="<script language=\"javascript\">fillVals('"+col_var[i]+"','"+i+"');</script>"%>
<%
}
}
%>
</form>
</body>
</html>
<head>
</head>
<BODY bgcolor=LightGoldenrodYellow>
<script type="text/javascript" language="javascript">
function fillVals(col_var_arr,val_i)
{
//document.frm_Objects.v_column_name.value();
var coll_1=document.getElementsByName("v_column_name");
//alert(coll_obj.length);
//for(var i=0;i<col_var_arr.length;i++)
//{
if(col_var_arr==undefined||val_i==undefined)
{
//do nothing
}
else
{
str_tmp="";
// str_tmp="document.frm_Objects.v_column_value"+val_i+".value='"+col_var_arr+"';";
// alert(str_tmp);
// eval(str_tmp);
str_tmp="document.frm_Objects.v_column_value["+val_i+"].value='"+col_var_arr+"';";;
// alert(str_tmp);
eval(str_tmp);
//alert(str_tmp);
}
//}
}
</script>
<%@ page language="java" import="java.sql.*,java.io.*,java.util.*,SQLUTF.*" %>
<%
// Cokumn Count
//int col_count;
//String get_col_count=null;
//get_col_count=request.getParameter("col_count");
//int col_count;
/*if(get_col_count==null)
{
col_count=0;
}
else
{
col_count=Integer.parseInt(request.getParameter("col_count"));
}
*/
//Enumeration e=request.getParameters();
// Gets all parameter values
String[] col_var=request.getParameterValues("v_column_value");
String button_val=request.getParameter("submit");
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con;
int flag=0;
//con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:AMOORCL","hr","hr");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:AMOORCL","scott","tiger");
//con=DriverManager.getConnection("jdbc:oracle:thin:@ap6267rt.us.oracle.com:1612:PQD12MS1","apps","pqeapps");
//con=DriverManager.getConnection("jdbc:oracle:thin:@ap6264rt.us.oracle.com:1617:PQD12MS1","apps","pqeapps");
PreparedStatement stmt;
ResultSet rs;
ResultSetMetaData rsmd;
%>
<form name="frm_Objects" >
<table border=1>
<%
//stmt=con.prepareStatement("SELECT column_name,data_type,data_length,data_precision,nullable FROM all_tab_cols where table_name = 'emp'");
stmt=con.prepareStatement("SELECT column_name,data_type,data_length,data_precision,nullable FROM all_tab_cols where table_name = 'DEPT'");
flag=0;
rs=stmt.executeQuery();
//Printing volumn names using meta data
rsmd=rs.getMetaData();
int numcols=rsmd.getColumnCount();
%>
<%= "<TR>" %>
<%
for(int i=1;i<=numcols;i++)
{
%>
<%= "<TH align='center'> <font color=blue>"+rsmd.getColumnLabel(i)+"</font></TH>" %>
<%
}
%>
<%= "<TH aligh='center'> <font color=blue>ENTER VALUE</font></TH></TR>" %>
<%
// Closing result set meta data
// Printing Argument Names
while(rs.next())
{
String getColumnName= rs.getString(1);
String getDataType=rs.getString(2);
String getDataLength=rs.getString(3);
String getPrecision=rs.getString(4);
String getNullable=rs.getString(5);
%>
<%= "<tr align='center'><td><input type='text' name='v_column_name' readonly='true' value='"+getColumnName+"'/></td>"%>
<%= "<td><input type='text' name='v_data_type' readonly='true' value='"+getDataType+"' /></td>"%>
<%= "<td><input type='text' name='v_data_length' readonly='true' value='"+getDataLength+"' /></td>"%>
<%= "<td><input type='text' name='v_data_precision' readonly='true' value='"+getPrecision+"' /></td>"%>
<%= "<td><input type='text' name='v_nullable' readonly='true' value='"+getNullable+"' /></td>"%>
<%= "<td><input type='text' name='v_column_value' /></td>"%>
<%
}
rs.close();
}
catch(IOException e)
{
out.println("1 IOException Occurred : "+e);
}
catch(SQLException s)
{
out.println("2 SQLException Occurred : "+s);
}
catch(Exception e)
{
out.println("Exception Occurred : "+e);
}
%>
</table>
<input type="submit" name="submit" value="Clicked" />
<%
if(button_val!=null)
{
for(int i=0;i<col_var.length;i++)
// call javascript function passing the entire col_var
{
System.out.println("Length is : "+col_var.length);
%>
<%="<script language=\"javascript\">fillVals('"+col_var[i]+"','"+i+"');</script>"%>
<%
}
}
%>
</form>
</body>
</html>
Aug 30th - Project
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY bgcolor=LightGoldenrodYellow>
<%@ page language="java" import="java.sql.*,java.io.*,java.util.*" %>
<%
//Get all the variables in the variable block into array
// Trying to get the values and display after which it will be posted to the database
//Getting all param Names
Enumeration enum_param=request.getParameterNames();
Enumeration var_enum_param=request.getParameterNames();
String v_tmp_param_name=request.getParameter("v_var_name");
String v_tmp_param_value=request.getParameter("v_var_value");
String v_tmp_param_type=request.getParameter("v_var_type");
//Get Hidden field count
String v_tmp_hidden_glo_var=request.getParameter("v_glo_var_val");
if(v_tmp_hidden_glo_var==null)
{
v_tmp_hidden_glo_var="1";
}
//Get Parameters being passed
String v_object_name=request.getParameter("Obj_Names");
// Sub list for procedures of a package
String v_Obj_names_proc=request.getParameter("Obj_names_proc");
String v_object_type;
//String str;
v_object_type=request.getParameter("Obj_types");
Connection con=null;
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName("oracle.jdbc.driver.OracleDriver");
//con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:AMOORCL","hr","hr");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:AMOORCL","scott","tiger");
//con=DriverManager.getConnection("jdbc:oracle:thin:@ap6267rt.us.oracle.com:1612:PQD12MS1","apps","pqeapps");
//con=DriverManager.getConnection("jdbc:oracle:thin:@ap6264rt.us.oracle.com:1617:PQD12MS1","apps","pqeapps");
PreparedStatement stmt;
ResultSet rs;
ResultSetMetaData rsmd;
%>
<script type="text/javascript" language="javascript">
// object name should be nullfied
var v_flag=0;
function setObjNameNull()
{
//document.frm_Objects.Obj_Names.value=null;
//document.frm_Objects.usr_file_name.value=null;
//document.frm_Objects.usr_pre_qry_val.value=null;
//document.frm_Objects.usr_post_qry_val.value=null;
//document.frm_Objects.usr_file_name.value=null;
//document.frm_Objects.usr_pre_qry_val.value=null;
//document.frm_Objects.usr_post_qry_val.value=null;
//alert(document.frm_Objects.v_var_name==null||Obj_Names.value);
// If variable declaration block has null values
//if(typeof() == ‘undefined’)
if(document.frm_Objects.v_glo_var_val.value>1)
{
for(var i=1;i<=(document.frm_Objects.v_glo_var_val.value-1);i++)
{
//Alerting Blank value -- Use flag to submit it.
var v_name="document.frm_Objects.v_var_name";
var v_value="document.frm_Objects.v_var_value";
var v_type="document.frm_Objects.v_var_type";
// -1 as default value is 1 and other boxes should be count-1;
v_name=v_name+(document.frm_Objects.v_glo_var_val.value -1)+".value";
v_value=v_value+(document.frm_Objects.v_glo_var_val.value -1)+".value";
v_type=v_type+(document.frm_Objects.v_glo_var_val.value -1)+".value";
//alert(v_name);
if(v_name==null||v_value==null||v_type==null)
{
alert('Null values present');
v_flag=0;
}
else
{
v_flag=1;
}
}//for
if(v_flag==1)
{
document.frm_Objects.submit();
}
else
{
//Dont Submit;
}
}
else
{
document.frm_Objects.submit();
}
//Form Submission
/*document.frm_Objects.submit();
stmt=null;
rs=null; */
}
function setPkgObjNameNull()
{
if(document.frm_Objects.Obj_names_proc==null)
{
}else
{
document.frm_Objects.Obj_names_proc.value=null;
}
//document.frm_Objects.Obj_Names.value=null;
//alert(document.frm_Objects.Obj_Names.value);
document.frm_Objects.submit();
}
function AddField()
{
// Step 0 : Add check box if needed to delete the Variable
//Step 1 : Create a Variable Field
//Step 2 : Create a Value Field
//Step 3 : Create DataType Field
//////////////////////////////////////
//
//CODE CHANGE
//
/////////////////////////////////////
////////////////////////////////////////////
//
//
//OLD CODE THAT WORKED
//
//
///////////////////////////////////////////////
//var cnt=document.frm_Objects.v_glo_var_val.value;
//24th august -- considering Deleting Check Box
var new_element=document.createElement("<INPUT TYPE='checkbox' name='v_var_chk_name' />");
var_area.appendChild(new_element);
//Step 1 : Create a Variable Field
var_area.innerHTML=var_area.innerHTML+"Variable Name : ";
//var new_element=document.createElement("<INPUT TYPE='text' value='TextField' name='text1' />");
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_name' />");
var_area.appendChild(new_element);
//var_area.innerHTML=var_area.innerHTML+"</br>";
//Step 2 : Create a Value Field
var_area.innerHTML=var_area.innerHTML+"Variable Value : ";
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_value' />");
var_area.appendChild(new_element);
//var_area.innerHTML=var_area.innerHTML+"</br>";
//Step 3 : Create DataType Field
var_area.innerHTML=var_area.innerHTML+"Variable Type : ";
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_type' />");
var_area.appendChild(new_element);
var_area.innerHTML=var_area.innerHTML+"</br>";
document.frm_Objects.v_glo_var_val.value=++document.frm_Objects.v_glo_var_val.value;
}
//function AddField3(one,two,three)
function AddField3(one1,two1,three1)
{
var one=one1;
var two=two1;
var three=three1;
// Step 0 : Add check box if needed to delete the Variable
//Step 1 : Create a Variable Field
//Step 2 : Create a Value Field
//Step 3 : Create DataType Field
//var_area.innerHTML=var_area.innerHTML+"Variable Name : ";
//var new_element=document.createElement("<INPUT TYPE='text' value='TextField' name='text1' />");
var new_element=document.createElement("<INPUT TYPE='checkbox' name='v_var_chk_name' />");
var_area.appendChild(new_element);
//Step 1 : Create a Variable Field
var_area.innerHTML=var_area.innerHTML+"Variable Name : ";
//var new_element=document.createElement("<INPUT TYPE='text' value='TextField' name='text1' />");
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_name' value='"+one+"' />");
var_area.appendChild(new_element);
//var_area.innerHTML=var_area.innerHTML+"</br>";
//Step 2 : Create a Value Field
var_area.innerHTML=var_area.innerHTML+"Variable Value : ";
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_value' value='"+two+"' />");
var_area.appendChild(new_element);
//var_area.innerHTML=var_area.innerHTML+"</br>";
//Step 3 : Create DataType Field
var_area.innerHTML=var_area.innerHTML+"Variable Type : ";
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_type' value='"+three+"' />");
var_area.appendChild(new_element);
var_area.innerHTML=var_area.innerHTML+"</br>";
}
</script>
<!--
FORM
-->
<form name="frm_Objects" action="FirstPage_Table.jsp" method="GET">
<!--
Global variables Block
-->
<!-- hidden field used to store the number of variables being used -->
<%= "<input type='hidden' name='v_glo_var_val' value="+v_tmp_hidden_glo_var+" />" %>
<fieldset>
<legend>VARIABLE DECLARATION</legend>
<!--<form name="var_frm">-->
<div id="var_area"><!-- Fields created using java script -->
<!--// Write code to persist the values in the text boxes before writing to database -->
<!-- Call the AddField( value) -->
<%
// Added code to handle if no Variables are declared yet
if(v_tmp_param_name!=null||v_tmp_param_value!=null||v_tmp_param_type!=null)
{
System.out.println("------------------Start of Method :----------------");
//Retrieved object from enumeration, took it into a string and printed it
// Getting Parameter Names and Printing their Values
// First 3 variables will be of the type (var name, var value,var type)
int count=0;
//Enumeration e_temp=var_enum_param;
System.out.println("Count before elements :"+count);
Enumeration e_temp=request.getParameterNames();// Can modify to take values of only variable names
while(e_temp.hasMoreElements())
{
count=count+1;
Object obj=e_temp.nextElement();
}
// Count of Elements
System.out.println("Count of elements is :"+count);
// Counting number of parameters
String[] v_get_param_value_tmp=new String[count];
String[] v_get_param_value=new String[count];
// Adding code to handle if there are no check boxes
count=0;
String v_get_param_name;
while(var_enum_param.hasMoreElements())
{
Object obj=var_enum_param.nextElement();
v_get_param_name=obj.toString();
System.out.println("Element Retrieved is : "+v_get_param_name);
//count used for every 3 values submit
// If param value is v_value,type display it and its values
//get ParameterValues(String);
if(v_get_param_name.equals("v_var_name")||v_get_param_name.equals("v_var_value")||v_get_param_name.equals("v_var_type"))
{
//Get Parameter value
//Array to contain values of ParameterS
v_get_param_value=request.getParameterValues(v_get_param_name);
//System.out.println("Value of Variable Parameter is : "+v_get_param_value);
//addding values to array - Length would be 2
// Length of array is the set's of variables present ( 3 sets of name value and type )
// Order of adding is always 2 var name,2 value, 2 type
for(int i=0;i<v_get_param_value.length;i++)
{
v_get_param_value_tmp[count]=v_get_param_value[i];
System.out.println("Length "+v_get_param_value.length);
System.out.println(v_get_param_value_tmp[count]);
count=count+1;
// Display Value
}
} // end of if
}//end of while
//}// end of if
for(int i=0;i<v_get_param_value.length;i++)
{
//{ Based on length array is divided .. retrieve based on order of (i+length+length,i+length, i)
System.out.println("Element Print "+v_get_param_value_tmp[i+v_get_param_value.length+v_get_param_value.length]+","+v_get_param_value_tmp[i+v_get_param_value.length]+","+v_get_param_value_tmp[i]);
%>
<%="<script language=\"javascript\">AddField3('"+v_get_param_value_tmp[i+v_get_param_value.length+v_get_param_value.length]+"','"+v_get_param_value_tmp[i]+"','"+v_get_param_value_tmp[i+v_get_param_value.length]+"');</script>"%>
<%
//}
}
}
%>
</div>
<table border=1>
<tr>
<td>
<input type="button" name="createTextField" value="Add Variable" onclick=AddField() >
</td>
<td>
<input type="button" name="delTextField" value="Delete Variable" onclick=DeleteField() >
</td>
<td>
<input type="button" name="ShowValues" value="PrintValues" onclick=printValues() >
</td>
<!--
<td>
<input type="button" name="ClearValues" value="Clear Values" onclick=document.clear />
</td>
<td>
<input type="button" name="ReloadPage" value="Reload Page" />
</td>
</td>
-->
</tr>
</table>
<!--</form>-->
</fieldset>
<!-- Pre Variable Block
PRE PROCESSING STATEMENTS
-->
<fieldset>
<legend>PRE PROCESSING BLOCK</legend>
<!-- <form name="usr_pre_qry"> -->
<TEXTAREA name=usr_pre_qry_val rows=6 cols=150></TEXTAREA>
<!-- <input type="button" name="usr_pre_query_bttn" value="Submit" onclick=display_qry() > -->
<!-- </form> -->
</fieldset>
<!--
Form for Tables and Procedures
-->
<fieldset>
<legend>Object Details </legend>
<!-- Shifted to TOP-->
<!--<form name="frm_Objects" action="FirstPage_Table.jsp"> -->
Object Type :
<select onchange="setObjNameNull()" name=Obj_types>
<%
if(v_object_type==null)
{
%>
<option value="NULL" selected></option>
<option value="TABLE">TABLE</option>
<option value="PROCEDURE">PROCEDURE</option>
<option value="FUNCTION">FUNCTION</option>
<option value="PACKAGE">PACKAGE</option>
<%
}
else if(v_object_type.equals("TABLE"))
{
%>
<option value="NULL"></option>
<option value="TABLE" selected>TABLE</option>
<option value="PROCEDURE">PROCEDURE</option>
<option value="FUNCTION">FUNCTION</option>
<option value="PACKAGE">PACKAGE</option>
<%
}
else if(v_object_type.equals("PROCEDURE"))
{
%>
<option value="NULL"></option>
<option value="TABLE">TABLE</option>
<option value="PROCEDURE" selected>PROCEDURE</option>
<option value="FUNCTION">FUNCTION</option>
<option value="PACKAGE">PACKAGE</option>
<%
}
else if(v_object_type.equals("FUNCTION"))
{
%>
<option value="NULL"></option>
<option value="TABLE">TABLE</option>
<option value="PROCEDURE" >PROCEDURE</option>
<option value="FUNCTION" selected>FUNCTION</option>
<option value="PACKAGE">PACKAGE</option>
<%
}
else if(v_object_type.equals("PACKAGE"))
{
%>
<option value="NULL"></option>
<option value="TABLE">TABLE</option>
<option value="PROCEDURE" >PROCEDURE</option>
<option value="FUNCTION">FUNCTION</option>
<option value="PACKAGE" selected>PACKAGE</option>
<%
}
else
{
%>
<option value="NULL"></option>
<option value="TABLE">TABLE</option>
<option value="PROCEDURE">PROCEDURE</option>
<option value="FUNCTION">FUNCTION</option>
<option value="PACKAGE">PACKAGE</option>
<%
}
%>
</select>
<br>
Object Names :
<!--<select name=Obj_Names onchange="javascript:document.frm_Objects.submit();" > -->
<!--<select name=Obj_Names onchange="javascript:document.frm_Objects.submit();" > -->
<!-- CALL JAVASCRIPT TO NULLIFY THE PROCEDURE SELECTED FOR PACKAGE -->
<select name=Obj_Names onchange="setPkgObjNameNull()" >
<!-- Defaulting null for first time to avoid table selection by default -->
<%="<option value='' selected></option>" %>
<%
if(v_object_type!=null)
{
stmt=con.prepareStatement("SELECT 1 FROM dual");
int flag=1;
if(v_object_type.equals("TABLE"))
{
//stmt=con.prepareStatement("SELECT distinct object_name FROM user_objects where (object_name like 'WSH%' or object_name like 'MTL%' or object_name like 'INV%' or object_name like 'OM%') and object_type IN('SYNONYM')");
stmt=con.prepareStatement("SELECT object_name FROM user_objects where object_type IN('"+v_object_type+"','SYNONYM')");
}
else if(v_object_type.equals("PROCEDURE")||v_object_type.equals("FUNCTION"))
{
//stmt=con.prepareStatement("SELECT 2 FROM dual");
stmt=con.prepareStatement("SELECT object_name FROM user_objects where object_type = '"+v_object_type+"'");
}
else if(v_object_type.equals("PACKAGE"))
{
//stmt=con.prepareStatement("SELECT 4 FROM dual");
// Resultset will be handled by code itself
flag=0;
stmt=con.prepareStatement("SELECT DISTINCT PACKAGE_name FROM user_arguments WHERE package_name IS NOT null ");
//stmt=con.prepareStatement("SELECT DISTINCT PACKAGE_name FROM user_arguments WHERE (package_name like 'WSH%' or package_name like 'OM%' or package_name like 'FND%' or package_name like 'INV%' or package_name like 'OM%')");
// Select the List of values in Object Names Packages-
// DISPLAY PACKAGES
rs=stmt.executeQuery();
while(rs.next())
{
String v_obj_pkg=rs.getString(1);
if (v_object_name!=null && v_object_name.equals(v_obj_pkg))
{
%>
<%="<option value="+v_obj_pkg+" selected>"+v_obj_pkg+"</option>" %>
<%
}
else
{
%>
<%="<option value="+v_obj_pkg+">"+v_obj_pkg+"</option>" %>
<%
}
}
rs.close();
// CREATE OPTION CLASS that will contain procedures for the package selected.
// Procedure names derived from Package Name
// Note Object Names Used here
// CLOSE SELECT LIST AFTER FILLING IN PACKAGES
// CREATE NEW SELECT LIST FOR SELECTING PROCEDURES ONLY FOR THE OPTION PACKAGES
stmt=con.prepareStatement("SELECT distinct object_name FROM user_arguments WHERE package_name ='"+v_object_name+"'");
%>
<%="</select>"%>
<!-- Aug : 28 Changed to submit as the on change wasnt trigged properly-->
<select name="Obj_names_proc" onchange="javascript:document.frm_Objects.submit();">"
<!--<select name="Obj_names_proc" onchange="setObjNameNull">"-->
<%
// CODE FOR FILLING THE NEW SELECT LIST WITH PROCEDURES RELATED TO THE PACKAGE SELECTED
rs=stmt.executeQuery();
%>
<%="<option value=\"\"</option>" %>
<%
while(rs.next())
{
String v_obj_proc_lst_name=rs.getString(1);
//v_obj_proc_lst is the the select list created on the fly.
if (v_object_name!=null && v_Obj_names_proc!=null && v_Obj_names_proc.equals(v_obj_proc_lst_name))
{
// Select the option is it matches the list of values present to be highlighted, else select none
%>
<%="<option value="+v_obj_proc_lst_name+" selected>"+v_obj_proc_lst_name+"</option>" %>
<%
}
else
{
%>
<%="<option value="+v_obj_proc_lst_name+">"+v_obj_proc_lst_name+"</option>" %>
<%
}
}
rs.close();
//CLOSING SELECT LIST FOR PROCEDURES WITHIN PACAKGE
%>
<%= "</select>" %>
<%
}
// Package has its own result set for others this result set logic will work
// This logic is for displaying TABLES,FUNCTIONS and PROCEDURES handled using flag value
if (flag==1)
{
rs=stmt.executeQuery();
while(rs.next())
{
String v_obj_lst_name=rs.getString(1);
if (v_object_name!=null && v_object_name.equals(v_obj_lst_name))
{
%>
<%="<option value="+v_obj_lst_name+" selected>"+v_obj_lst_name+"</option>" %>
<%
}
else
{
%>
<%="<option value="+v_obj_lst_name+">"+v_obj_lst_name+"</option>" %>
<%
}
}
rs.close();
}
}// end of if i think
%>
</select>
<hr>
<br>
<!--Details of the Object :-->
<p> </p>
<table border=0 width="100%">
<%
// Adding code for table columns and parameters
if(v_object_type!=null && v_object_name!=null)
{
int flag=1;
stmt=con.prepareStatement("Select 1 from dual");
//stmt=null;
if(v_object_type.equals("TABLE"))
{
// Table should display
// Column Name - Value - Data Type - Length - Precision - Nullable or not
// Select Statement - SELECT column_name,data_type,data_length,data_precision,Nullable
stmt=con.prepareStatement("SELECT column_name,data_type,data_length,data_precision,nullable FROM all_tab_cols where table_name = '"+v_object_name+"'");
flag=0;
rs=stmt.executeQuery();
//Printing volumn names using meta data
rsmd=rs.getMetaData();
int numcols=rsmd.getColumnCount();
%>
<%= "<TR>" %>
<%
for(int i=1;i<=numcols;i++)
{
%>
<%= "<TH align='center'> <font color=blue>"+rsmd.getColumnLabel(i)+"</font></TH>" %>
<%
}
%>
<%= "<TH aligh='center'> <font color=blue>ENTER VALUE</font></TH></TR>" %>
<%
// Closing result set meta data
// Printing Argument Names
while(rs.next())
{
String getColumnName= rs.getString(1);
String getDataType=rs.getString(2);
String getDataLength=rs.getString(3);
String getPrecision=rs.getString(4);
String getNullable=rs.getString(5);
%>
<%= "<tr align='center'><td><input type='text' name='"+getColumnName+"' readonly='true' value='"+getColumnName+"'/></td>"%>
<%= "<td><input type='text' name='"+getDataType+"' readonly='true' value='"+getDataType+"' /></td>"%>
<%= "<td><input type='text' name='"+getDataLength+"' readonly='true' value='"+getDataLength+"' /></td>"%>
<%= "<td><input type='text' name='"+getPrecision+"' readonly='true' value='"+getPrecision+"' /></td>"%>
<%= "<td><input type='text' name='"+getNullable+"' readonly='true' value='"+getNullable+"' /></td>"%>
<%= "<td><input type='text' name="+getColumnName+"' /></td></tr>"%>
<% // "<td><input type='text' name=\""+getArgRetType+"\" value=\""+getArgRetType+"\" /></td></tr>" %>
<%
}
rs.close();
}
else if(v_object_type.equals("PROCEDURE") || v_object_type.equals("FUNCTION")|| v_object_type.equals("PACKAGE"))
{
// Arguments should display
// Argument Name - Value- in_out-Data type - Data length - sequence of Reference - Default Value
// Select Clause order by sequence of the arguments
if(v_object_type.equals("PACKAGE"))
{
//stmt=con.prepareStatement("SELECT argument_name,in_out,data_type,data_length,sequence,default_value FROM user_arguments WHERE object_name = '"+v_Obj_names_proc+"' order by sequence");
//Package Name Procedure Name
//stmt=con.prepareStatement("SELECT argument_name,in_out,data_type,data_length,sequence,default_value FROM user_arguments WHERE object_name = '"+v_Obj_names_proc+"'and package_name='"+v_object_name+"' order by sequence");
//Aug 14th Commented
stmt=con.prepareStatement("SELECT argument_name,in_out,data_type,data_length,sequence,default_value FROM user_arguments WHERE object_name = '"+v_Obj_names_proc+"' and package_name ='"+v_object_name+"' and data_level=0 order by sequence");
}
else
{
//Procedure and function
//stmt=con.prepareStatement("SELECT argument_name,in_out,data_type,data_length,sequence,default_value FROM user_arguments WHERE object_name = '"+v_object_name+"' order by sequence");
// Changing on 14-Aug refining types query
// Obj_names_proc
stmt=con.prepareStatement("SELECT argument_name,in_out,data_type,data_length,sequence,default_value FROM user_arguments WHERE object_name = '"+v_Obj_names_proc+"' and package_name ='"+v_object_name+"' and data_level=0 order by sequence");
}
flag=0;
rs=stmt.executeQuery();
//Printing volumn names using meta data
rsmd=rs.getMetaData();
int numcols=rsmd.getColumnCount();
%>
<%= "<TR>" %>
<%
for(int i=1;i<=numcols;i++)
{
%>
<%= "<TH align='center'> <font color=blue>"+rsmd.getColumnLabel(i)+"</font></TH>" %>
<%
}
%>
<%= "<TH align='center'> <font color=blue> ENTER VALUE </font></TH></TR>" %>
<%
// Closing result set meta data
// Printing Argument Names
while(rs.next())
{
String getArgName= rs.getString(1);
String getArgRetType=rs.getString(2);
String getDataType=rs.getString(3);
String getDataLength=rs.getString(4);
String getsequence=rs.getString(5);
String getDefaultValue=rs.getString(6);
%>
<%//<%= "<tr align='center'><td>"+getArgName+"</td>" %>
<%= "<tr align='center'><td>"+getArgName+"</td>"%>
<%= "<td>"+getArgRetType+"</td>"%>
<%= "<td>"+getDataType+"</td>"%>
<%= "<td>"+getDataLength+"</td>"%>
<%= "<td>"+getsequence+"</td>"%>
<%= "<td>"+getDefaultValue+"</td>"%>
<%= "<td><input type='text' name="+getArgName+" /></td></tr>"%>
<% // "<td><input type='text' name=\""+getArgRetType+"\" value=\""+getArgRetType+"\" /></td></tr>" %>
<%
}
rs.close();
//flag=1;
}
else if(v_object_type.equals("PACKAGE"))
{
//CREATE A SELECT BOX to Take list of values that will POPULATE LIST OF PROCEDURES in a package
//stmt=con.prepareStatement("SELECT DISTINCT PACKAGE_name FROM user_arguments WHERE package_name IS NOT null");
}
// Flag has been introduced to avoid problems with procedure and table handling
if(flag==1)
{
rs=stmt.executeQuery();
while(rs.next())
{
%>
<%= "<tr><td>"+rs.getString(1)+"</td>"%>
<%= "<td><input type='text' name="+rs.getString(1)+" /></td></tr>"%>
<%
}
rs.close();
}
}
}
catch(IOException e)
{
out.println("1 IOException Occurred : "+e);
}
catch(SQLException s)
{
out.println("2 SQLException Occurred : "+s);
}
%>
</table align=center>
<hr>
<br>
<!--<input type="submit" value="Proceed" / id=submit1 name=submit1> -->
<!-- </form> Moved to the end of page -->
</fieldset>
<!-- POST PROCESSING BLOCK -->
<!-----------
POST PROCESSING BLOCK
---------------->
<fieldset>
<legend>POST PROCESSING BLOCK</legend>
<!-- <form name="usr_post_qry"> -->
<TEXTAREA name=usr_post_qry_val rows=6 cols=150></TEXTAREA>
<!-- /form> -->
</fieldset>
<p></p>
<!-- <center>
ENTER FILE NAME :
<input type="text" name="usr_file_name" >
Enter File Description<input type="text" name="usr_file_name" >
</center>
-->
<input type="submit" onclick="setObjNameNull()">
</form>
</BODY>
</HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
<TITLE></TITLE>
</HEAD>
<BODY bgcolor=LightGoldenrodYellow>
<%@ page language="java" import="java.sql.*,java.io.*,java.util.*" %>
<%
//Get all the variables in the variable block into array
// Trying to get the values and display after which it will be posted to the database
//Getting all param Names
Enumeration enum_param=request.getParameterNames();
Enumeration var_enum_param=request.getParameterNames();
String v_tmp_param_name=request.getParameter("v_var_name");
String v_tmp_param_value=request.getParameter("v_var_value");
String v_tmp_param_type=request.getParameter("v_var_type");
//Get Hidden field count
String v_tmp_hidden_glo_var=request.getParameter("v_glo_var_val");
if(v_tmp_hidden_glo_var==null)
{
v_tmp_hidden_glo_var="1";
}
//Get Parameters being passed
String v_object_name=request.getParameter("Obj_Names");
// Sub list for procedures of a package
String v_Obj_names_proc=request.getParameter("Obj_names_proc");
String v_object_type;
//String str;
v_object_type=request.getParameter("Obj_types");
Connection con=null;
try
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName("oracle.jdbc.driver.OracleDriver");
//con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:AMOORCL","hr","hr");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:AMOORCL","scott","tiger");
//con=DriverManager.getConnection("jdbc:oracle:thin:@ap6267rt.us.oracle.com:1612:PQD12MS1","apps","pqeapps");
//con=DriverManager.getConnection("jdbc:oracle:thin:@ap6264rt.us.oracle.com:1617:PQD12MS1","apps","pqeapps");
PreparedStatement stmt;
ResultSet rs;
ResultSetMetaData rsmd;
%>
<script type="text/javascript" language="javascript">
// object name should be nullfied
var v_flag=0;
function setObjNameNull()
{
//document.frm_Objects.Obj_Names.value=null;
//document.frm_Objects.usr_file_name.value=null;
//document.frm_Objects.usr_pre_qry_val.value=null;
//document.frm_Objects.usr_post_qry_val.value=null;
//document.frm_Objects.usr_file_name.value=null;
//document.frm_Objects.usr_pre_qry_val.value=null;
//document.frm_Objects.usr_post_qry_val.value=null;
//alert(document.frm_Objects.v_var_name==null||Obj_Names.value);
// If variable declaration block has null values
//if(typeof() == ‘undefined’)
if(document.frm_Objects.v_glo_var_val.value>1)
{
for(var i=1;i<=(document.frm_Objects.v_glo_var_val.value-1);i++)
{
//Alerting Blank value -- Use flag to submit it.
var v_name="document.frm_Objects.v_var_name";
var v_value="document.frm_Objects.v_var_value";
var v_type="document.frm_Objects.v_var_type";
// -1 as default value is 1 and other boxes should be count-1;
v_name=v_name+(document.frm_Objects.v_glo_var_val.value -1)+".value";
v_value=v_value+(document.frm_Objects.v_glo_var_val.value -1)+".value";
v_type=v_type+(document.frm_Objects.v_glo_var_val.value -1)+".value";
//alert(v_name);
if(v_name==null||v_value==null||v_type==null)
{
alert('Null values present');
v_flag=0;
}
else
{
v_flag=1;
}
}//for
if(v_flag==1)
{
document.frm_Objects.submit();
}
else
{
//Dont Submit;
}
}
else
{
document.frm_Objects.submit();
}
//Form Submission
/*document.frm_Objects.submit();
stmt=null;
rs=null; */
}
function setPkgObjNameNull()
{
if(document.frm_Objects.Obj_names_proc==null)
{
}else
{
document.frm_Objects.Obj_names_proc.value=null;
}
//document.frm_Objects.Obj_Names.value=null;
//alert(document.frm_Objects.Obj_Names.value);
document.frm_Objects.submit();
}
function AddField()
{
// Step 0 : Add check box if needed to delete the Variable
//Step 1 : Create a Variable Field
//Step 2 : Create a Value Field
//Step 3 : Create DataType Field
//////////////////////////////////////
//
//CODE CHANGE
//
/////////////////////////////////////
////////////////////////////////////////////
//
//
//OLD CODE THAT WORKED
//
//
///////////////////////////////////////////////
//var cnt=document.frm_Objects.v_glo_var_val.value;
//24th august -- considering Deleting Check Box
var new_element=document.createElement("<INPUT TYPE='checkbox' name='v_var_chk_name' />");
var_area.appendChild(new_element);
//Step 1 : Create a Variable Field
var_area.innerHTML=var_area.innerHTML+"Variable Name : ";
//var new_element=document.createElement("<INPUT TYPE='text' value='TextField' name='text1' />");
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_name' />");
var_area.appendChild(new_element);
//var_area.innerHTML=var_area.innerHTML+"</br>";
//Step 2 : Create a Value Field
var_area.innerHTML=var_area.innerHTML+"Variable Value : ";
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_value' />");
var_area.appendChild(new_element);
//var_area.innerHTML=var_area.innerHTML+"</br>";
//Step 3 : Create DataType Field
var_area.innerHTML=var_area.innerHTML+"Variable Type : ";
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_type' />");
var_area.appendChild(new_element);
var_area.innerHTML=var_area.innerHTML+"</br>";
document.frm_Objects.v_glo_var_val.value=++document.frm_Objects.v_glo_var_val.value;
}
//function AddField3(one,two,three)
function AddField3(one1,two1,three1)
{
var one=one1;
var two=two1;
var three=three1;
// Step 0 : Add check box if needed to delete the Variable
//Step 1 : Create a Variable Field
//Step 2 : Create a Value Field
//Step 3 : Create DataType Field
//var_area.innerHTML=var_area.innerHTML+"Variable Name : ";
//var new_element=document.createElement("<INPUT TYPE='text' value='TextField' name='text1' />");
var new_element=document.createElement("<INPUT TYPE='checkbox' name='v_var_chk_name' />");
var_area.appendChild(new_element);
//Step 1 : Create a Variable Field
var_area.innerHTML=var_area.innerHTML+"Variable Name : ";
//var new_element=document.createElement("<INPUT TYPE='text' value='TextField' name='text1' />");
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_name' value='"+one+"' />");
var_area.appendChild(new_element);
//var_area.innerHTML=var_area.innerHTML+"</br>";
//Step 2 : Create a Value Field
var_area.innerHTML=var_area.innerHTML+"Variable Value : ";
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_value' value='"+two+"' />");
var_area.appendChild(new_element);
//var_area.innerHTML=var_area.innerHTML+"</br>";
//Step 3 : Create DataType Field
var_area.innerHTML=var_area.innerHTML+"Variable Type : ";
var new_element=document.createElement("<INPUT TYPE='text' name='v_var_type' value='"+three+"' />");
var_area.appendChild(new_element);
var_area.innerHTML=var_area.innerHTML+"</br>";
}
</script>
<!--
FORM
-->
<form name="frm_Objects" action="FirstPage_Table.jsp" method="GET">
<!--
Global variables Block
-->
<!-- hidden field used to store the number of variables being used -->
<%= "<input type='hidden' name='v_glo_var_val' value="+v_tmp_hidden_glo_var+" />" %>
<fieldset>
<legend>VARIABLE DECLARATION</legend>
<!--<form name="var_frm">-->
<div id="var_area"><!-- Fields created using java script -->
<!--// Write code to persist the values in the text boxes before writing to database -->
<!-- Call the AddField( value) -->
<%
// Added code to handle if no Variables are declared yet
if(v_tmp_param_name!=null||v_tmp_param_value!=null||v_tmp_param_type!=null)
{
System.out.println("------------------Start of Method :----------------");
//Retrieved object from enumeration, took it into a string and printed it
// Getting Parameter Names and Printing their Values
// First 3 variables will be of the type (var name, var value,var type)
int count=0;
//Enumeration e_temp=var_enum_param;
System.out.println("Count before elements :"+count);
Enumeration e_temp=request.getParameterNames();// Can modify to take values of only variable names
while(e_temp.hasMoreElements())
{
count=count+1;
Object obj=e_temp.nextElement();
}
// Count of Elements
System.out.println("Count of elements is :"+count);
// Counting number of parameters
String[] v_get_param_value_tmp=new String[count];
String[] v_get_param_value=new String[count];
// Adding code to handle if there are no check boxes
count=0;
String v_get_param_name;
while(var_enum_param.hasMoreElements())
{
Object obj=var_enum_param.nextElement();
v_get_param_name=obj.toString();
System.out.println("Element Retrieved is : "+v_get_param_name);
//count used for every 3 values submit
// If param value is v_value,type display it and its values
//get ParameterValues(String);
if(v_get_param_name.equals("v_var_name")||v_get_param_name.equals("v_var_value")||v_get_param_name.equals("v_var_type"))
{
//Get Parameter value
//Array to contain values of ParameterS
v_get_param_value=request.getParameterValues(v_get_param_name);
//System.out.println("Value of Variable Parameter is : "+v_get_param_value);
//addding values to array - Length would be 2
// Length of array is the set's of variables present ( 3 sets of name value and type )
// Order of adding is always 2 var name,2 value, 2 type
for(int i=0;i<v_get_param_value.length;i++)
{
v_get_param_value_tmp[count]=v_get_param_value[i];
System.out.println("Length "+v_get_param_value.length);
System.out.println(v_get_param_value_tmp[count]);
count=count+1;
// Display Value
}
} // end of if
}//end of while
//}// end of if
for(int i=0;i<v_get_param_value.length;i++)
{
//{ Based on length array is divided .. retrieve based on order of (i+length+length,i+length, i)
System.out.println("Element Print "+v_get_param_value_tmp[i+v_get_param_value.length+v_get_param_value.length]+","+v_get_param_value_tmp[i+v_get_param_value.length]+","+v_get_param_value_tmp[i]);
%>
<%="<script language=\"javascript\">AddField3('"+v_get_param_value_tmp[i+v_get_param_value.length+v_get_param_value.length]+"','"+v_get_param_value_tmp[i]+"','"+v_get_param_value_tmp[i+v_get_param_value.length]+"');</script>"%>
<%
//}
}
}
%>
</div>
<table border=1>
<tr>
<td>
<input type="button" name="createTextField" value="Add Variable" onclick=AddField() >
</td>
<td>
<input type="button" name="delTextField" value="Delete Variable" onclick=DeleteField() >
</td>
<td>
<input type="button" name="ShowValues" value="PrintValues" onclick=printValues() >
</td>
<!--
<td>
<input type="button" name="ClearValues" value="Clear Values" onclick=document.clear />
</td>
<td>
<input type="button" name="ReloadPage" value="Reload Page" />
</td>
</td>
-->
</tr>
</table>
<!--</form>-->
</fieldset>
<!-- Pre Variable Block
PRE PROCESSING STATEMENTS
-->
<fieldset>
<legend>PRE PROCESSING BLOCK</legend>
<!-- <form name="usr_pre_qry"> -->
<TEXTAREA name=usr_pre_qry_val rows=6 cols=150></TEXTAREA>
<!-- <input type="button" name="usr_pre_query_bttn" value="Submit" onclick=display_qry() > -->
<!-- </form> -->
</fieldset>
<!--
Form for Tables and Procedures
-->
<fieldset>
<legend>Object Details </legend>
<!-- Shifted to TOP-->
<!--<form name="frm_Objects" action="FirstPage_Table.jsp"> -->
Object Type :
<select onchange="setObjNameNull()" name=Obj_types>
<%
if(v_object_type==null)
{
%>
<option value="NULL" selected></option>
<option value="TABLE">TABLE</option>
<option value="PROCEDURE">PROCEDURE</option>
<option value="FUNCTION">FUNCTION</option>
<option value="PACKAGE">PACKAGE</option>
<%
}
else if(v_object_type.equals("TABLE"))
{
%>
<option value="NULL"></option>
<option value="TABLE" selected>TABLE</option>
<option value="PROCEDURE">PROCEDURE</option>
<option value="FUNCTION">FUNCTION</option>
<option value="PACKAGE">PACKAGE</option>
<%
}
else if(v_object_type.equals("PROCEDURE"))
{
%>
<option value="NULL"></option>
<option value="TABLE">TABLE</option>
<option value="PROCEDURE" selected>PROCEDURE</option>
<option value="FUNCTION">FUNCTION</option>
<option value="PACKAGE">PACKAGE</option>
<%
}
else if(v_object_type.equals("FUNCTION"))
{
%>
<option value="NULL"></option>
<option value="TABLE">TABLE</option>
<option value="PROCEDURE" >PROCEDURE</option>
<option value="FUNCTION" selected>FUNCTION</option>
<option value="PACKAGE">PACKAGE</option>
<%
}
else if(v_object_type.equals("PACKAGE"))
{
%>
<option value="NULL"></option>
<option value="TABLE">TABLE</option>
<option value="PROCEDURE" >PROCEDURE</option>
<option value="FUNCTION">FUNCTION</option>
<option value="PACKAGE" selected>PACKAGE</option>
<%
}
else
{
%>
<option value="NULL"></option>
<option value="TABLE">TABLE</option>
<option value="PROCEDURE">PROCEDURE</option>
<option value="FUNCTION">FUNCTION</option>
<option value="PACKAGE">PACKAGE</option>
<%
}
%>
</select>
<br>
Object Names :
<!--<select name=Obj_Names onchange="javascript:document.frm_Objects.submit();" > -->
<!--<select name=Obj_Names onchange="javascript:document.frm_Objects.submit();" > -->
<!-- CALL JAVASCRIPT TO NULLIFY THE PROCEDURE SELECTED FOR PACKAGE -->
<select name=Obj_Names onchange="setPkgObjNameNull()" >
<!-- Defaulting null for first time to avoid table selection by default -->
<%="<option value='' selected></option>" %>
<%
if(v_object_type!=null)
{
stmt=con.prepareStatement("SELECT 1 FROM dual");
int flag=1;
if(v_object_type.equals("TABLE"))
{
//stmt=con.prepareStatement("SELECT distinct object_name FROM user_objects where (object_name like 'WSH%' or object_name like 'MTL%' or object_name like 'INV%' or object_name like 'OM%') and object_type IN('SYNONYM')");
stmt=con.prepareStatement("SELECT object_name FROM user_objects where object_type IN('"+v_object_type+"','SYNONYM')");
}
else if(v_object_type.equals("PROCEDURE")||v_object_type.equals("FUNCTION"))
{
//stmt=con.prepareStatement("SELECT 2 FROM dual");
stmt=con.prepareStatement("SELECT object_name FROM user_objects where object_type = '"+v_object_type+"'");
}
else if(v_object_type.equals("PACKAGE"))
{
//stmt=con.prepareStatement("SELECT 4 FROM dual");
// Resultset will be handled by code itself
flag=0;
stmt=con.prepareStatement("SELECT DISTINCT PACKAGE_name FROM user_arguments WHERE package_name IS NOT null ");
//stmt=con.prepareStatement("SELECT DISTINCT PACKAGE_name FROM user_arguments WHERE (package_name like 'WSH%' or package_name like 'OM%' or package_name like 'FND%' or package_name like 'INV%' or package_name like 'OM%')");
// Select the List of values in Object Names Packages-
// DISPLAY PACKAGES
rs=stmt.executeQuery();
while(rs.next())
{
String v_obj_pkg=rs.getString(1);
if (v_object_name!=null && v_object_name.equals(v_obj_pkg))
{
%>
<%="<option value="+v_obj_pkg+" selected>"+v_obj_pkg+"</option>" %>
<%
}
else
{
%>
<%="<option value="+v_obj_pkg+">"+v_obj_pkg+"</option>" %>
<%
}
}
rs.close();
// CREATE OPTION CLASS that will contain procedures for the package selected.
// Procedure names derived from Package Name
// Note Object Names Used here
// CLOSE SELECT LIST AFTER FILLING IN PACKAGES
// CREATE NEW SELECT LIST FOR SELECTING PROCEDURES ONLY FOR THE OPTION PACKAGES
stmt=con.prepareStatement("SELECT distinct object_name FROM user_arguments WHERE package_name ='"+v_object_name+"'");
%>
<%="</select>"%>
<!-- Aug : 28 Changed to submit as the on change wasnt trigged properly-->
<select name="Obj_names_proc" onchange="javascript:document.frm_Objects.submit();">"
<!--<select name="Obj_names_proc" onchange="setObjNameNull">"-->
<%
// CODE FOR FILLING THE NEW SELECT LIST WITH PROCEDURES RELATED TO THE PACKAGE SELECTED
rs=stmt.executeQuery();
%>
<%="<option value=\"\"</option>" %>
<%
while(rs.next())
{
String v_obj_proc_lst_name=rs.getString(1);
//v_obj_proc_lst is the the select list created on the fly.
if (v_object_name!=null && v_Obj_names_proc!=null && v_Obj_names_proc.equals(v_obj_proc_lst_name))
{
// Select the option is it matches the list of values present to be highlighted, else select none
%>
<%="<option value="+v_obj_proc_lst_name+" selected>"+v_obj_proc_lst_name+"</option>" %>
<%
}
else
{
%>
<%="<option value="+v_obj_proc_lst_name+">"+v_obj_proc_lst_name+"</option>" %>
<%
}
}
rs.close();
//CLOSING SELECT LIST FOR PROCEDURES WITHIN PACAKGE
%>
<%= "</select>" %>
<%
}
// Package has its own result set for others this result set logic will work
// This logic is for displaying TABLES,FUNCTIONS and PROCEDURES handled using flag value
if (flag==1)
{
rs=stmt.executeQuery();
while(rs.next())
{
String v_obj_lst_name=rs.getString(1);
if (v_object_name!=null && v_object_name.equals(v_obj_lst_name))
{
%>
<%="<option value="+v_obj_lst_name+" selected>"+v_obj_lst_name+"</option>" %>
<%
}
else
{
%>
<%="<option value="+v_obj_lst_name+">"+v_obj_lst_name+"</option>" %>
<%
}
}
rs.close();
}
}// end of if i think
%>
</select>
<hr>
<br>
<!--Details of the Object :-->
<p> </p>
<table border=0 width="100%">
<%
// Adding code for table columns and parameters
if(v_object_type!=null && v_object_name!=null)
{
int flag=1;
stmt=con.prepareStatement("Select 1 from dual");
//stmt=null;
if(v_object_type.equals("TABLE"))
{
// Table should display
// Column Name - Value - Data Type - Length - Precision - Nullable or not
// Select Statement - SELECT column_name,data_type,data_length,data_precision,Nullable
stmt=con.prepareStatement("SELECT column_name,data_type,data_length,data_precision,nullable FROM all_tab_cols where table_name = '"+v_object_name+"'");
flag=0;
rs=stmt.executeQuery();
//Printing volumn names using meta data
rsmd=rs.getMetaData();
int numcols=rsmd.getColumnCount();
%>
<%= "<TR>" %>
<%
for(int i=1;i<=numcols;i++)
{
%>
<%= "<TH align='center'> <font color=blue>"+rsmd.getColumnLabel(i)+"</font></TH>" %>
<%
}
%>
<%= "<TH aligh='center'> <font color=blue>ENTER VALUE</font></TH></TR>" %>
<%
// Closing result set meta data
// Printing Argument Names
while(rs.next())
{
String getColumnName= rs.getString(1);
String getDataType=rs.getString(2);
String getDataLength=rs.getString(3);
String getPrecision=rs.getString(4);
String getNullable=rs.getString(5);
%>
<%= "<tr align='center'><td><input type='text' name='"+getColumnName+"' readonly='true' value='"+getColumnName+"'/></td>"%>
<%= "<td><input type='text' name='"+getDataType+"' readonly='true' value='"+getDataType+"' /></td>"%>
<%= "<td><input type='text' name='"+getDataLength+"' readonly='true' value='"+getDataLength+"' /></td>"%>
<%= "<td><input type='text' name='"+getPrecision+"' readonly='true' value='"+getPrecision+"' /></td>"%>
<%= "<td><input type='text' name='"+getNullable+"' readonly='true' value='"+getNullable+"' /></td>"%>
<%= "<td><input type='text' name="+getColumnName+"' /></td></tr>"%>
<% // "<td><input type='text' name=\""+getArgRetType+"\" value=\""+getArgRetType+"\" /></td></tr>" %>
<%
}
rs.close();
}
else if(v_object_type.equals("PROCEDURE") || v_object_type.equals("FUNCTION")|| v_object_type.equals("PACKAGE"))
{
// Arguments should display
// Argument Name - Value- in_out-Data type - Data length - sequence of Reference - Default Value
// Select Clause order by sequence of the arguments
if(v_object_type.equals("PACKAGE"))
{
//stmt=con.prepareStatement("SELECT argument_name,in_out,data_type,data_length,sequence,default_value FROM user_arguments WHERE object_name = '"+v_Obj_names_proc+"' order by sequence");
//Package Name Procedure Name
//stmt=con.prepareStatement("SELECT argument_name,in_out,data_type,data_length,sequence,default_value FROM user_arguments WHERE object_name = '"+v_Obj_names_proc+"'and package_name='"+v_object_name+"' order by sequence");
//Aug 14th Commented
stmt=con.prepareStatement("SELECT argument_name,in_out,data_type,data_length,sequence,default_value FROM user_arguments WHERE object_name = '"+v_Obj_names_proc+"' and package_name ='"+v_object_name+"' and data_level=0 order by sequence");
}
else
{
//Procedure and function
//stmt=con.prepareStatement("SELECT argument_name,in_out,data_type,data_length,sequence,default_value FROM user_arguments WHERE object_name = '"+v_object_name+"' order by sequence");
// Changing on 14-Aug refining types query
// Obj_names_proc
stmt=con.prepareStatement("SELECT argument_name,in_out,data_type,data_length,sequence,default_value FROM user_arguments WHERE object_name = '"+v_Obj_names_proc+"' and package_name ='"+v_object_name+"' and data_level=0 order by sequence");
}
flag=0;
rs=stmt.executeQuery();
//Printing volumn names using meta data
rsmd=rs.getMetaData();
int numcols=rsmd.getColumnCount();
%>
<%= "<TR>" %>
<%
for(int i=1;i<=numcols;i++)
{
%>
<%= "<TH align='center'> <font color=blue>"+rsmd.getColumnLabel(i)+"</font></TH>" %>
<%
}
%>
<%= "<TH align='center'> <font color=blue> ENTER VALUE </font></TH></TR>" %>
<%
// Closing result set meta data
// Printing Argument Names
while(rs.next())
{
String getArgName= rs.getString(1);
String getArgRetType=rs.getString(2);
String getDataType=rs.getString(3);
String getDataLength=rs.getString(4);
String getsequence=rs.getString(5);
String getDefaultValue=rs.getString(6);
%>
<%//<%= "<tr align='center'><td>"+getArgName+"</td>" %>
<%= "<tr align='center'><td>"+getArgName+"</td>"%>
<%= "<td>"+getArgRetType+"</td>"%>
<%= "<td>"+getDataType+"</td>"%>
<%= "<td>"+getDataLength+"</td>"%>
<%= "<td>"+getsequence+"</td>"%>
<%= "<td>"+getDefaultValue+"</td>"%>
<%= "<td><input type='text' name="+getArgName+" /></td></tr>"%>
<% // "<td><input type='text' name=\""+getArgRetType+"\" value=\""+getArgRetType+"\" /></td></tr>" %>
<%
}
rs.close();
//flag=1;
}
else if(v_object_type.equals("PACKAGE"))
{
//CREATE A SELECT BOX to Take list of values that will POPULATE LIST OF PROCEDURES in a package
//stmt=con.prepareStatement("SELECT DISTINCT PACKAGE_name FROM user_arguments WHERE package_name IS NOT null");
}
// Flag has been introduced to avoid problems with procedure and table handling
if(flag==1)
{
rs=stmt.executeQuery();
while(rs.next())
{
%>
<%= "<tr><td>"+rs.getString(1)+"</td>"%>
<%= "<td><input type='text' name="+rs.getString(1)+" /></td></tr>"%>
<%
}
rs.close();
}
}
}
catch(IOException e)
{
out.println("1 IOException Occurred : "+e);
}
catch(SQLException s)
{
out.println("2 SQLException Occurred : "+s);
}
%>
</table align=center>
<hr>
<br>
<!--<input type="submit" value="Proceed" / id=submit1 name=submit1> -->
<!-- </form> Moved to the end of page -->
</fieldset>
<!-- POST PROCESSING BLOCK -->
<!-----------
POST PROCESSING BLOCK
---------------->
<fieldset>
<legend>POST PROCESSING BLOCK</legend>
<!-- <form name="usr_post_qry"> -->
<TEXTAREA name=usr_post_qry_val rows=6 cols=150></TEXTAREA>
<!-- /form> -->
</fieldset>
<p></p>
<!-- <center>
ENTER FILE NAME :
<input type="text" name="usr_file_name" >
Enter File Description<input type="text" name="usr_file_name" >
</center>
-->
<input type="submit" onclick="setObjNameNull()">
</form>
</BODY>
</HTML>
Wednesday, August 29, 2007
Java Files for the Project - VariableList
D:\jakarta-tomcat-5.0.18\webapps\ROOT\WEB-INF\classes\SQLUTF
VariableList consists of methods that store variable name ,value and type as in one and add the object to the array list
package SQLUTF;
import java.util.ArrayList;
import java.util.Iterator;
import SQLUTF.*;
public class VariableList
{
ArrayList varal=new ArrayList();
public boolean addVariable(Variable var){
varal.add(var);
return true;
}
public String toXML()
{
StringBuffer retStr=new StringBuffer();
Iterator iter=varal.iterator();
Variable tempvar;
while(iter.hasNext()){
tempvar=(Variable)iter.next();
retStr.append(tempvar.toXML());
}
return retStr.toString();
}
public String toSQL()
{
StringBuffer retStr=new StringBuffer();
Iterator iter=varal.iterator();
Variable tempvar;
while(iter.hasNext()){
tempvar=(Variable)iter.next();
retStr.append(tempvar.toSQL());
}
return retStr.toString();
}
public static void main(String arg[])
{
VariableList val=new VariableList();
val.addVariable(new Variable("org_id","207","number"));
val.addVariable(new Variable("Org_name","M1","varchar2(100)"));
val.addVariable(new Variable("PO_num","12346","number(5)"));
System.out.println(val.toXML());
System.out.println(val.toSQL());
}
}
VariableList consists of methods that store variable name ,value and type as in one and add the object to the array list
package SQLUTF;
import java.util.ArrayList;
import java.util.Iterator;
import SQLUTF.*;
public class VariableList
{
ArrayList varal=new ArrayList();
public boolean addVariable(Variable var){
varal.add(var);
return true;
}
public String toXML()
{
StringBuffer retStr=new StringBuffer();
Iterator iter=varal.iterator();
Variable tempvar;
while(iter.hasNext()){
tempvar=(Variable)iter.next();
retStr.append(tempvar.toXML());
}
return retStr.toString();
}
public String toSQL()
{
StringBuffer retStr=new StringBuffer();
Iterator iter=varal.iterator();
Variable tempvar;
while(iter.hasNext()){
tempvar=(Variable)iter.next();
retStr.append(tempvar.toSQL());
}
return retStr.toString();
}
public static void main(String arg[])
{
VariableList val=new VariableList();
val.addVariable(new Variable("org_id","207","number"));
val.addVariable(new Variable("Org_name","M1","varchar2(100)"));
val.addVariable(new Variable("PO_num","12346","number(5)"));
System.out.println(val.toXML());
System.out.println(val.toSQL());
}
}
Java Files for the Project - Variable.java
D:\jakarta-tomcat-5.0.18\webapps\ROOT\WEB-INF\classes\SQLUTF
Converting Variables to SQL and XML
package SQLUTF;
import SQLUTF.*;
public class Variable
{
private String strName;
private String strValue;
private String strType;
public Variable(String vName,String vValue,String vType){
strName=vName;
strValue=vValue;
strType= vType;
}
public String toXML(){
StringBuffer retString=new StringBuffer();
retString.append("\n");
retString.append(strName);
retString.append(" \n");
retString.append(strValue);
retString.append(" \n");
retString.append(strType);
retString.append(" \n \n");
return retString.toString();
}
public String toSQL(){
StringBuffer retString=new StringBuffer();
retString.append("\nvariable ");
retString.append(strName+" "+strType+" ;\n");
retString.append(" Exec :"+strName+" := "+strValue+";\n");
return retString.toString();
}
}
Converting Variables to SQL and XML
package SQLUTF;
import SQLUTF.*;
public class Variable
{
private String strName;
private String strValue;
private String strType;
public Variable(String vName,String vValue,String vType){
strName=vName;
strValue=vValue;
strType= vType;
}
public String toXML(){
StringBuffer retString=new StringBuffer();
retString.append("
retString.append(strName);
retString.append("
retString.append(strValue);
retString.append("
retString.append(strType);
retString.append("
return retString.toString();
}
public String toSQL(){
StringBuffer retString=new StringBuffer();
retString.append("\nvariable ");
retString.append(strName+" "+strType+" ;\n");
retString.append(" Exec :"+strName+" := "+strValue+";\n");
return retString.toString();
}
}
Java Files for the Project - Step1.java
D:\jakarta-tomcat-5.0.18\webapps\ROOT\WEB-INF\classes\SQLUTF
package SQLUTF;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.EOFException;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.Random;
public class Step1
{
int randno;
String str,predata,postdata,outpredata,outpostdata;
String path="D:/Steps/";
VariableList variables=new VariableList();//the path...whr the folder with thehas to be created
String str1;
public Step1() ////// Default Constructor
{
Random rand;
rand = new Random();
int randno = rand.nextInt();
str=randno+"T/"; ///folder name..like..
System.out.println("Constructor in process");
}
public Step1(String stepname)
{
str=stepname;
str1=str+"/";
}
public void setPre(String datapre)
{
predata=datapre ;
}
public void setPost(String datapost)
{
postdata=datapost;
}
public void getPre()
{
SQLUTF.ParsingStep x;
x = new SQLUTF.ParsingStep(path+str+"//Pre_Post.xml");
outpredata=x.getPreText();
System.out.println("Data in PRE Block : ");
System.out.println(outpredata);
}
public void getPost()
{
SQLUTF.ParsingStep y;
y = new SQLUTF.ParsingStep(path+str+"//Pre_Post.xml");
outpostdata=y.getPostText();
System.out.println("Data in POST Block :");
System.out.println(outpostdata);
}
public void createStep()
{
SQLUTF.Fileeg f=new SQLUTF.Fileeg();
f.createFolder(path,str); ///creates the folder in the path...D:/steps/
updateFile(path+str,"Pre_Post.xml",predata,postdata);
updateFileSql(path+str,"Pre.sql",predata);
updateFileSql(path+str,"Post.sql",postdata);
updateFileExe(path+str,"Execute.sql");
updateFileSql(path+str,"Variable.sql",variables.toSQL());
updateFileSql(path+str,"Variable.xml",variables.toXML());
}
public void updateFile(String path,String filename,String predata,String posdata)
{
try
{
BufferedWriter out = new BufferedWriter(new FileWriter(path+filename, true));
out.write("");
out.newLine();
out.write(""); //root element
out.newLine();
out.write("
out.newLine();
out.write("");
out.newLine();
out.write(posdata);
out.newLine();
out.write(" ");
out.newLine();
out.write(" ");
out.close();
}
catch (IOException e)
{
System.out.println("File cannot be updated");
}
}
public void updateFileSql(String path, String filename, String data)
{
try
{
BufferedWriter out = new BufferedWriter(new FileWriter(path+filename, true));
out.write(data);
out.newLine();
out.close();
}
catch (IOException e)
{
System.out.println("File cannot be updated");
}
}
public void updateFileExe(String path, String filename)
{
try
{
BufferedWriter out = new BufferedWriter(new FileWriter(path+filename, true));
out.write("@@Pre.sql");
out.newLine();
out.write("@@Script.sql");
out.newLine();
out.write("@@Post.sql");
out.newLine();
out.close();
}
catch (IOException e)
{
System.out.println("File cannot be updated");
}
}
public void addVariables(String vname,String value,String type)
{
variables.addVariable(new Variable(vname,value,type));
}
public static void main(String args[]) throws IOException
{
SQLUTF.Step1 s;
s = new SQLUTF.Step1("884957727T"); //Constructor with parameter call
// s = new SQLUTF.Step1();
// s.setPre("TEJU ");
// s.setPost("HOW");
s.createStep();
// s.getPre();
// s.getPost();
}
}
package SQLUTF;
import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.EOFException;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.util.Random;
public class Step1
{
int randno;
String str,predata,postdata,outpredata,outpostdata;
String path="D:/Steps/";
VariableList variables=new VariableList();//the path...whr the folder with the
String str1;
public Step1() ////// Default Constructor
{
Random rand;
rand = new Random();
int randno = rand.nextInt();
str=randno+"T/"; ///folder name..like..
System.out.println("Constructor in process");
}
public Step1(String stepname)
{
str=stepname;
str1=str+"/";
}
public void setPre(String datapre)
{
predata=datapre ;
}
public void setPost(String datapost)
{
postdata=datapost;
}
public void getPre()
{
SQLUTF.ParsingStep x;
x = new SQLUTF.ParsingStep(path+str+"//Pre_Post.xml");
outpredata=x.getPreText();
System.out.println("Data in PRE Block : ");
System.out.println(outpredata);
}
public void getPost()
{
SQLUTF.ParsingStep y;
y = new SQLUTF.ParsingStep(path+str+"//Pre_Post.xml");
outpostdata=y.getPostText();
System.out.println("Data in POST Block :");
System.out.println(outpostdata);
}
public void createStep()
{
SQLUTF.Fileeg f=new SQLUTF.Fileeg();
f.createFolder(path,str); ///creates the folder
updateFile(path+str,"Pre_Post.xml",predata,postdata);
updateFileSql(path+str,"Pre.sql",predata);
updateFileSql(path+str,"Post.sql",postdata);
updateFileExe(path+str,"Execute.sql");
updateFileSql(path+str,"Variable.sql",variables.toSQL());
updateFileSql(path+str,"Variable.xml",variables.toXML());
}
public void updateFile(String path,String filename,String predata,String posdata)
{
try
{
BufferedWriter out = new BufferedWriter(new FileWriter(path+filename, true));
out.write("");
out.newLine();
out.write("
out.newLine();
out.write("
");");
out.newLine();
out.write(predata);
out.newLine();
out.write("
out.newLine();
out.write("
out.newLine();
out.write(posdata);
out.newLine();
out.write("
out.newLine();
out.write("
out.close();
}
catch (IOException e)
{
System.out.println("File cannot be updated");
}
}
public void updateFileSql(String path, String filename, String data)
{
try
{
BufferedWriter out = new BufferedWriter(new FileWriter(path+filename, true));
out.write(data);
out.newLine();
out.close();
}
catch (IOException e)
{
System.out.println("File cannot be updated");
}
}
public void updateFileExe(String path, String filename)
{
try
{
BufferedWriter out = new BufferedWriter(new FileWriter(path+filename, true));
out.write("@@Pre.sql");
out.newLine();
out.write("@@Script.sql");
out.newLine();
out.write("@@Post.sql");
out.newLine();
out.close();
}
catch (IOException e)
{
System.out.println("File cannot be updated");
}
}
public void addVariables(String vname,String value,String type)
{
variables.addVariable(new Variable(vname,value,type));
}
public static void main(String args[]) throws IOException
{
SQLUTF.Step1 s;
s = new SQLUTF.Step1("884957727T"); //Constructor with parameter call
// s = new SQLUTF.Step1();
// s.setPre("TEJU ");
// s.setPost("HOW");
s.createStep();
// s.getPre();
// s.getPost();
}
}
Subscribe to:
Posts (Atom)
