All about albert sie

help me in time comparison

i have the code like this

but the current time that i get is in string type and i need to compare the time inside the database which is in time datatype..

how can i solve this problem...
please help me i stuck

17 years ago

Java in General

problem with my insert data page

how to using new statement?

17 years ago

JDBC and Relational Databases

problem with my insert data page

<%@ page import="java.net.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>Untitled</title>
</head>
<body>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
}
catch (Exception E) {
out.println("Unable to load driver.");
E.printStackTrace();
}
try{
Connection C = DriverManager.getConnection("jdbc:mysql://localhost/attendance","root","");
Statement S = C.createStatement();
//ResultSet rs = S.executeQuery("SELECT count(student_id) as attendDay,tsubject,name,email,course_desc from attend group by tsubject,student_id;");
ResultSet rs=S.executeQuery("SELECT (t.maxClass*70/100) as barClass,count(a.student_id) as attendDay,a.tsubject,a.name,a.email,a.course_desc FROM tsubject as t,attend as a"+
" where a.tsubject=t.tsubject_desc Group by tsubject,student_id;");
ResultSetMetaData rsStruc = rs.getMetaData();
while (rs.next()) {
int barClass=rs.getInt("barClass");
int attendday=rs.getInt("attendDay");
String subject=rs.getString("tsubject");
String name=rs.getString("name");
String email=rs.getString("email");
String course=rs.getString("course_desc");
if(attendday < barClass){
S.executeUpdate("INSERT INTO bar (stu_name,course,tsubject,email) values ('"+name+"','"+course+"','"+subject+"','"+email+"')");
}
}
rs.close();
C.close();
}
catch (Exception E) {
out.println("SQLException: " + E.getMessage());
}
%>
</body>
</html>

suppose the program will check whether the attendday < barClass if yes insert into the database. it should be more than 1 data will be insert. but when run this page error come out "Operation not allowed after ResultSet closed" juz 1 data been insert into database. is it my coding problem and how i gotta to solve my problem??

17 years ago

JDBC and Relational Databases

headache can someone help me in this

declare at outside just ca let me to get the last data in the vector

17 years ago

JSP

headache can someone help me in this

<%@ page import="java.net.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>Untitled</title>
</head>
<body>
<%
Vector mail = new Vector();
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch (Exception E) {
out.println("Unable to load driver.");
E.printStackTrace();
}
try{
Connection C = DriverManager.getConnection("jdbc:mysql://localhost/attendance","root","");
%>
<div align="center"><font size="+6">Student BarList</font><br>
In this page will display out the student that attendance NOT MORE THAN 70%. The Student Below is NOT ALLOW to take exam for the relevant subject.
The student whoever not satisfy with the bar can negotiate with the lecturer of the relevant subject.<p/>
The student below will be bar from the relevent subject:<br/>
<%Statement S = C.createStatement();
ResultSet rs = S.executeQuery("SELECT * FROM bar");
ResultSetMetaData rsStruc = rs.getMetaData();
out.println("<table bgcolor=red cellpadding=10 cellspacing=1 size=70>");
out.println("<tr bgcolor=red>");
int colCount = rsStruc.getColumnCount();
String colName = "";
for(int i=1;i <= colCount; i++){
colName = rsStruc.getColumnName(i) ;
out.println("<td><B><font color=white>" + colName + "</font></b></td>\n");
}
out.println("</tr>");
while (rs.next()) {
String email=rs.getString("email");
mail.addElement(email);
out.println("<tr bgcolor=ffffff>");
for(int i=1;i <= colCount; i++){
colName = rsStruc.getColumnName(i) ;
String fld = rs.getString(colName);
out.println("<td>" + fld + "</td>");
}
out.println("</tr>");
}
out.println("</table>");
rs.close();
C.close();}
catch (Exception E) {
out.println("SQLException: " + E.getMessage());
}
for(int i=0; i< mail.size(); i++){
String add= mail.elementAt(i)+",";
out.println(add);
}
%>
<form action="simplemail.jsp" method="post">
<input type="text" name="address" value="<%=add%>">
<input type="submit" name="send" value="Send Mail">
</body>
</html>

i already change my page but i still getting error:

An error occurred at line: 65 in the jsp file: /report.jsp
Generated servlet error:
add cannot be resolved

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

What is this proble actually or have other method to let me do this?

17 years ago

JSP

system time and day

how can i get the current system time (eg. 11:00:00) and current system day (eg. Thursday) in java?

17 years ago

Java in General

headache can someone help me in this

<%@ page import="java.net.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%
Vector mail = new Vector();
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch (Exception E) {
out.println("Unable to load driver.");
E.printStackTrace();
}
try{
Connection C = DriverManager.getConnection("jdbc:mysql://localhost/attendance","root","");
out.println("<div align=center>"+"<font size=+6>"+"Student BarList"+"</font>"+"<br>");
out.println("In this page will display out the student that attendance NOT MORE THAN 70%. The Student Below is NOT ALLOW to take exam for the relevant subject."+
"The student whoever not satisfy with the bar can negotiate with the lecturer of the relevant subject.");
out.println("The student below will be bar from the relevent subject:" + "<br>\n");
Statement S = C.createStatement();
ResultSet rs = S.executeQuery("SELECT * FROM bar");
ResultSetMetaData rsStruc = rs.getMetaData();
out.println("<table bgcolor=red cellpadding=10 cellspacing=1 size=70>");
out.println("<tr bgcolor=red>");
int colCount = rsStruc.getColumnCount();
String colName = "";
for(int i=1;i <= colCount; i++){
colName = rsStruc.getColumnName(i) ;
out.println("<td><B><font color=white>" + colName + "</font></b></td>\n");
}
out.println("</tr>");
while (rs.next()) {
String email=rs.getString("email");
mail.addElement(email);
out.println("<tr bgcolor=ffffff>");
for(int i=1;i <= colCount; i++){
colName = rsStruc.getColumnName(i) ;
String fld = rs.getString(colName);
out.println("<td>" + fld + "</td>");
}
out.println("</tr>");
}
out.println("</table>");
rs.close();
C.close();
}
catch (Exception E) {
out.println("SQLException: " + E.getMessage());
}
//System.out.println(add);
out.println("<form action=simplemail.jsp method=post>");
//for (Enumeration e = mail.elements(); e.hasMoreElements();)
//{
for(int i=0; i< mail.size(); i++){
String add= mail.elementAt(i)+",";
out.println(add);
}
out.println("<input type=text name=address value="+add+">");
out.println("<input type=submit name=send value=Send Mail>");
out.println("</form>"+"</div>");
%>

actually i want to read the data inside the vector then put it inside the textbox value to make it can be post to the next page. how i need to do this
[ March 12, 2007: Message edited by: Bear Bibeault ]

17 years ago

JSP

problem with my page

this is my coding:

<%@ page import="java.net.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%
Vector mail = new Vector ();
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}
catch (Exception E) {
out.println("Unable to load driver.");
E.printStackTrace();
}
try{
Connection C = DriverManager.getConnection("jdbc:mysql://localhost/attendance","root","");
out.println("<div align=center>"+"<font size=+6>"+"Student BarList"+"</font>"+"<br>");
out.println("In this page will display out the student that attendance NOT MORE THAN 70%. The Student Below is NOT ALLOW to take exam for the relevant subject."+
"The student whoever not satisfy with the bar can negotiate with the lecturer of the relevant subject.");
out.println("The student below will be bar from the relevent subject:" + "<br>\n");
Statement S = C.createStatement();
ResultSet rs = S.executeQuery("SELECT * FROM bar");
ResultSetMetaData rsStruc = rs.getMetaData();
out.println("<table bgcolor=red cellpadding=10 cellspacing=1 size=70>");
out.println("<tr bgcolor=red>");
int colCount = rsStruc.getColumnCount();
String colName = "";
for(int i=1;i <= colCount; i++){
colName = rsStruc.getColumnName(i) ;
out.println("<td><B><font color=white>" + colName + "</font></b></td>\n");
}
out.println("</tr>");
while (rs.next()) {
String email=rs.getString("email");
mail.addElement(email);
out.println("<tr bgcolor=ffffff>");
for(int i=1;i <= colCount; i++){
colName = rsStruc.getColumnName(i) ;
String fld = rs.getString(colName);
out.println("<td>" + fld + "</td>");
}
out.println("</tr>");
}
out.println("</table>");
rs.close();
C.close();
}
catch (Exception E) {
out.println("SQLException: " + E.getMessage());
}
out.println("<form action=mailer.jsp method=post>");
out.println("<input type=Hidden name=address value="+mail+">");
out.println("<input type=submit name=send value=Send Mail>");
out.println("</form>"+"</div>");
%>

This is mailer.jsp code:

org.apache.jasper.JasperException: /mailer.jsp(3,17) quote symbol expected
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

wat is the problem with my coding causing such error. i really no idea on it already..

best regards,
albert

17 years ago

JSP

problem with jsp page and java bean

here is my jsp page:

this is my bean file:

This is my error message:

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 6 in the jsp file: /process2.jsp
Generated servlet error:
The method validate() is undefined for the type Login

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

i solve this problem for several day already still cannot get it... any one expert here can help me oversee where is my error
thank you...

regards,
albert

17 years ago

JSP

where i need to place my java bean file in the tomcat

i want to create a bean file but when i run the jsp page it's come out "unable to compile class for jsp"
i place my class file under the C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\ROOT\WEB-INF\classes which my page is put inside the webapps\ROOT.

some one can give me the solution in this manner

thankyou...

best regards,

albert

17 years ago

Servlets

problem using jfreechart

i try to use cewolf but i setup depend on the tutorial of the cewolf, it not work for me... so i hav to find another solution to work it up

17 years ago

Other Open Source Projects

problem using jfreechart

i want to use the jfreechart to create the chart iside the jsp page... but i having the problem... anyexpert here can helping me to solve the problem...

here is my jsp code:

<%@ page session="true" contentType="image/png" %>
<%@ page import="java.awt.BasicStroke" %>
<%@ page import="java.awt.Color" %>
<%@ page import="org.jfree.chart.JFreeChart" %>
<%@ page import="org.jfree.chart.ChartFactory" %>
<%@ page import="org.jfree.chart.ChartPanel" %>
<%@ page import="org.jfree.chart.*" %>
<%@ page import="org.jfree.chart.StandardLegend" %>
<%@ page import="org.jfree.chart.axis.HorizontalCategoryAxis" %>
<%@ page import="org.jfree.chart.axis.NumberAxis" %>
<%@ page import="org.jfree.chart.plot.CategoryPlot" %>
<%@ page import="org.jfree.chart.renderer.LineAndShapeRenderer" %>
<%@ page import="org.jfree.data.DefaultCategoryDataset" %>
<%@ page import="org.jfree.ui.ApplicationFrame" %>
<%@ page import="org.jfree.ui.RefineryUtilities" %>
<%
try {
// row keys...
String series1 = "First";
String series2 = "Second";
String series3 = "Third";
// column keys...
String type1 = "Type 1";
String type2 = "Type 2";
String type3 = "Type 3";
String type4 = "Type 4";
String type5 = "Type 5";
String type6 = "Type 6";
String type7 = "Type 7";
String type8 = "Type 8";
// create the dataset...
DefaultCategoryDataset dataset = new DefaultCategoryDataset();
dataset.addValue(1.0, series1, type1);
dataset.addValue(4.0, series1, type2);
dataset.addValue(3.0, series1, type3);
dataset.addValue(5.0, series1, type4);
dataset.addValue(5.0, series1, type5);
dataset.addValue(7.0, series1, type6);
dataset.addValue(7.0, series1, type7);
dataset.addValue(8.0, series1, type8);
dataset.addValue(5.0, series2, type1);
dataset.addValue(7.0, series2, type2);
dataset.addValue(6.0, series2, type3);
dataset.addValue(8.0, series2, type4);
dataset.addValue(4.0, series2, type5);
dataset.addValue(4.0, series2, type6);
dataset.addValue(2.0, series2, type7);
dataset.addValue(1.0, series2, type8);
dataset.addValue(4.0, series3, type1);
dataset.addValue(3.0, series3, type2);
dataset.addValue(2.0, series3, type3);
dataset.addValue(3.0, series3, type4);
dataset.addValue(6.0, series3, type5);
dataset.addValue(3.0, series3, type6);
dataset.addValue(4.0, series3, type7);
dataset.addValue(3.0, series3, type8);
// create the chart...
System.out.println("----------create the chart-------------------");
JFreeChart chart = ChartFactory.createLineChart("Line Chart Demo 1", // chart title
"type", // domain axis label
"value", // range axis label
dataset, // data
true, // include legend
true, // tooltips
false // urls
);
response.setContentType("image/png");
System.out.println("----------show the chart-------------------");
System.out.println(chart);
ChartUtilities.writeChartAsPNG(response.getOutputStream(),chart,800,600);
response.getOutputStream().flush();
response.getOutputStream().close();
} catch(Exception e) {
e.printStackTrace();
}
%>

here is my error:
"org.apache.jasper.JasperException: Unable to compile class for JSP

Generated servlet error:
Only a type can be imported. org.jfree.chart.JFreeChart resolves to a package

Generated servlet error:
Only a type can be imported. org.jfree.chart.ChartFactory resolves to a package

Generated servlet error:
Only a type can be imported. org.jfree.chart.ChartPanel resolves to a package

Generated servlet error:
Only a type can be imported. org.jfree.chart.StandardLegend resolves to a package

Generated servlet error:
Only a type can be imported. org.jfree.chart.axis.HorizontalCategoryAxis resolves to a package

Generated servlet error:
Only a type can be imported. org.jfree.chart.axis.NumberAxis resolves to a package

Generated servlet error:
Only a type can be imported. org.jfree.chart.plot.CategoryPlot resolves to a package

Generated servlet error:
Only a type can be imported. org.jfree.chart.renderer.LineAndShapeRenderer resolves to a package

Generated servlet error:
Only a type can be imported. org.jfree.data.DefaultCategoryDataset resolves to a package

Generated servlet error:
Only a type can be imported. org.jfree.ui.ApplicationFrame resolves to a package

Generated servlet error:
Only a type can be imported. org.jfree.ui.RefineryUtilities resolves to a package

An error occurred at line: 17 in the jsp file: /chart.jsp
Generated servlet error:
DefaultCategoryDataset cannot be resolved to a type

An error occurred at line: 17 in the jsp file: /chart.jsp
Generated servlet error:
DefaultCategoryDataset cannot be resolved to a type

An error occurred at line: 17 in the jsp file: /chart.jsp
Generated servlet error:
JFreeChart cannot be resolved to a type

An error occurred at line: 17 in the jsp file: /chart.jsp
Generated servlet error:
ChartFactory cannot be resolved

An error occurred at line: 17 in the jsp file: /chart.jsp
Generated servlet error:
ChartUtilities cannot be resolved

org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)"

how i can continue to let the chart can be display on the browser... thanks for your help and this is my final year project and i have to get it out... pls pls help me

thank you

regards,
albert

[ March 06, 2007: Message edited by: albert sie ]
[ March 06, 2007: Message edited by: albert sie ]

17 years ago

Other Open Source Projects

how i to using the jfreechart API with jsp

sorry about that coz i really urgent to get it for my final year project...
really sorry

17 years ago

Other JSE/JEE APIs

how i to using the jfreechart API with jsp

How i need to use the jfreechart API inside the jsp page...
any one can provide me the easiest way to do this, thank you..

Best Regards,
albert

17 years ago

Other JSE/JEE APIs

javamail enquiry

can anyone expert here help me to see wat problem of my program... i really no idea to solve it out liao

error:

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 2 in the jsp file: /simplemail.jsp
Generated servlet error:
Duplicate local variable message

An error occurred at line: 2 in the jsp file: /simplemail.jsp
Generated servlet error:
The method setFrom(InternetAddress) is undefined for the type String

An error occurred at line: 2 in the jsp file: /simplemail.jsp
Generated servlet error:
Duplicate local variable to

An error occurred at line: 2 in the jsp file: /simplemail.jsp
Generated servlet error:
The method addRecipient(Message.RecipientType, String) is undefined for the type String

An error occurred at line: 2 in the jsp file: /simplemail.jsp
Generated servlet error:
The method setSubject(String) is undefined for the type String

An error occurred at line: 2 in the jsp file: /simplemail.jsp
Generated servlet error:
The method setText(String) is undefined for the type String

An error occurred at line: 2 in the jsp file: /simplemail.jsp
Generated servlet error:
The method send(Message) in the type Transport is not applicable for the arguments (String)

[ March 03, 2007: Message edited by: Bear Bibeault ]

17 years ago

JSP

albert sie

Recent posts by albert sie