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
6535 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

How can we move the cursor in a scrollable result set?

941

What is namedparameterjdbctemplate?

979

Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

1119

What are the different types of drivers under jdbc?

849

What is odbc. how is it related to sql cli?

1036

How can I determine the isolation levels supported by my DBMS?

986

How do I stop nullpointerexception?

966

Does the JDBC-ODBC Bridge work with Microsoft J++?

2319

How java can be connected to a database?

1094

What are the jdbc api components?

1143

Is jdbc an api?

1073

How can you retrieve data from the resultset using jdbc?

1065

What is a rollback in jdbc?

935

What is jdbc architecture in java?

941

Explain the various types of locking system in jdbc?

877