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
6624 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 the difference between jdbc and jndi?

1069

What are the considerations for deciding on transaction boundaries?

1061

Explain about DSN?

1030

What is new in JDBC 2.0?

1098

What are the different types of locking in JDBC?

1062

What is the major difference between java.util.date and java.sql.date data type?

1026

Is java a database?

1015

Why jdbc is used in java?

1005

What is jdbc connection interface?

1083

Does jdbctemplate close connection?

970

What is jdbc thin client in oracle?

952

What is statement and resultset in jdbc?

1018

If you are truncated using JDBC, how can you that how much data is truncated?

1105

Is jdbc open source?

926

What is serialization and deserialization in java programming?

1040