udayakumar
Posts: 9
|
| Posted: 05/12/2007, 9:20 AM |
|
Pls, any one help!!!! my Project.
Modules in the project
1) Personal administration
2) Request creation, addition, approval & deletion
3) E-mail approval
The workflow process would be
• User creates the request
• Request is send to his manager, this whould be done automatically. An email would be sent to the manager and also the request creator with the details of the request.
• Request creator should be able to recall the request from manager
• User can save the request in draft mode without sending to the approver
• Manager of the concerned request creator can view the details of the request but cannot modify.
1. Request once approved by the manager is sent to the concerned finance dept manager
2. If rejected the request is sent back to the request creator.
3. In all the above scenarios an email should be sent to the concerned parties for necessary action
• Finance manager after receiving the request has to credit the user account and has to send the request to the creator with proper comments as appropriate.
• Now the creator will close the request after the amount has been credited to the creator.
We use HTML & Java to build the client interface and database as Personal Oracle to store the data
|
 |
 |
wkempees
|
| Posted: 05/12/2007, 3:56 PM |
|
Cross posting is not appreciated.
Please post in the forum closest resembling your programming language, and
only post one time.
As you are seeking assistance in building an application I would suggest
"Help Wanted" forum
Walter
|
|
|
 |
udayakumar
Posts: 9
|
| Posted: 05/14/2007, 8:35 AM |
|
i have ( html) jsp converted. the html text box data store to oracle data base.
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@ page import = "java.sql.*"%>
<%@ page import = "java.io.*"%>
<%--
The taglib directive below imports the JSTL library. If you uncomment it,
you must also add the JSTL library to the project. The Add Library... action
on Libraries node in Projects view can be used to add the JSTL 1.1 library.
--%>
<%--
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
--%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:reg1","scott","tiger");
out.println("hello java world" +con);
Statement stat = con.createStatement();
// Create a recordset
ResultSet rset = stat.executeQuery("Select * From emp");
// Parse our recordset
while(rset.next()) {
String eid=rset.getString("empno") ;
out.println(eid);
}
con.close();
}catch(Exception e)
{
out.println(e) ;
}
%>
|
 |
 |
Wkempees
|
| Posted: 05/14/2007, 8:45 AM |
|
Peterr, please close this, and remove my comments.
This discussion is continued in the Java Forum
|
|
|
 |
|