Oracle table takes Null

Ranch Hand

Posts: 153

posted 12 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

I am unable to update an oracle column based on a query. what i did actually was imported an Excel sheet data(CSV seperated by a comma) into table using sqlloader. here in the below code the textbox is displaying the value from Database based on the condition but when i update the database again, it is taking null though the value is displayed on the textbox.. and below is my Code for JSP

<%@page import="javassist.bytecode.stackmap.BasicBlock.Catch"%>
<%@page import="java.sql.*"%>
<%@page import="java.lang.*"%>
<%@page import="java.io.*"%>
<%@page language="Java"%>
<html>
<head>
<script type="text/javascript">

}
</style>
</head>
<body>

<form name="myform" method="post" action="Alloc_Insert.jsp" target="">
<%
try {
    String sessname=(String)session.getAttribute("myusername");
    PreparedStatement ps,ps2=null;
    ResultSet rs=null;
    Statement st=null;
    Connection con=null;
    Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
    con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "tiger");
    ps=con.prepareStatement("select DBID from Scope where specialist IS Null");
    rs = ps.executeQuery();
    if(rs.next())
    {
%>
<input type="text" name="Allocation" size="75" id="Allocation" value="<%=rs.getString("DBID")%>">
<%
}
}
catch(Exception e){
out.println(e);
}
%>
<input type="button" value="Allocate" id="Send" name="submit" onClick="move();Alloc_Insert();"/><br/>
<br/><br/><br/><br/><br/><br/>
<table>
<tr>
<input type="text" id="tgt1" size="100" readonly="readonly">
<td><input type="button"value="Query" id="Query" onClick="UnBlock()"></td>
<td><input type="button" value="Westlaw Verification" onClick="UnBlock_Only()"></td>
</tr><br/>
</table><textarea name="tgt2" id="tgt2" cols="30" rows="5" style="display:none"></textarea>
<table><tr><td><a   id="Query_but"  rel="nofollow">Submit Query</a></td></tr></table>
<table><tr><td><input type="text" value=document.myform.tgt1 size="75"></td></tr></table>
</form>
 </body>
</html>

And the Update JSP i used is as below

<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.ResultSet"%>
<html>
    <head>
    </head>
    <body>
<%

try{
            ResultSet rs=null;
            String Add_U=request.getParameter("tgt1");
            String user=(String) session.getAttribute("myusername");
            Class.forName("oracle.jdbc.driver.OracleDriver");
            java.util.Date today = new java.util.Date();
            java.sql.Timestamp t= new java.sql.Timestamp(today.getTime());
            Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","system","tiger");
            PreparedStatement ps=con.prepareStatement("Update Scope SET ALLOCATED=?, SPECIALIST=? WHERE DBID='"+Add_U+"'");
            ps.setTimestamp(1, t);
            ps.setString(2, user);
            /*ps.setString(3, Add_U);*/
            ps.executeQuery();
            out.println(user);
            out.println("\n");
            out.println(con);
            out.println(t);
            out.println("Add_U");
        }
        catch(Exception e)
                       {
            out.println(e);
                       }
%>

</body>
</html>

Also could you please help me by editing the code i entered above to make the buttons to post data into different JSPs

A wop bop a lu bob a womp bam boom. Tutti frutti ad:

Gift giving made easy with the permaculture playing cards

https://coderanch.com/t/777758/Gift-giving-easy-permaculture-playing