for example first create database name test which has one one table name

I have getting problem to calling stored procedure from
Mysql through JSP. Please help me.

Question Posted / john abraham

1 Answers
6561 Views
I also Faced
E-Mail Answers

Answer Posted / john abraham

for example first create database name test which has one
one table name as johncheck which has one fieldname name1
after tat u have to create stored procedure like this

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`johnchecksp` $$
CREATE PROCEDURE `johnchecksp`(in name1 varchar(50))
BEGIN
insert into johncheck values(name1);
select * from johncheck;
END $$

DELIMITER ;
after you created stored procedure then you have to write
the below coding
this is the jsp code using eclipse

<%@ page language="java" import="java.util.*,java.sql.*"
pageEncoding="ISO-8859-1"%>
<%
String path = request.getContextPath();
String basePath =
request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'select.jsp' starting page</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords"
content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">


</head>
<%!
CallableStatement calstat;
ResultSet rs;
String s1="shiju";
<body>
This is my JSP page. <br>
<%try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn =
DriverManager.getConnection("jdbc:mysql://192.168.1.7:3306/test","java@livicsa",
"Livicsa");
out.println("connected");
calstat=conn.prepareCall("{CALL john_select(s1)}");
out.println("welcome");
//calstat.setString(1,s1);
rs = calstat.executeQuery();
while(rs.next())
{
String name2=rs.getString(1);
out.println("the calue is"+name2);
}
conn.close();
calstat.close();
out.println("Your data has been inserted into table.");
}
catch(Exception e)
{
out.println("the exception is"+e);
}
%>
</body>
</html>

here test is the database name and java@livicsa is username
Livicsa is password .. u have to give your sql username and
password in replace of that place

i hope this code will help you

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is jdbc drivers in java?

929

What do you understand by jdbc datasource?

1027

What is a jdbc url?

902

What is jdbc servlet?

968

any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.

2307

What are 4 drivers available in JDBC? At what situation are four of the drivers used?

963

How many types of JDBC Drivers are present and what are they?

1192

When does the result for an sql statement return null?

923

What is the use of getGeneratedKeys() method in Statement?

1019

What are the differences between execute, executequery, and executeupdate?

956

What is ODBC and JDBC? How do you connect the Database?

1042

How does jdbc connect to database?

882

What is difference between odbc and jdbc?

1026

The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?

2258

How does a file store compare with a jdbc store?

1203