accesing session values

Shoaib Bagwan · 2012-03-11T08:11:39+00:00

first page.jsp transporterlist="(a"; Class.forName("org.gjt.mm.mysql.Driver"); con = DriverManager.getConnection(MM_dbConn_STRING,MM_dbConn_USERNAME,MM_dbConn_PASSWORD); con1 =…

Shoaib Bagwan

first page.jsp 
transporterlist="(a"; 
Class.forName("org.gjt.mm.mysql.Driver"); 
con = DriverManager.getConnection(MM_dbConn_STRING,MM_dbConn_USERNAME,MM_dbConn_PASSWORD); 
con1 = DriverManager.getConnection(MM_dbConn_STRING1,MM_dbConn_USERNAME,MM_dbConn_PASSWORD); 
Statement s = con.createStatement(); 
Statement s1 = con1.createStatement(); 
 
 
userrole=session.getAttribute("userrole").toString(); 
user=session.getAttribute("username").toString(); 
String typevalue=session.getAttribute("typevalue").toString(); 
if(typevalue.equals("transporter")){ 
String Transporter=""; 
String sqlassign="select * from db_CustomerComplaints.t_asgndtranstoreps where Representative='"+user+"'"; 
ResultSet rsassign=s.executeQuery(sqlassign); 
while(rsassign.next()){ 
String trans=rsassign.getString("Transporter"); 
Transporter=Transporter+",'"+trans+"'"; 
} 
Transporter=Transporter.substring(2,Transporter.length()); 
System.out.println("Transporter--->"+Transporter); 
sql="select Distinct(OwnerName) as OwnerName from t_vehicledetails where OwnerName not like '%del' and OwnerName IN ('"+Transporter+") order by OwnerName"; 
System.out.println("sql--->"+sql); 
} 
if(userrole.equals("service1")) 
{ 
response.sendRedirect("Received.jsp"); 
} 
 
if(userrole.equals("SIMVendor")) 
{ 
response.sendRedirect("confreprovbyvendor.jsp"); 
} 
 
if(userrole.equals("sales")) 
{ 
sql="select Distinct(OwnerName) as OwnerName from t_vehicledetails where OwnerName not like '%del' order by OwnerName"; 
} 
 
if(userrole.equals("tech")|| userrole.equalsIgnoreCase("supertech")) 
{ 
response.sendRedirect("chkdatafortech.jsp"); 
} 
if(userrole.equals("service")) 
{ 
 
sql="select Distinct(OwnerName) as OwnerName from t_vehicledetails where OwnerName not like '%del' order by OwnerName"; 
 
} 
 
if(userrole.equals("Manager")||userrole.equals("SuperAdmin")) 
{ 
sql="select Distinct(OwnerName) as OwnerName from t_vehicledetails where OwnerName not like '%del' order by OwnerName"; 
} 
if(userrole.equals("Group")) 
{ 
sql="select Distinct(OwnerName) as OwnerName from t_vehicledetails where where OwnerName not like '%del' and GPName='"+user+"' order by OwnerName"; 
} 
if(userrole.equals("Superuser")) 
{ 
sql="select Distinct(OwnerName) as OwnerName from t_vehicledetails where OwnerName not like '%del' order by OwnerName"; 
 
} 
if(userrole.equals("dispatch")) 
{ 
response.sendRedirect("Simtrack.jsp"); 
} 
ResultSet rst1=s1.executeQuery(sql); 
while(rst1.next()) 
{ 
 transporterlist=transporterlist+","+rst1.getString("OwnerName"); 
this is list m passing via session i want to get this list in where clouse of sql query of birt 
} 
transporterlist=transporterlist+")"; 
session.setAttribute("TransporterList",transporterlist); 
response.sendRedirect("homepage.jsp"); 
 
THIS IS MY first JSP PAGE IN WHICH M USING session.setAttribut("...") for setting session value which is list of transporter with comma separated values 
 
my question is how can i convert this jsp report to birt report in which i want to use session value in where clouse of sql query 
also i dont want to create many report for that..... 
 
next is my second.jsp which is actual report 
 
final String userName=session.getAttribute("username").toString(); 
System.out.println("in connection created"); 
final String userRole=session.getAttribute("userrole").toString(); 
System.out.println("in connection created"); 
String transporterlist=session.getAttribute("TransporterList").toString(); 
System.out.println("^^^^^^^^^^^^^^^^^^^transporterlist^^^^^^^^^^"+transporterlist); 
//final String us1=userName.toUpperCase(); 
System.out.println("in connection created"); 
Class.forName(MM_dbConn_DRIVER); 
conn = DriverManager.getConnection(MM_dbConn_STRING,MM_dbConn_USERNAME,MM_dbConn_PASSWORD); 
Statement st=conn.createStatement(); 
System.out.println("in connection created"); 
%> 
<table border="0" width="750px" bgcolor="#E6E6E6" align="center"> 
<tr bgcolor="#BDBDBD"><td align="center">ALL TRANSPORTERS LIST. </td></tr> 
<tr> 
<td> 
<div align="left">Note:Click On Transporter To Go On It's FullFleet Page.</div> 
</td> 
</tr> 
</table> 
 
 
<table border="1" width="100%" align="center" class="sortable"> 
<tr bgcolor="#BDBDBD"> 
<td>Sr.</td> 
<td>Transporter</td> 
</tr> 
<% 
try 
{ 
int i=1; 
transporterlist=transporterlist.substring(3,transporterlist.length()-1); 
transporterlist=transporterlist.replace(",","','"); 
String sql="select Distinct(OwnerName) from db_gps.t_vehicledetails where Status='-' and OwnerName in ('"+transporterlist+"') order by OwnerName"; 
System.out.println(sql); 
ResultSet rs=st.executeQuery(sql); 
while(rs.next()){ 
%> 
<tr> 
<td width="5%"><div align="right"><%=i%></div></td> 
<td width="20%"><a href='fullfleet.jsp?transporter=<%=rs.getString("OwnerName")%>'><%=rs.getString("OwnerName")%></a></td> 
</tr> 
<% 
i++;} 
}catch (Exception e) { 
out.println("<tr><td colspan=2>"); 
out.println("Exception :" + e.getMessage()); 
out.println("Cause : " + e.getCause()); 
out.println("</td></tr>"); 
e.printStackTrace(); 
}finally{ 
%> 
</table> 
<% 
} 
%> 
 
please help me to design the birt report 
 
thanks in advance

Find more posts tagged with

Comments

There are no comments yet