Forum:

Compare textbox data with sql table data

Ranch Hand

Posts: 153

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I'm creating an app, that displayes a String from a database. This String is then displayed in a textbox that cannot be edited.

I now require that varible (String passed) in the text box to be compared with a column in a SQL database table which is an identical String. Once the matching String is found I need to update other columns based on the queries.

when i use request.getParameters() method it is giving output as null.

i need it to be done purely in jsp. please help.

Bear Bibeault

Sheriff

Posts: 67637

173

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Rakesh Keerthi wrote:I'm creating an app, that displayes a String from a database. This String is then displayed in a textbox that cannot be edited.

Please be precise when posting. Does this mean that you made the control disabled or readonly? They are not the same and which you used may be the answer to your question. Just saying "cannot be edited" doesn't give us the information we need to answer your question.

But I'm guessing that you used disabled, which means that the value will not be submitted.

i need it to be done purely in jsp

I sincerely hope that this does not mean that you are putting Java code in your JSPs!

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Rakesh Keerthi

Ranch Hand

Posts: 153

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,
i made it read only.
here the data is getting retrieved from a sql query and below is the code that i used to do so.

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

function move(){

document.getElementById('tgt1').value = document.getElementById('Allocation').value;
 document.getElementById('Allocation').value="";
 document.getElementById("Send").disabled=true;
 
}
function UnBlock()
{
    document.getElementById("tgt1").value="";
    document.getElementById("Send").disabled=false;
    document.getElementById("tgt2").style.display="block";
    document.getElementById("Query_but").style.display="block";
   }
function UnBlock_Only(){

document.getElementById("Send").disabled=false;
    document.getElementById("Query").disabled=true;
}
function Alloc_Insert()
{
    document.myform.action="Alloc_Insert.jsp";
    document.myform.method="post";
    document.myform.submit();
}

</script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
body {
	margin-top: 20px;
	margin-left: 30px;

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

<form name="myform" method="post" action="Alloc_Insert.jsp">
<%
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 Scope1 where specialist IS Null");
    rs = ps.executeQuery();
    if(rs.next())
    {
  %>
<input type="text" name="Allocation" size="75" id="Allocation" value="<%=rs.getString("DBID")%>" readonly="readonly">
<%
}
}
catch(Exception e){
out.println(e);
}
%>

<a href="Alloc_Insert.jsp" value="Allocate" id="Send" name="Send" onclick="Clicked()">Allocate</a><br/>
<br/><br/><br/><br/><br/><br/>
<table>
<tr>
<input type="text" id="tgt1" size="100">
<td><input type="button"value="Query" id="Query" onClic="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 href="Insert.jsp" style="display: none" id="Query_but" onclick="Add_Query()">Submit Query</a></td></tr></table>
<table><tr><td><input type="text" value="" id="demo" size="75"></td></tr></table>
</form>
 </body>
</html>

and the jsp used to compare the data 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"%>
<%@page import="java.lang.String"%>
<html>
    <head>
    </head>
    <body>
<%

try{
            ResultSet rs=null;
            String Add=request.getParameter("Allocation.text");
            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 Scope1 SET ALLOCATED=?, SPECIALIST=? WHERE DBID='"+Add+"'");
            ps.setTimestamp(1, t);
            ps.setString(2, user);
            /*ps.setString(3, Add_U);*/
            ps.executeUpdate();
            out.println(user);
            out.println(con);
            out.println(t);
            out.println(Add);
            con.commit();
            
             }
        catch(Exception e)
                       {
            out.println(e);
                       }
     
%>

</body>
</html>

Bear Bibeault

Sheriff

Posts: 67637

173

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please read this JspFaq entry.

[Asking smart questions] [About Bear] [Books by Bear]

Rakesh Keerthi

Ranch Hand

Posts: 153

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thank you very much for the suggestion but i'm new to JSP technology and i'm not aware of this subject. please help me with the JSP code

Rakesh Keerthi

Ranch Hand

Posts: 153

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Bear,
could you please help me in solving this using JSP instead of going with JSTL as it is entirely a new concept for me.

Bear Bibeault

Sheriff

Posts: 67637

173

I like...

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

The first sep is to move the Java code out of the JSP and into a servlet controller. Please read this article for information on proper web app structure.

If you are a novice to JSP you should be learning to do things the right way rather than wasting time establishing bad habits that you'll just need to unlearn later.

[Asking smart questions] [About Bear] [Books by Bear]

Stinging nettles are edible. But I really want to see you try to eat this tiny ad:

free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth

https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter