 |  |  |  |  |  |  |  |
how to move to another column with increasing rows
Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
hi, my problem is that i have a database where i have stored information month wise of various user and i want that user details in month wise and its shows too but when its move to another column like means in next month like jan to feb its creats a equal rows in each time when ever its move to next column.
so i want that rows sud not create after such number so please help me out if you hav solution because it really making me tired of working with it.
so i want that rows sud not create after such number so please help me out if you hav solution because it really making me tired of working with it.
•
•
Join Date: Feb 2006
Posts: 2,359
Reputation: 
Solved Threads: 252
We would if we had any idea what you were talking about.
Provide the relevant table information, and the code you're using to access it, and a better description of exactly what you expect as compared to what you get.
Provide the relevant table information, and the code you're using to access it, and a better description of exactly what you expect as compared to what you get.
Java Programmer and Sun Systems Administrator
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
Dear Sir
I m making a project which will display the salary report of a financial year monthwise,which is input by the user every month.I have made a table which will display it but it is increasing the row when the next row in the database is read.
my code is
<HTML><HEAD><TITLE>New Document</TITLE>
<BODY>
<input type="hidden" name="sr_no">
<%@ page import="java.util.*" %>
<%@ page import="java.text.*"%>
<%@ page import="java.io.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
<%
String url="jdbc:mysql://localhost/3306/accounting";
//String url="jdbc:odbc:jvaccess";
String host = "localhost"; // default value
String port = "3306"; // default value
String user = "root"; // command line arg 0
String password = ""; // command line arg 1
String database = "accounting"; // command line arg 2
Connection con=null;
PreparedStatement pt;
Statement st;
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database +
"?user=" + user + "&password=" + password);
}
catch(java.lang.ClassNotFoundException e1)
{
System.err.print("Class Not Found Exception: ");
System.err.println(e1.getMessage());
}
st = con.createStatement();
String st1="select month(date_of_receipt),name_of_emp,date_of_join,designation,salary_pack,sal_for_mon,basic_sal,allowance,bonus,arrear,value_of_fringe,con_toprov,other,sub_total,ded_cont_prov_employer,ded_cont_prov_emplee,tds,anyothrded,subtot,netamnt,date_of_receipt from salary_employ";
ResultSet rs=st.executeQuery(st1);
%><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="1006" height="509">
<tr>
<td width="127" height="19"> </td>
<td width="61" height="19">January</td>
<td width="66" height="19">February</td>
<td width="60" height="19">March</td>
<td width="66" height="19">April</td>
<td width="67" height="19">May</td>
<td width="64" height="19">June</td>
<td width="64" height="19">July</td>
<td width="79" height="19">August</td>
<td width="79" height="19">September</td>
<td width="79" height="19">October</td>
<td width="103" height="19">November</td>
<td width="77" height="19">December</td>
</tr><%
while(rs.next())
{
String nameofemp=rs.getString("name_of_emp");
String dateofjoin=rs.getString("date_of_join");
String designation=rs.getString("designation");
String salary_pack=rs.getString("salary_pack");
String sal_for_mon=rs.getString("sal_for_mon");
String basic_sal=rs.getString("basic_sal");
String allowance=rs.getString("allowance");
String bonus=rs.getString("bonus");
String arrear=rs.getString("arrear");
String value_of_fringe=rs.getString("value_of_fringe");
String con_toprov=rs.getString("con_toprov");
String other=rs.getString("other");
String sub_total=rs.getString("sub_total");
String ded_cont_prov_employer=rs.getString("ded_cont_prov_employer");
String ded_cont_prov_emplee=rs.getString("ded_cont_prov_emplee");
String tds=rs.getString("tds");
String anyothrded=rs.getString("anyothrded");
String subtot=rs.getString("subtot");
String netamnt=rs.getString("netamnt");
Integer date_of_receipt=rs.getInt("month(date_of_receipt)");
%>
<tr>
<td width="127" height="19">Basic Salary</td>
<td width="61" height="19"> <%if(date_of_receipt==1)
{
out.println(basic_sal);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==2)
{
out.println(basic_sal);%><%}%></td>
<td width="60" height="19"><%if(date_of_receipt==3)
{
out.println(basic_sal);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==4)
{
out.println(basic_sal);%><%}%></td>
<td width="67" height="19"><%if(date_of_receipt==5)
{
out.println(basic_sal);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==6)
{
out.println(basic_sal);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==7)
{
out.println(basic_sal);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==8)
{
out.println(basic_sal);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==8)
{
out.println(basic_sal);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==10)
{
out.println(basic_sal);%><%}%></td>
<td width="103" height="19"><%if(date_of_receipt==11)
{
out.println(basic_sal);%><%}%></td>
<td width="77" height="19"><%if(date_of_receipt==12)
{
out.println(basic_sal);%><%}%></td>
</tr>
<tr>
<td width="127" height="19">Allowance</td>
<td width="61" height="19"><%if(date_of_receipt==1)
{
out.println(allowance);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==2)
{
out.println(allowance);%><%}%></td>
<td width="60" height="19"><%if(date_of_receipt==3)
{
out.println(allowance);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==4)
{
out.println(allowance);%><%}%> </td>
<td width="67" height="19"><%if(date_of_receipt==5)
{
out.println(allowance);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==6)
{
out.println(allowance);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==7)
{
out.println(allowance);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==8)
{
out.println(allowance);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==9)
{
out.println(allowance);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==10)
{
out.println(allowance);%><%}%></td>
<td width="103" height="19"><%if(date_of_receipt==11)
{
out.println(allowance);%><%}%></td>
<td width="77" height="19"><%if(date_of_receipt==12)
{
out.println(allowance);%><%}%></td>
<tr>
<td width="127" height="40">Bonus</td>
<td width="61" height="40"><%if(date_of_receipt==1)
{
out.println(bonus);%><%}%></td>
<td width="66" height="40"><%if(date_of_receipt==2)
{
out.println(bonus);%><%}%></td>
<td width="60" height="40"><%if(date_of_receipt==3)
{
out.println(bonus);%><%}%></td>
<td width="66" height="40"><%if(date_of_receipt==4)
{
out.println(bonus);%><%}%></td>
<td width="67" height="40"><%if(date_of_receipt==5)
{
out.println(bonus);%><%}%></td>
<td width="64" height="40"><%if(date_of_receipt==6)
{
out.println(bonus);%><%}%></td>
<td width="64" height="40"><%if(date_of_receipt==7)
{
out.println(bonus);%><%}%></td>
<td width="79" height="40"><%if(date_of_receipt==8)
{
out.println(bonus);%><%}%></td>
<td width="79" height="40"><%if(date_of_receipt==9)
{
out.println(bonus);%><%}%></td>
<td width="79" height="40"><%if(date_of_receipt==10)
{
out.println(bonus);%><%}%></td>
<td width="103" height="40"><%if(date_of_receipt==11)
{
out.println(bonus);%><%}%></td>
<td width="77" height="40"><%if(date_of_receipt==12)
{
out.println(bonus);%><%}%></td>
</tr>
<tr>
<td width="127" height="35">Arrear Of Salary</td>
<td width="61" height="35"><%if(date_of_receipt==1)
{
out.println(arrear);%><%}%></td>
<td width="66" height="35"><%if(date_of_receipt==2)
{
out.println(arrear);%><%}%></td>
<td width="60" height="35"><%if(date_of_receipt==3)
{
out.println(arrear);%><%}%></td>
<td width="66" height="35"><%if(date_of_receipt==4)
{
out.println(arrear);%><%}%></td>
<td width="67" height="35"><%if(date_of_receipt==5)
{
out.println(arrear);%><%}%></td>
<td width="64" height="35"><%if(date_of_receipt==6)
{
out.println(arrear);%><%}%></td>
<td width="64" height="35"><%if(date_of_receipt==7)
{
out.println(arrear);%><%}%></td>
<td width="79" height="35"><%if(date_of_receipt==8)
{
out.println(arrear);%><%}%></td>
<td width="79" height="35"><%if(date_of_receipt==9)
{
out.println(arrear);%><%}%></td>
<td width="79" height="35"><%if(date_of_receipt==10)
{
out.println(arrear);%><%}%></td>
<td width="103" height="35"><%if(date_of_receipt==11)
{
out.println(arrear);%><%}%></td>
<td width="77" height="35"><%if(date_of_receipt==12)
{
out.println(arrear);%><%}%></td>
</tr>
<tr>
<td width="127" height="45">Value Of Fringe Benefits</td>
<td width="61" height="45"><%if(date_of_receipt==1)
{
out.println(value_of_fringe);%><%}%></td>
<td width="66" height="45"><%if(date_of_receipt==2)
{
out.println(value_of_fringe);%><%}%></td>
<td width="60" height="45"><%if(date_of_receipt==3)
{
out.println(value_of_fringe);%><%}%></td>
<td width="66" height="45"><%if(date_of_receipt==4)
{
out.println(value_of_fringe);%><%}%></td>
<td width="67" height="45"><%if(date_of_receipt==5)
{
out.println(value_of_fringe);%><%}%></td>
<td width="64" height="45"><%if(date_of_receipt==6)
{
out.println(value_of_fringe);%><%}%></td>
<td width="64" height="45"><%if(date_of_receipt==7)
{
out.println(value_of_fringe);%><%}%></td>
<td width="79" height="45"><%if(date_of_receipt==8)
{
out.println(value_of_fringe);%><%}%></td>
<td width="79" height="45"><%if(date_of_receipt==9)
{
out.println(value_of_fringe);%><%}%></td>
<td width="79" height="45"><%if(date_of_receipt==10)
{
out.println(value_of_fringe);%><%}%></td>
<td width="103" height="45"><%if(date_of_receipt==11)
{
out.println(value_of_fringe);%><%}%></td>
<td width="77" height="45"><%if(date_of_receipt==12)
{
out.println(value_of_fringe);%><%}%></td>
</tr>
<tr>
<td width="127" height="38">Contribution To Provident Fund in Employer</td>
<td width="61" height="38"><%if(date_of_receipt==1)
{
out.println(con_toprov);%><%}%></td>
<td width="66" height="38"><%if(date_of_receipt==2)
{
out.println(con_toprov);%><%}%></td>
<td width="60" height="38"><%if(date_of_receipt==3)
{
out.println(con_toprov);%><%}%></td>
<td width="66" height="38"><%if(date_of_receipt==4)
{
out.println(con_toprov);%><%}%></td>
<td width="67" height="38"><%if(date_of_receipt==5)
{
out.println(con_toprov);%><%}%></td>
<td width="64" height="38"><%if(date_of_receipt==6)
{
out.println(con_toprov);%><%}%></td>
<td width="64" height="38"><%if(date_of_receipt==7)
{
out.println(con_toprov);%><%}%></td>
<td width="79" height="38"><%if(date_of_receipt==8)
{
out.println(con_toprov);%><%}%></td>
<td width="79" height="38"><%if(date_of_receipt==9)
{
out.println(con_toprov);%><%}%></td>
<td width="79" height="38"><%if(date_of_receipt==10)
{
out.println(con_toprov);%><%}%></td>
<td width="103" height="38"><%if(date_of_receipt==11)
{
out.println(con_toprov);%><%}%></td>
<td width="77" height="38"><%if(date_of_receipt==12)
{
out.println(con_toprov);%><%}%></td>
</tr>
<tr>
<td width="127" height="19">Others</td>
<td width="61" height="19"><%if(date_of_receipt==1)
{
out.println(other);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==2)
{
out.println(other);%><%}%></td>
<td width="60" height="19"><%if(date_of_receipt==3)
{
out.println(other);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==4)
{
out.println(other);%><%}%></td>
<td width="67" height="19"><%if(date_of_receipt==5)
{
out.println(other);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==6)
{
out.println(other);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==7)
{
out.println(other);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==8)
{
out.println(other);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==9)
{
out.println(other);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==10)
{
out.println(other);%><%}%></td>
<td width="103" height="19"><%if(date_of_receipt==11)
{
out.println(other);%><%}%></td>
<td width="77" height="19"><%if(date_of_receipt==12)
{
out.println(other);%><%}%></td>
</tr>
<tr>
<td width="127" height="19">Sub Total</td>
<td width="61" height="19"><%if(date_of_receipt==1)
{
out.println(sub_total);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==2)
{
out.println(sub_total);%><%}%></td>
<td width="60" height="19"><%if(date_of_receipt==3)
{
out.println(sub_total);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==4)
{
out.println(sub_total);%><%}%></td>
<td width="67" height="19"><%if(date_of_receipt==5)
{
out.println(sub_total);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==6)
{
out.println(sub_total);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==7)
{
out.println(sub_total);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==8)
{
out.println(sub_total);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==9)
{
out.println(sub_total);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==10)
{
out.println(sub_total);%><%}%></td>
<td width="103" height="19"><%if(date_of_receipt==11)
{
out.println(sub_total);%><%}%></td>
<td width="77" height="19"><%if(date_of_receipt==12)
{
out.println(sub_total);%><%}%></td>
</tr>
<tr><td width="127" height="19">Deduction
</tr>
<tr>
<td width="127" height="57">Contribution To Provident Fund In Employer</td>
<td width="61" height="57"><%if(date_of_receipt==1)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="66" height="57"><%if(date_of_receipt==2)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="60" height="57"><%if(date_of_receipt==3)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="66" height="57"><%if(date_of_receipt==4)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="67" height="57"><%if(date_of_receipt==5)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="64" height="57"><%if(date_of_receipt==6)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="64" height="57"><%if(date_of_receipt==7)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="79" height="57"><%if(date_of_receipt==8)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="79" height="57"><%if(date_of_receipt==9)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="79" height="57"><%if(date_of_receipt==10)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="103" height="57"><%if(date_of_receipt==11)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="77" height="57"><%if(date_of_receipt==12)
{
out.println(ded_cont_prov_employer);%><%}%></td>
</tr>
<tr>
<td width="127" height="44">Contribution To Provident Fund In Employee</td>
<td width="61" height="44"><%if(date_of_receipt==1)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="66" height="44"><%if(date_of_receipt==2)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="60" height="44"><%if(date_of_receipt==3)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="66" height="44"><%if(date_of_receipt==4)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="67" height="44"><%if(date_of_receipt==5)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="64" height="44"><%if(date_of_receipt==6)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="64" height="44"><%if(date_of_receipt==7)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="79" height="44"><%if(date_of_receipt==8)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="79" height="44"><%if(date_of_receipt==9)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="79" height="44"><%if(date_of_receipt==10)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="103" height="44"><%if(date_of_receipt==11)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="77" height="44"><%if(date_of_receipt==12)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
</tr>
<tr>
<td width="127" height="31">Tds</td>
<td width="61" height="31"><%if(date_of_receipt==1)
{
out.println(tds);%><%}%></td>
<td width="66" height="31"><%if(date_of_receipt==2)
{
out.println(tds);%><%}%></td>
<td width="60" height="31"><%if(date_of_receipt==3)
{
out.println(tds);%><%}%></td>
<td width="66" height="31"><%if(date_of_receipt==4)
{
out.println(tds);%><%}%></td>
<td width="67" height="31"><%if(date_of_receipt==5)
{
out.println(tds);%><%}%></td>
<td width="64" height="31"><%if(date_of_receipt==6)
{
out.println(tds);%><%}%></td>
<td width="64" height="31"><%if(date_of_receipt==7)
{
out.println(tds);%><%}%></td>
<td width="79" height="31"><%if(date_of_receipt==8)
{
out.println(tds);%><%}%></td>
<td width="79" height="31"><%if(date_of_receipt==9)
{
out.println(tds);%><%}%></td>
<td width="79" height="31"><%if(date_of_receipt==10)
{
out.println(tds);%><%}%></td>
<td width="103" height="31"><%if(date_of_receipt==11)
{
out.println(tds);%><%}%></td>
<td width="77" height="31"><%if(date_of_receipt==12)
{
out.println(tds);%><%}%></td>
</tr>
<tr>
<td width="127" height="25">Any Other Deduction</td>
<td width="61" height="25"><%if(date_of_receipt==1)
{
out.println(anyothrded);%><%}%></td>
<td width="66" height="25"><%if(date_of_receipt==2)
{
out.println(anyothrded);%><%}%></td>
<td width="60" height="25"><%if(date_of_receipt==3)
{
out.println(anyothrded);%><%}%></td>
<td width="66" height="25"><%if(date_of_receipt==4)
{
out.println(anyothrded);%><%}%></td>
<td width="67" height="25"><%if(date_of_receipt==5)
{
out.println(anyothrded);%><%}%></td>
<td width="64" height="25"><%if(date_of_receipt==6)
{
out.println(anyothrded);%><%}%></td>
<td width="64" height="25"><%if(date_of_receipt==7)
{
out.println(anyothrded);%><%}%></td>
<td width="79" height="25"><%if(date_of_receipt==8)
{
out.println(anyothrded);%><%}%></td>
<td width="79" height="25"><%if(date_of_receipt==9)
{
out.println(anyothrded);%><%}%></td>
<td width="79" height="25"><%if(date_of_receipt==10)
{
out.println(anyothrded);%><%}%></td>
<td width="103" height="25"><%if(date_of_receipt==11)
{
out.println(anyothrded);%><%}%></td>
<td width="77" height="25"><%if(date_of_receipt==12)
{
out.println(anyothrded);%><%}%></td>
</tr>
<tr>
<td width="127" height="28">Sub Total</td>
<td width="61" height="28"><%if(date_of_receipt==1)
{
out.println(subtot);%><%}%></td>
<td width="66" height="28"><%if(date_of_receipt==2)
{
out.println(subtot);%><%}%></td>
<td width="60" height="28"><%if(date_of_receipt==3)
{
out.println(subtot);%><%}%></td>
<td width="66" height="28"><%if(date_of_receipt==4)
{
out.println(subtot);%><%}%></td>
<td width="67" height="28"><%if(date_of_receipt==5)
{
out.println(subtot);%><%}%></td>
<td width="64" height="28"><%if(date_of_receipt==6)
{
out.println(subtot);%><%}%></td>
<td width="64" height="28"><%if(date_of_receipt==7)
{
out.println(subtot);%><%}%></td>
<td width="79" height="28"><%if(date_of_receipt==8)
{
out.println(subtot);%><%}%></td>
<td width="79" height="28"><%if(date_of_receipt==9)
{
out.println(subtot);%><%}%></td>
<td width="79" height="28"><%if(date_of_receipt==10)
{
out.println(subtot);%><%}%></td>
<td width="103" height="28"><%if(date_of_receipt==11)
{
out.println(subtot);%><%}%></td>
<td width="77" height="28"><%if(date_of_receipt==12)
{
out.println(subtot);%><%}%></td>
</tr>
<tr>
<td width="127" height="37">Net Amount</td>
<td width="66" height="37"><%if(date_of_receipt==1)
{
out.println(netamnt);%><%}%></td>
<td width="60" height="37"><%if(date_of_receipt==2)
{
out.println(netamnt);%><%}%></td>
<td width="66" height="37"><%if(date_of_receipt==3)
{
out.println(netamnt);%><%}%></td>
<td width="67" height="37"><%if(date_of_receipt==4)
{
out.println(netamnt);%><%}%></td>
<td width="64" height="37"><%if(date_of_receipt==5)
{
out.println(netamnt);%><%}%></td>
<td width="64" height="37"><%if(date_of_receipt==6)
{
out.println(netamnt);%><%}%></td>
<td width="79" height="37"><%if(date_of_receipt==7)
{
out.println(netamnt);%><%}%></td>
<td width="79" height="37"><%if(date_of_receipt==8)
{
out.println(netamnt);%><%}%></td>
<td width="79" height="37"><%if(date_of_receipt==9)
{
out.println(netamnt);%><%}%></td>
<td width="103" height="37"><%if(date_of_receipt==10)
{
out.println(netamnt);%><%}%></td>
<td width="77" height="37"><%if(date_of_receipt==11)
{
out.println(netamnt);%><%}%></td> <td width="77" height="37"><%if(date_of_receipt==12)
{
out.println(netamnt);%><%}%></td>
</tr>
<%}%></td></tr></table>
thanks in advance
I m making a project which will display the salary report of a financial year monthwise,which is input by the user every month.I have made a table which will display it but it is increasing the row when the next row in the database is read.
my code is
<HTML><HEAD><TITLE>New Document</TITLE>
<BODY>
<input type="hidden" name="sr_no">
<%@ page import="java.util.*" %>
<%@ page import="java.text.*"%>
<%@ page import="java.io.*"%>
<%@ page import="javax.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
<%
String url="jdbc:mysql://localhost/3306/accounting";
//String url="jdbc:odbc:jvaccess";
String host = "localhost"; // default value
String port = "3306"; // default value
String user = "root"; // command line arg 0
String password = ""; // command line arg 1
String database = "accounting"; // command line arg 2
Connection con=null;
PreparedStatement pt;
Statement st;
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + database +
"?user=" + user + "&password=" + password);
}
catch(java.lang.ClassNotFoundException e1)
{
System.err.print("Class Not Found Exception: ");
System.err.println(e1.getMessage());
}
st = con.createStatement();
String st1="select month(date_of_receipt),name_of_emp,date_of_join,designation,salary_pack,sal_for_mon,basic_sal,allowance,bonus,arrear,value_of_fringe,con_toprov,other,sub_total,ded_cont_prov_employer,ded_cont_prov_emplee,tds,anyothrded,subtot,netamnt,date_of_receipt from salary_employ";
ResultSet rs=st.executeQuery(st1);
%><table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="1006" height="509">
<tr>
<td width="127" height="19"> </td>
<td width="61" height="19">January</td>
<td width="66" height="19">February</td>
<td width="60" height="19">March</td>
<td width="66" height="19">April</td>
<td width="67" height="19">May</td>
<td width="64" height="19">June</td>
<td width="64" height="19">July</td>
<td width="79" height="19">August</td>
<td width="79" height="19">September</td>
<td width="79" height="19">October</td>
<td width="103" height="19">November</td>
<td width="77" height="19">December</td>
</tr><%
while(rs.next())
{
String nameofemp=rs.getString("name_of_emp");
String dateofjoin=rs.getString("date_of_join");
String designation=rs.getString("designation");
String salary_pack=rs.getString("salary_pack");
String sal_for_mon=rs.getString("sal_for_mon");
String basic_sal=rs.getString("basic_sal");
String allowance=rs.getString("allowance");
String bonus=rs.getString("bonus");
String arrear=rs.getString("arrear");
String value_of_fringe=rs.getString("value_of_fringe");
String con_toprov=rs.getString("con_toprov");
String other=rs.getString("other");
String sub_total=rs.getString("sub_total");
String ded_cont_prov_employer=rs.getString("ded_cont_prov_employer");
String ded_cont_prov_emplee=rs.getString("ded_cont_prov_emplee");
String tds=rs.getString("tds");
String anyothrded=rs.getString("anyothrded");
String subtot=rs.getString("subtot");
String netamnt=rs.getString("netamnt");
Integer date_of_receipt=rs.getInt("month(date_of_receipt)");
%>
<tr>
<td width="127" height="19">Basic Salary</td>
<td width="61" height="19"> <%if(date_of_receipt==1)
{
out.println(basic_sal);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==2)
{
out.println(basic_sal);%><%}%></td>
<td width="60" height="19"><%if(date_of_receipt==3)
{
out.println(basic_sal);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==4)
{
out.println(basic_sal);%><%}%></td>
<td width="67" height="19"><%if(date_of_receipt==5)
{
out.println(basic_sal);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==6)
{
out.println(basic_sal);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==7)
{
out.println(basic_sal);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==8)
{
out.println(basic_sal);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==8)
{
out.println(basic_sal);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==10)
{
out.println(basic_sal);%><%}%></td>
<td width="103" height="19"><%if(date_of_receipt==11)
{
out.println(basic_sal);%><%}%></td>
<td width="77" height="19"><%if(date_of_receipt==12)
{
out.println(basic_sal);%><%}%></td>
</tr>
<tr>
<td width="127" height="19">Allowance</td>
<td width="61" height="19"><%if(date_of_receipt==1)
{
out.println(allowance);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==2)
{
out.println(allowance);%><%}%></td>
<td width="60" height="19"><%if(date_of_receipt==3)
{
out.println(allowance);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==4)
{
out.println(allowance);%><%}%> </td>
<td width="67" height="19"><%if(date_of_receipt==5)
{
out.println(allowance);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==6)
{
out.println(allowance);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==7)
{
out.println(allowance);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==8)
{
out.println(allowance);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==9)
{
out.println(allowance);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==10)
{
out.println(allowance);%><%}%></td>
<td width="103" height="19"><%if(date_of_receipt==11)
{
out.println(allowance);%><%}%></td>
<td width="77" height="19"><%if(date_of_receipt==12)
{
out.println(allowance);%><%}%></td>
<tr>
<td width="127" height="40">Bonus</td>
<td width="61" height="40"><%if(date_of_receipt==1)
{
out.println(bonus);%><%}%></td>
<td width="66" height="40"><%if(date_of_receipt==2)
{
out.println(bonus);%><%}%></td>
<td width="60" height="40"><%if(date_of_receipt==3)
{
out.println(bonus);%><%}%></td>
<td width="66" height="40"><%if(date_of_receipt==4)
{
out.println(bonus);%><%}%></td>
<td width="67" height="40"><%if(date_of_receipt==5)
{
out.println(bonus);%><%}%></td>
<td width="64" height="40"><%if(date_of_receipt==6)
{
out.println(bonus);%><%}%></td>
<td width="64" height="40"><%if(date_of_receipt==7)
{
out.println(bonus);%><%}%></td>
<td width="79" height="40"><%if(date_of_receipt==8)
{
out.println(bonus);%><%}%></td>
<td width="79" height="40"><%if(date_of_receipt==9)
{
out.println(bonus);%><%}%></td>
<td width="79" height="40"><%if(date_of_receipt==10)
{
out.println(bonus);%><%}%></td>
<td width="103" height="40"><%if(date_of_receipt==11)
{
out.println(bonus);%><%}%></td>
<td width="77" height="40"><%if(date_of_receipt==12)
{
out.println(bonus);%><%}%></td>
</tr>
<tr>
<td width="127" height="35">Arrear Of Salary</td>
<td width="61" height="35"><%if(date_of_receipt==1)
{
out.println(arrear);%><%}%></td>
<td width="66" height="35"><%if(date_of_receipt==2)
{
out.println(arrear);%><%}%></td>
<td width="60" height="35"><%if(date_of_receipt==3)
{
out.println(arrear);%><%}%></td>
<td width="66" height="35"><%if(date_of_receipt==4)
{
out.println(arrear);%><%}%></td>
<td width="67" height="35"><%if(date_of_receipt==5)
{
out.println(arrear);%><%}%></td>
<td width="64" height="35"><%if(date_of_receipt==6)
{
out.println(arrear);%><%}%></td>
<td width="64" height="35"><%if(date_of_receipt==7)
{
out.println(arrear);%><%}%></td>
<td width="79" height="35"><%if(date_of_receipt==8)
{
out.println(arrear);%><%}%></td>
<td width="79" height="35"><%if(date_of_receipt==9)
{
out.println(arrear);%><%}%></td>
<td width="79" height="35"><%if(date_of_receipt==10)
{
out.println(arrear);%><%}%></td>
<td width="103" height="35"><%if(date_of_receipt==11)
{
out.println(arrear);%><%}%></td>
<td width="77" height="35"><%if(date_of_receipt==12)
{
out.println(arrear);%><%}%></td>
</tr>
<tr>
<td width="127" height="45">Value Of Fringe Benefits</td>
<td width="61" height="45"><%if(date_of_receipt==1)
{
out.println(value_of_fringe);%><%}%></td>
<td width="66" height="45"><%if(date_of_receipt==2)
{
out.println(value_of_fringe);%><%}%></td>
<td width="60" height="45"><%if(date_of_receipt==3)
{
out.println(value_of_fringe);%><%}%></td>
<td width="66" height="45"><%if(date_of_receipt==4)
{
out.println(value_of_fringe);%><%}%></td>
<td width="67" height="45"><%if(date_of_receipt==5)
{
out.println(value_of_fringe);%><%}%></td>
<td width="64" height="45"><%if(date_of_receipt==6)
{
out.println(value_of_fringe);%><%}%></td>
<td width="64" height="45"><%if(date_of_receipt==7)
{
out.println(value_of_fringe);%><%}%></td>
<td width="79" height="45"><%if(date_of_receipt==8)
{
out.println(value_of_fringe);%><%}%></td>
<td width="79" height="45"><%if(date_of_receipt==9)
{
out.println(value_of_fringe);%><%}%></td>
<td width="79" height="45"><%if(date_of_receipt==10)
{
out.println(value_of_fringe);%><%}%></td>
<td width="103" height="45"><%if(date_of_receipt==11)
{
out.println(value_of_fringe);%><%}%></td>
<td width="77" height="45"><%if(date_of_receipt==12)
{
out.println(value_of_fringe);%><%}%></td>
</tr>
<tr>
<td width="127" height="38">Contribution To Provident Fund in Employer</td>
<td width="61" height="38"><%if(date_of_receipt==1)
{
out.println(con_toprov);%><%}%></td>
<td width="66" height="38"><%if(date_of_receipt==2)
{
out.println(con_toprov);%><%}%></td>
<td width="60" height="38"><%if(date_of_receipt==3)
{
out.println(con_toprov);%><%}%></td>
<td width="66" height="38"><%if(date_of_receipt==4)
{
out.println(con_toprov);%><%}%></td>
<td width="67" height="38"><%if(date_of_receipt==5)
{
out.println(con_toprov);%><%}%></td>
<td width="64" height="38"><%if(date_of_receipt==6)
{
out.println(con_toprov);%><%}%></td>
<td width="64" height="38"><%if(date_of_receipt==7)
{
out.println(con_toprov);%><%}%></td>
<td width="79" height="38"><%if(date_of_receipt==8)
{
out.println(con_toprov);%><%}%></td>
<td width="79" height="38"><%if(date_of_receipt==9)
{
out.println(con_toprov);%><%}%></td>
<td width="79" height="38"><%if(date_of_receipt==10)
{
out.println(con_toprov);%><%}%></td>
<td width="103" height="38"><%if(date_of_receipt==11)
{
out.println(con_toprov);%><%}%></td>
<td width="77" height="38"><%if(date_of_receipt==12)
{
out.println(con_toprov);%><%}%></td>
</tr>
<tr>
<td width="127" height="19">Others</td>
<td width="61" height="19"><%if(date_of_receipt==1)
{
out.println(other);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==2)
{
out.println(other);%><%}%></td>
<td width="60" height="19"><%if(date_of_receipt==3)
{
out.println(other);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==4)
{
out.println(other);%><%}%></td>
<td width="67" height="19"><%if(date_of_receipt==5)
{
out.println(other);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==6)
{
out.println(other);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==7)
{
out.println(other);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==8)
{
out.println(other);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==9)
{
out.println(other);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==10)
{
out.println(other);%><%}%></td>
<td width="103" height="19"><%if(date_of_receipt==11)
{
out.println(other);%><%}%></td>
<td width="77" height="19"><%if(date_of_receipt==12)
{
out.println(other);%><%}%></td>
</tr>
<tr>
<td width="127" height="19">Sub Total</td>
<td width="61" height="19"><%if(date_of_receipt==1)
{
out.println(sub_total);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==2)
{
out.println(sub_total);%><%}%></td>
<td width="60" height="19"><%if(date_of_receipt==3)
{
out.println(sub_total);%><%}%></td>
<td width="66" height="19"><%if(date_of_receipt==4)
{
out.println(sub_total);%><%}%></td>
<td width="67" height="19"><%if(date_of_receipt==5)
{
out.println(sub_total);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==6)
{
out.println(sub_total);%><%}%></td>
<td width="64" height="19"><%if(date_of_receipt==7)
{
out.println(sub_total);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==8)
{
out.println(sub_total);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==9)
{
out.println(sub_total);%><%}%></td>
<td width="79" height="19"><%if(date_of_receipt==10)
{
out.println(sub_total);%><%}%></td>
<td width="103" height="19"><%if(date_of_receipt==11)
{
out.println(sub_total);%><%}%></td>
<td width="77" height="19"><%if(date_of_receipt==12)
{
out.println(sub_total);%><%}%></td>
</tr>
<tr><td width="127" height="19">Deduction
</tr>
<tr>
<td width="127" height="57">Contribution To Provident Fund In Employer</td>
<td width="61" height="57"><%if(date_of_receipt==1)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="66" height="57"><%if(date_of_receipt==2)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="60" height="57"><%if(date_of_receipt==3)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="66" height="57"><%if(date_of_receipt==4)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="67" height="57"><%if(date_of_receipt==5)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="64" height="57"><%if(date_of_receipt==6)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="64" height="57"><%if(date_of_receipt==7)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="79" height="57"><%if(date_of_receipt==8)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="79" height="57"><%if(date_of_receipt==9)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="79" height="57"><%if(date_of_receipt==10)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="103" height="57"><%if(date_of_receipt==11)
{
out.println(ded_cont_prov_employer);%><%}%></td>
<td width="77" height="57"><%if(date_of_receipt==12)
{
out.println(ded_cont_prov_employer);%><%}%></td>
</tr>
<tr>
<td width="127" height="44">Contribution To Provident Fund In Employee</td>
<td width="61" height="44"><%if(date_of_receipt==1)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="66" height="44"><%if(date_of_receipt==2)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="60" height="44"><%if(date_of_receipt==3)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="66" height="44"><%if(date_of_receipt==4)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="67" height="44"><%if(date_of_receipt==5)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="64" height="44"><%if(date_of_receipt==6)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="64" height="44"><%if(date_of_receipt==7)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="79" height="44"><%if(date_of_receipt==8)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="79" height="44"><%if(date_of_receipt==9)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="79" height="44"><%if(date_of_receipt==10)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="103" height="44"><%if(date_of_receipt==11)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
<td width="77" height="44"><%if(date_of_receipt==12)
{
out.println(ded_cont_prov_emplee);%><%}%></td>
</tr>
<tr>
<td width="127" height="31">Tds</td>
<td width="61" height="31"><%if(date_of_receipt==1)
{
out.println(tds);%><%}%></td>
<td width="66" height="31"><%if(date_of_receipt==2)
{
out.println(tds);%><%}%></td>
<td width="60" height="31"><%if(date_of_receipt==3)
{
out.println(tds);%><%}%></td>
<td width="66" height="31"><%if(date_of_receipt==4)
{
out.println(tds);%><%}%></td>
<td width="67" height="31"><%if(date_of_receipt==5)
{
out.println(tds);%><%}%></td>
<td width="64" height="31"><%if(date_of_receipt==6)
{
out.println(tds);%><%}%></td>
<td width="64" height="31"><%if(date_of_receipt==7)
{
out.println(tds);%><%}%></td>
<td width="79" height="31"><%if(date_of_receipt==8)
{
out.println(tds);%><%}%></td>
<td width="79" height="31"><%if(date_of_receipt==9)
{
out.println(tds);%><%}%></td>
<td width="79" height="31"><%if(date_of_receipt==10)
{
out.println(tds);%><%}%></td>
<td width="103" height="31"><%if(date_of_receipt==11)
{
out.println(tds);%><%}%></td>
<td width="77" height="31"><%if(date_of_receipt==12)
{
out.println(tds);%><%}%></td>
</tr>
<tr>
<td width="127" height="25">Any Other Deduction</td>
<td width="61" height="25"><%if(date_of_receipt==1)
{
out.println(anyothrded);%><%}%></td>
<td width="66" height="25"><%if(date_of_receipt==2)
{
out.println(anyothrded);%><%}%></td>
<td width="60" height="25"><%if(date_of_receipt==3)
{
out.println(anyothrded);%><%}%></td>
<td width="66" height="25"><%if(date_of_receipt==4)
{
out.println(anyothrded);%><%}%></td>
<td width="67" height="25"><%if(date_of_receipt==5)
{
out.println(anyothrded);%><%}%></td>
<td width="64" height="25"><%if(date_of_receipt==6)
{
out.println(anyothrded);%><%}%></td>
<td width="64" height="25"><%if(date_of_receipt==7)
{
out.println(anyothrded);%><%}%></td>
<td width="79" height="25"><%if(date_of_receipt==8)
{
out.println(anyothrded);%><%}%></td>
<td width="79" height="25"><%if(date_of_receipt==9)
{
out.println(anyothrded);%><%}%></td>
<td width="79" height="25"><%if(date_of_receipt==10)
{
out.println(anyothrded);%><%}%></td>
<td width="103" height="25"><%if(date_of_receipt==11)
{
out.println(anyothrded);%><%}%></td>
<td width="77" height="25"><%if(date_of_receipt==12)
{
out.println(anyothrded);%><%}%></td>
</tr>
<tr>
<td width="127" height="28">Sub Total</td>
<td width="61" height="28"><%if(date_of_receipt==1)
{
out.println(subtot);%><%}%></td>
<td width="66" height="28"><%if(date_of_receipt==2)
{
out.println(subtot);%><%}%></td>
<td width="60" height="28"><%if(date_of_receipt==3)
{
out.println(subtot);%><%}%></td>
<td width="66" height="28"><%if(date_of_receipt==4)
{
out.println(subtot);%><%}%></td>
<td width="67" height="28"><%if(date_of_receipt==5)
{
out.println(subtot);%><%}%></td>
<td width="64" height="28"><%if(date_of_receipt==6)
{
out.println(subtot);%><%}%></td>
<td width="64" height="28"><%if(date_of_receipt==7)
{
out.println(subtot);%><%}%></td>
<td width="79" height="28"><%if(date_of_receipt==8)
{
out.println(subtot);%><%}%></td>
<td width="79" height="28"><%if(date_of_receipt==9)
{
out.println(subtot);%><%}%></td>
<td width="79" height="28"><%if(date_of_receipt==10)
{
out.println(subtot);%><%}%></td>
<td width="103" height="28"><%if(date_of_receipt==11)
{
out.println(subtot);%><%}%></td>
<td width="77" height="28"><%if(date_of_receipt==12)
{
out.println(subtot);%><%}%></td>
</tr>
<tr>
<td width="127" height="37">Net Amount</td>
<td width="66" height="37"><%if(date_of_receipt==1)
{
out.println(netamnt);%><%}%></td>
<td width="60" height="37"><%if(date_of_receipt==2)
{
out.println(netamnt);%><%}%></td>
<td width="66" height="37"><%if(date_of_receipt==3)
{
out.println(netamnt);%><%}%></td>
<td width="67" height="37"><%if(date_of_receipt==4)
{
out.println(netamnt);%><%}%></td>
<td width="64" height="37"><%if(date_of_receipt==5)
{
out.println(netamnt);%><%}%></td>
<td width="64" height="37"><%if(date_of_receipt==6)
{
out.println(netamnt);%><%}%></td>
<td width="79" height="37"><%if(date_of_receipt==7)
{
out.println(netamnt);%><%}%></td>
<td width="79" height="37"><%if(date_of_receipt==8)
{
out.println(netamnt);%><%}%></td>
<td width="79" height="37"><%if(date_of_receipt==9)
{
out.println(netamnt);%><%}%></td>
<td width="103" height="37"><%if(date_of_receipt==10)
{
out.println(netamnt);%><%}%></td>
<td width="77" height="37"><%if(date_of_receipt==11)
{
out.println(netamnt);%><%}%></td> <td width="77" height="37"><%if(date_of_receipt==12)
{
out.println(netamnt);%><%}%></td>
</tr>
<%}%></td></tr></table>
thanks in advance
Last edited by shweta797; Dec 11th, 2007 at 5:40 am.
•
•
Join Date: Feb 2006
Posts: 2,359
Reputation:
Solved Threads: 252
Well, first of all, use a Connection Pool. Don't make a connection everytime the JSP is called, that is just plain bad practice.
Secondly, move all this stuff out into a Bean where it should be. All this Scriptlet stuff is wholly unmanageable.
And seem to be reading the data a row at a time, but want to fill the table a column at a time. And you seem to be doing this by outputting, essentially, an entire table for each row with only one column being populated. So I need to ask why you thought that would work?
You need to read all of the data storing it into a multidimensional array to arrange it properly, then you can output the array a "row" at a time and get the display right. But that is the last I am going to say on the topic until you get rid of all this scriptlet junk.
Secondly, move all this stuff out into a Bean where it should be. All this Scriptlet stuff is wholly unmanageable.
And seem to be reading the data a row at a time, but want to fill the table a column at a time. And you seem to be doing this by outputting, essentially, an entire table for each row with only one column being populated. So I need to ask why you thought that would work?
You need to read all of the data storing it into a multidimensional array to arrange it properly, then you can output the array a "row" at a time and get the display right. But that is the last I am going to say on the topic until you get rid of all this scriptlet junk.
Java Programmer and Sun Systems Administrator
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
----------------------------------------------
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.
--Brian Kernighan
|
Similar Threads
- memory management in wndows 2000 (Windows NT / 2000 / XP)
Other Threads in the JSP Forum
- Previous Thread: JSP - Questions
- Next Thread: logout problem
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest JSP Posts
- Today's Posts
- Unanswered Threads
apache backbutton combobox connection database development directorystructure dynamicpagetitles eclipse frames glassfish ie8 imagetodatabse imageupload integer internet java javaee javascript jsf jsp jsppagetitles levels mvc2 mvcmodel2 network parameters passing ping printinserverinsteadofclient redirect request.getparameter response servlet servletdopost()readxml sessions software ssl state_saving_method stocks sun tomcat tutorial update video web
