how to pass the parameter in callable statement

Ads
 

how to pass the parameter in callable statement

calstat=conn.prepareCall("{call studentrc(?,?,?,?,?)}"); // it show error parameter value is null calstat.setString(1,tname.getText()); calstat.setString(2, tmark1.getText()); calstat.setString(3, tmark2.getText()); calstat.setString(4, ttotal.getText()); calstat.setString(5, treg.getText()); calstat.executeUpdate(); //JOptionPane.showMessageDialog(null,"Data successfully Updated to the database"); //System.out.println(ps); pr.close(); }

i create in mysql stored procedure

delimiter // create procedure studentrcs(sname varchar(20),smark1 int(3),smark2 int(3),stotal int(10),inout Regno int(6)) begin UPDATE studentrecords set studentname=sname,mark1=smark1,mark2=smark2,total=stotal where Regno=Regno; end;//

how can i pass the parameter here ... kindly help me out to solve this problem..

View Answers

Ads









Related Tutorials/Questions & Answers:
how to pass the parameter in callable statement
how to pass the parameter in callable statement  calstat=conn.prepareCall("{call studentrc(?,?,?,?,?)}"); // it show error parameter value is null...=smark1,mark2=smark2,total=stotal where Regno=Regno; end;// how can i pass the parameter
How to pass parameter through drop down list using session management in jsp??
How to pass parameter through drop down list using session management in jsp??  How to pass parameter through drop down list in the URL and access it on same jsp page using session management
Advertisements
callable statement,stored procedure for insert data and also for update data into oracle database using jsp
callable statement,stored procedure for insert data and also for update data into oracle database using jsp  iam a fresher newbie to softparsing i have one task to do soft parsing tl asked to do callable statement,stored
how to pass command line arguments in ant
how to pass command line arguments in ant  How to pass runtime values ie commandline arguments to a program written in java using ant tool
How to break statement in JSP
How to break statement in JSP  Hi, I am writing JSP page and there is for loop inside it. How to break statement in JSP? Thanks   Hi, I JSP you can use the break statement to break a loop. Here is simple example
How to break statement in JSP
How to break statement in JSP  Hi, I am writing JSP page and there is for loop inside it. How to break statement in JSP? Thanks   Hi, I JSP you can use the break statement to break a loop. Here is simple example
How to break statement in JSP
How to break statement in JSP  Hi, I am writing JSP page and there is for loop inside it. How to break statement in JSP? Thanks   Hi, I JSP you can use the break statement to break a loop. Here is simple example
How to break statement in JSP
How to break statement in JSP  Hi, I am writing JSP page and there is for loop inside it. How to break statement in JSP? Thanks   Hi, I JSP you can use the break statement to break a loop. Here is simple example
how many max. arguments we pass to the any function ? how many max. arguments we pass to the any function ?
how many max. arguments we pass to the any function ? how many max. arguments we pass to the any function ?   how many max. arguments we pass to the any function
How to pass an arraylist from servlet to jsp?
How to pass an arraylist from servlet to jsp?  Hello, Can anyone please tell me how to pass an arraylist from servlet to jsp? I have two arraylist one of type String and the other int. How to send both the arraylists from
How to pass javascript variable in Scriplet of JSP?
How to pass javascript variable in Scriplet of JSP?  How can I assign the value of a javascript variable to a variable declared in jsp scriplet? Is it possible
How to pass multiple values from a servlet to JSP?
How to pass multiple values from a servlet to JSP?  hi, I want to pass multiple values form a servlet to JSP. Hw do i do that? I am able to send one value at a time without any prb, but I am unable to carry multiple (from two
In Struts 2 how to pass the <s: property value=''
In Struts 2 how to pass the s: property value'  In Struts 2 how to pass the s: property value' I have page where i display the list of treasury... this data.jsp from that DB and display the same in a page. How do i send
How to pass command line arguments in Java?
How to pass command line arguments in Java?  Hi, In a Java program I have to write for reading the command line arguments and use it in a programming. How to pass command line arguments in Java? Share me the sample code
how to pass a string from one class to another
how to pass a string from one class to another  hi all, Good morning. I am trying to develop a coding pass a string from one class and declare in other class. the string which i need to pass is the data from an file and i want
ModuleNotFoundError: No module named 'callable'
'callable' How to remove the ModuleNotFoundError: No module named 'callable...ModuleNotFoundError: No module named 'callable'  Hi, My Python... to install padas library. You can install callable python with following
How to pass the value from controller to jsp page ?
How to pass the value from controller to jsp page ?  HI I need to pass the value from controller to jsp. I use the way like this Controller request.setAttribute("msg", "Successfully Login"); In jsp ${msg} and then i
callable interface
callable interface  When we use the callable interface instated of runable interface
[JSP] How to pass back ID to previous page.
[JSP] How to pass back ID to previous page.  Hi experts, May I ask something. How to link a page to previous page which the content in previous page is selected from database where IDPRODUCT=". I don't know how to pass back
How can i pass the valus from a JSP to the action class???
How can i pass the valus from a JSP to the action class???  hewllo wevryone... can anyone help me with how i can pass the value of menuId in my JSP and pass it in the action class
how many max. arguments we pass to the any function ?
how many max. arguments we pass to the any function ?   how many max. arguments we pass to the any function
SQL Out Parameter
SQL Out Parameter       SQL Out Parameter allows the stored procedure to the pass data... an example from SQL Out Parameter .In this Example we create a procedure 'abc
Passing a parameter using URL string
Passing a parameter using URL string  How to pass a parameter using the URL string in a JSF application
How to use select Statement in MySQL?
How to use select Statement in MySQL?  Hi, How to use select Statement in MySQL? I want to learn the various ways to use the SQL select statement... the select statement in MySQL Suppose we have following table: CREATE TABLE
in string how will write the return statement..........?
in string how will write the return statement..........?  import java.util.Scanner; class BinaryConversion12{ static int j=1; static int l=1; public static void main(String args[]){ int i=Integer.parseInt(args[0
how to value of one variable pass in other variable in revetse order
how to value of one variable pass in other variable in revetse order  Like variable a=367 b must have valuev763
How to Pass data from jTextField1 in jFrame1 to jLabel1 in jFrame2
How to Pass data from jTextField1 in jFrame1 to jLabel1 in jFrame2  I have a Form login_pass (jFrame) which has a jTextField1 to take input (employee... the user press login button present in the Form login_pass (jFrame) Please Help
ModuleNotFoundError: No module named 'callable-pip'
'callable-pip' How to remove the ModuleNotFoundError: No module named 'callable-pip' error? Thanks   Hi, In your python...ModuleNotFoundError: No module named 'callable-pip'  Hi, My Python
ModuleNotFoundError: No module named 'ctypes-callable'
named 'ctypes-callable' How to remove the ModuleNotFoundError: No module named 'ctypes-callable' error? Thanks   Hi, In your python...ModuleNotFoundError: No module named 'ctypes-callable'  Hi, My
ModuleNotFoundError: No module named 'ctypes-callable'
named 'ctypes-callable' How to remove the ModuleNotFoundError: No module named 'ctypes-callable' error? Thanks   Hi, In your python...ModuleNotFoundError: No module named 'ctypes-callable'  Hi, My
ModuleNotFoundError: No module named 'flit_callable'
'flit_callable' How to remove the ModuleNotFoundError: No module named 'flit_callable' error? Thanks   Hi, In your python...ModuleNotFoundError: No module named 'flit_callable'  Hi, My

Ads