Interested to Buy Any Domain ? << Click Here >> for more details...
I have getting problem to calling stored procedure from
Mysql through JSP. Please help me.
- 1 Answers
- 6460 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">
<!--
<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 |
Post New Answer View All Answers
How to move the cursor in scrollable resultset ?
Why resultset is used in java?
What are clob and blob data types in jdbc?
Is jdbctemplate thread safe?
What is the role of class.forname while loading drivers?
What is jdbc type?
What is data source in java?
Why are we using blob datatypes in jdbc?
If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?
What are the standard isolation levels defined by JDBC?
What is addbatch jdbc?
Explain the process of creating tables using NetBeans IDE?
Does jpa use jdbc?
How can I connect mysql or oracle with java?
Explain the importance of drivermanager.
