I have getting problem to calling stored procedure from
Mysql through JSP. Please help me.
Answer / 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">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</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 |
What is getconnection method in java?
What are the standard isolation levels defined by JDBC?
What is db client?
What is the difference between ojdbc6 and ojdbc7?
Does multiple concurrent open statements per connection are supported by the JDBC-ODBC Bridge?
What is jdbc connection?
Is jdbc part of j2ee?
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
Name the method, which is used to prepare a callablestatement.
In which ways is driver class is registered with drive manager?
How to check jdbc connection in linux?
What is savepoint in jdbc?