onfly conversion of jsp to pdf (urgent)

View Answers

September 29, 2008 at 6:37 PM

Hi,

"test.jsp"

In this code having a button "Create Pdf" onClick this button call
method showEmp(); then it send to the url on the proccess page
var url="getuser.jsp?emp_id=E01";

it passes emp_id to "getuser.jsp" and on this page create a Pdf file on th
c:drive with "hello.pdf".

<%@ page import="java.sql.*" %>
<html>
<head>
<style>
A:hover {text-decoration: none;

border: 0px;
font-size:14pt;
color: #2d2b2b; }
</style>

<link rel="stylesheet" type="text/css" href="datepicker.css"/>

<script type="text/javascript">
function trim(str) {
if(!str || typeof str != 'string')
return null;
return str.replace(/^[\s]+/,'').replace(/[\s]+$/,'').replace(/[\s]{2,}/,' ');
}
function showEmp()
{

xmlHttp=GetXmlHttpObject()
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request")
return
}
var url="getuser.jsp?emp_id=E01";
xmlHttp.onreadystatechange=stateChanged
xmlHttp.open("GET",url,true)
xmlHttp.send(null)

}

function stateChanged()
{

if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{

var showdata = xmlHttp.responseText;
if(trim(showdata) =="ok")
{
alert("You are successful create the pdf");
}

}
}

function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
//Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
}
return xmlHttp;
}
</script>

</head>
<body >
<table>
<tr><td><input type="button" name="result" id="result" value="Create Pdf" onclick="showEmp();"></td></tr>

</table>
</form>

</body>
</html>

"getuser.jsp"
<%@ page import="java.sql.*,java.io.*,com.lowagie.text.pdf.*,com.lowagie.text.*,com.lowagie.text.Document
" %>
<%
String emp_id = request.getParameter("emp_id").toString();
String data ="";

Connection conn = null;
String url = "jdbc:mysql://localhost:3306/";;
String dbName = "user_register";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "root";

int sumcount=0;
Statement st;
try {
Class.forName(driver).newInstance();

conn = DriverManager.getConnection(url+dbName,userName,password);
String query = "select * from employee_details where eid='"+emp_id+"'";

st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next())
{
data = rs.getString(2) + " " + rs.getString(3);
}

Document document=new Document();
PdfWriter.getInstance(document,new FileOutputStream("c:\\hello.pdf"));
document.open();
document.add(new Paragraph(data));
document.close();

out.println("ok");
}
catch (Exception e) {
e.printStackTrace();
}
%>

Thanks