udayakumar
Posts: 9
|
Posted: 05/12/2007, 9:25 AM |
|
pls, 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.
use HTML & Java to build the client interface and database as Personal Oracle to store the data
|
|
|
fady005
Posts: 115
|
Posted: 05/14/2007, 1:28 AM |
|
What is exactly the problem ?
_________________
Be inventive ! |
|
|
udayakumar
Posts: 9
|
Posted: 05/14/2007, 8:19 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) ;
}
%>
|
|
|
fady005
Posts: 115
|
Posted: 05/15/2007, 1:07 AM |
|
Still don't see where's the problem ...
_________________
Be inventive ! |
|
|
udayakumar
Posts: 9
|
Posted: 05/15/2007, 3:05 AM |
|
I have html text box run netbean5.5 @ jsp use ODBC JDBC connection to Oracle.
Problem is ,were the text box HTML enter a data then, submit button Click .to store Oracle Database on My Data table name.
thank you .
|
|
|
matheus
Posts: 386
|
Posted: 05/15/2007, 4:12 AM |
|
Are you doing manually program?
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
fady005
Posts: 115
|
Posted: 05/15/2007, 4:22 AM |
|
Need more information to help you... For example what is the exception that you get ? Is "eid" the correct variable you wanted...
Plus as matheus noticed, this code isn't done with code charge studio so no relation with this forum...
_________________
Be inventive ! |
|
|
udayakumar
Posts: 9
|
Posted: 05/15/2007, 5:39 AM |
|
yes!
this whould be done automatically. An email would be sent to the manager and also the request creator with the details of the request .
Can you send to me, a simple html code text box. Suitable for jsp code to Insert , Delete, And Drawback Oracle Database table.
|
|
|
matheus
Posts: 386
|
Posted: 05/15/2007, 6:00 AM |
|
udayakumar,
You're totally lost.
_________________
Matheus Trevizan
Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br |
|
|
fady005
Posts: 115
|
Posted: 05/16/2007, 1:03 AM |
|
That what I noticed too... either you don't understand what we're saying, either you don't know what to ask for...
Anyway in the two case we can't help you... Try seing old topics about database modification maybe it'll help you...
_________________
Be inventive ! |
|
|