Displaying db retrieved values in JSP

[jith87]

I m using MySql as back end n JSP as front end and the connectivity using JDBC. I ve to display a record retrieved from the db in the JSP page.

public void view_per_profile()
{
Connection con = null;ResultSet rs = null;
CallableStatement cstmtm = null;
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
System.out.println("Good to go");
con = DriverManager.getConnection("jdbc:mysql://localhost/test1","root", "sivaji");
cstmtm = con.prepareCall("{call viewp}");
rs = cstmtm.executeQuery();
 
rs.first();
title = cstmtm.getString(1);
first_name = cstmtm.getString(2);
middle_name = cstmtm.getString(3);
last_name = cstmtm.getString(4);
dob = cstmtm.getDate(5);
email_id = cstmtm.getString(6);
reg_no = cstmtm.getLong(7);
day_num = cstmtm.getInt(8);
sec_email = cstmtm.getString(9);
 
if(!con.isClosed())
{
cstmtm.close();
System.out.println("Connected to MySQL server");
}
if(con != null)
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
 

MySql Stored Procedure

create procedure viewp()
begin
select * from per where title = 'Ms';
end
 

I m getting the error java.sql.SQLException: No output parameters registered.Pls help me out...

Thanx in advance.................

[r035198x]

I m using MySql as back end n JSP as front end and the connectivity using JDBC. I ve to display a record retrieved from the db in the JSP page.

public void view_per_profile()
{
Connection con = null;ResultSet rs = null;
CallableStatement cstmtm = null;
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
System.out.println("Good to go");
con = DriverManager.getConnection("jdbc:mysql://localhost/test1","root", "sivaji");
cstmtm = con.prepareCall("{call viewp}");
rs = cstmtm.executeQuery();
 
rs.first();
title = cstmtm.getString(1);
first_name = cstmtm.getString(2);
middle_name = cstmtm.getString(3);
last_name = cstmtm.getString(4);
dob = cstmtm.getDate(5);
email_id = cstmtm.getString(6);
reg_no = cstmtm.getLong(7);
day_num = cstmtm.getInt(8);
sec_email = cstmtm.getString(9);
 
if(!con.isClosed())
{
cstmtm.close();
System.out.println("Connected to MySQL server");
}
if(con != null)
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
 

MySql Stored Procedure

create procedure viewp()
begin
select * from per where title = 'Ms';
end
 

I m getting the error java.sql.SQLException: No output parameters registered.Pls help me out...

Thanx in advance.................

Perhaps you should go through a tutorial on procedures before you start using them. Why are you using a procedure for a a simple select statement anyway?

[jith87]

This is jus a prototype i m creating so that i get well versed in this concept....In the actual program its going to be multiple statements....

[r035198x]

This is jus a prototype i m creating so that i get well versed in this concept....In the actual program its going to be multiple statements....

Well you'll need to read a tutorial on procedures then. You don't get procedure results in a resultselt set like that.