|
Hi,
I have to write a report in HTML document using java.
Can somebody suggest me some good tutorial or some good links that will help me in doing this task.
It would be very helpful.Please do help me out.
Thank You.
|
|
|
|
|
Salam ( == Hi );
As I understood; you want to use Java to generate a report in HTML format. There is a simple to do job. You just need to do the following:
1- Create an HTML file and Open it in Java;
2- Add header data to the file;
3- Connect to your data source; for example MySQL using JDBC;
4- Run a query to the data source;
5- Parse the query result;
6- Add a parsed query result in appropriate places at the HTML file;
7- Finally add footer to the file;
8- Close the stream;
To show it in your program; use the Swing library;
there is a tut. on sun.com;
link
With my best and warmest regards;
&
With the hope of coming of Mahdi;
Ali Shakiba;
Kerman - Iran (Islamic Republic);
|
|
|
|
|
I need hellp moved this code from unix db2 tomcat server to unix mysql tomcat server. Modified the code as per below
This code gives a null pointer exception Please view at www.nerolac.com/dealer6_1.jsp. Please advice.
<pre>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="conb" class="nerolacbean.ConnOdbc"/><script>
</script><%
String connectionURL = "jdbc:mysql://174.133.229.154:3306/nerolac?";
Connection connection = null; Statement statement = null;
String sql_state,sql_city,flag,city,sql_details; ResultSet rs_state;
String id,stateid; ResultSet rs = null; ResultSet rs1 = null;
ResultSet rs2 = null; String address = null;%>
<SCRIPT ID=clientEventHandlersJS LANGUAGE=javascript> <!--
function state_onchange(){ if (document.testa.state.selectedIndex!=0) {
if (document.testa.city==document.undefined) { } else {
document.testa.city[document.testa.city.selectedIndex].value = " "; }
// document.testa.action="dealer6.jsp";
//alert(document.getElementById("state").value);
city = document.getElementById("city").value;
state = document.getElementById("state").value; if (city=0) { city = "+"; }
location.replace("dealer6_1.jsp?&state="+state+"&city="+city); }
} function city_onchange(){ city = document.getElementById("city").value;
state = document.getElementById("state").value;
location.replace("dealer6_1.jsp?&state="+state+"&city="+city);}
//--></SCRIPT><html><body> <%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL,"","");
statement = connection.createStatement(); try { ResultSet rs_city=null;
ResultSet rs_details=null; String reqCity=""+request.getParameter("city");
String reqState=""+request.getParameter("state"); String form_state="";
sql_state = "select distinct state from dealernetwork order by state";
%> &nbsp;
<form name="testa" action="dealer6_1.jsp" method="get">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr> <td><img src="images/indiamap2.jpg" /></td>
<td valign="middle"><table border="0" cellpadding="2" bordercolor="#000000" bordercolorlight="#000000" bordercolordark="#000000">
<tr>
<td height="23" align="center" bgcolor="#FFCCFF" class="txt07" ><b> Select State</b></td>
<td height="23" align="center" bgcolor="#FFCCFF" class="txt07"><b> Select City</b> </td>
</tr> <tr> <%
if(!reqState.equalsIgnoreCase("null"))//If state is specified { %>
<% form_state = reqState.toUpperCase(); if(!form_state.equals(""))
{ try {
sql_city = "select ID,city,STATEID from dealernetwork where state = '"+form_state+"' order by city";
out.println("sql_city "+sql_city); rs_city =conb.getResult(sql_city);
out.println("rs_city "+rs_city); flag = "true"; }
catch(Exception e) {
System.out.println("IN EXCEPTION-----"+e.getMessage()); } } }
%>
<td height="26" bordercolordark="#00FFFF" align="center">&nbsp;
<select name="state" id="state" onchange="return state_onchange()" class="txt07">
<% if(form_state.equals("")) {%>
<option selected="selected" value=""> -- Select State --</option>
<%}else {%>
<option value=""> -- Select State -- </option> <%}%>
<% rs_state = conb.getResult(sql_state);
out.println("rs_state "+rs_state); while(rs_state.next()) {
if((reqState).equals(rs_state.getString("state"))) { %>
<option value="<%= rs_state.getString("state")%>" selected="selected"><%= rs_state.getString("state")%></option>
<% }else {%>
<option value="<%= rs_state.getString("state")%>"><%= rs_state.getString("state")%></option>
<% } } %> </select></td>
<td height="26" align="center"><%
//if (!reqState.equalsIgnoreCase("null"))//{ %>
<select name="city" onchange="return city_onchange()" class="txt07">
<option value="" selected="selected" >--Select City--</option>
<% String checkcity=""; boolean stateidStatus=true;
String tempCity=""; if(!reqState.equalsIgnoreCase("null")) {
while(rs_city.next()) { id = rs_city.getString(1);
city = rs_city.getString(2); if(!tempCity.equalsIgnoreCase(city))
{ tempCity = city; if(reqCity.equalsIgnoreCase(city)) {
%>
<option selected="selected" value="<%=reqCity%>"><%=reqCity%></option>
<% }else { %>
<option value="<%=city%>"><%=city%></option>
<% } } } } %> </select>
<% //}%></td> </tr> </table> <br />
<% if(!reqCity.equalsIgnoreCase("null")) {
String upper = reqCity.toUpperCase();
String lower = reqCity.toLowerCase();
String firstCap =reqCity.toLowerCase();
String firstCap1 = (firstCap.substring(0,1)).toUpperCase();
String firstCap2 = firstCap.substring(1,firstCap.length());
String firstCap3=firstCap1+firstCap2;
sql_details = "select * from dealernetwork where city= '"+upper+"' or city='"+firstCap3+"' or city= '"+lower+"' and stateid IN (select distinct stateid from dealernetwork where state = '"+reqState+"' )";
//out.println("query "+sql_details);
rs_details = conb.getResult(sql_details); %> <br> <%
boolean dispHead=true; while(rs_details.next()) {
if(dispHead) { dispHead = false; %>
<span class="txt07">
Listing of addresses corresponding to the selected cities are as</span>
<br> <% }%> <br />
<table border="0" cellpadding="2" cellspacing="1" width="90%">
<tr> <td width="18%" align="right" border
bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B5D2CA" class="txt07"><b>Name</b></td>
<td width="82%" align="left" bordercolorlight="#000000"
bordercolordark="#000000" bgcolor="#D2E3DE" class="txt07" border>
<% out.println(rs_details.getString(3).toUpperCase()); %>
</td> </tr> <tr> <%
address = ""+rs_details.getString(4); if(!(address.equals("null")))
{ String s1 = address+" "+address.toLowerCase();
String f1 = (s1.substring(0,1)).toUpperCase();
String s2 = s1.substring(1,s1.length());
// address=f1+s2; address = address.toUpperCase();
}
/* if(!(rs_details.getString("address2").equals("null")))
{ address = address +" "+ rs_details.getString("address2");
address =address.toLowerCase(); }
if(!(rs_details.getString("address3").equals("null"))) {
address = address +" "+ rs_details.getString("address3");
address =address.toLowerCase(); }*/ %>
<td width="18%" align="right" border
bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B5D2CA" class="txt07"><b>Address</b></td>
<td width="82%" align="left" bordercolorlight="#000000"
bordercolordark="#000000" bgcolor="#D2E3DE" class="txt07" border>
<%if(!address.equals("")) {%><%=address%><%}%>
</td> </tr> <tr>
<td width="18%" align="right" border
bordercolorlight="#000000" bordercolordark="#000000" bgcolor="#B5D2CA" class="txt07"><b>Phone</b></td>
<td width="82%" align="left" bordercolorlight="#000000"
bordercolordark="#000000" bgcolor="#D2E3DE" class="txt07" border>
<% String phone=""+rs_details.getString("phone");
if(!(phone.equals("null"))) {%> <%=phone%><%}else
{%>N.A.<%}%></td> </tr>
<tr><td>&nbsp;</td></tr> </table>
<% } } } catch(Exception e) { out.println("Error"+e); }
%></td> </tr> <tr>
<td colspan="2" align="right"> </td> </tr>
</table></form>
<pre/>
Regards
Ashish Bhatia
modified on Wednesday, June 3, 2009 8:05 AM
|
|
|
|
|
0. Use the <pre> tag to format you rcode; hint look below for
code block
1. Make sure the code is pasted in correctly; again you can ignore the HTML tags if you tick the box below.
Then, and only the, you *might* get some advice.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
Looking at his code, he mis-typed his closing "pre" tag. A simple human error!
modified on Thursday, June 4, 2009 6:33 PM
|
|
|
|
|
ItIsFinished wrote: A simple human error!
A simple human would fix it.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
Hello guys,
I am developing a mobile application and in this application i need to read an XML file. Now im trying to add the following packages to read an xml file:
import javax.xml.parsers.DocumentBuilder;
import javax.xml.parsers.DocumentBuilderFactory;
After trying to import these packages NETBEANS 6.5 gives me the following error message javax.xml.parser not found.
When i try to use these packages in a normal java applicaion it works fine but when using them with the mobile applicatoin the above mentioned error comes up. Can anyone tell me how I can fix this or if there is any other solution? sorry for the trouble but I am a bit new to java.
|
|
|
|
|
Without firing up google, I think you'll find that the whole of javax is not part of Java ME.
blox. It is supported, see here[^]
That may help you. All I can guess then is you have got part of the J2ME SDK missing/not installed?
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
Hello, I have successfully used jComboboxes as cell editors in a jtable using the code below which is all in one method.
My question is, how can i get the item (or index for that matter) selected in the combobox that's inside the jtable?
Using table.getmodel().getvalueat() doesn't seem to work.
Thanks!
DefaultTableModel model = new DefaultTableModel() {
@Override
public boolean isCellEditable(int row, int col) {
if(col>2)
return false;
return true;
};
};
TableColumn col;
int vColIndex,width;
JComboBox comboBox;
TableColumn colcombo;
colcombo = jTable1.getColumnModel().getColumn(2);
comboBox = new JComboBox();
comboBox.addItem("Iniciado");
comboBox.addItem("En proceso");
comboBox.addItem("Consolidado");
colcombo.setCellEditor(new DefaultCellEditor(comboBox));
|
|
|
|
|
My apologies if I'm wrong, I'm at work and can't check out the API right now.(navy so I'm not allowed any excess material here) But the method should be as simple as
comboBox.getSelectedItem(); //should return an Object, cast it to String if need be
//or
comboBox.getSelectedIndex();
I hope this helps, have a good day. (It's just off of the top of my head.)
|
|
|
|
|
You'd think that, but no. :S
I tried that and it works only for the selected item in the LAST combobox that was modified, but when you have more than one row in a jtable and each one of those rows has a combobox that's referenced by the same variable (combobox) it only returns the last change that was made to the object.
What I need to do is I have a jtable and I need to go through all of the rows to record those values in a database.
|
|
|
|
|
I want to try a simple program with java for my Nokia cell phone. Is there anybody to help me?
Sourie
|
|
|
|
|
import javax.microedition.midlet.*;
import javax.microedition.lcdui.*;
/**
* @author Internet
*/
public class Midlet123 extends MIDlet implements CommandListener{
private Command Ok;
private Display dis;
private Form form;
public Midlet123()
{
dis=Display.getDisplay(this); form=new Form("My First Middlet");
Ok=new Command("Exit",Command.OK, 1);
form.setCommandListener(this);
}
public void startApp() {
dis.setCurrent(form);
}
public void pauseApp() {
}
public void destroyApp(boolean unconditional) {
}
public void commandAction(Command arg0, Displayable arg1) {
if(arg0==Ok)
{
destroyApp(true);
notifyDestroyed();
}
}
}
|
|
|
|
|
The loop cant be stop eventho the key-in matches. Can anyone fix this and tell me my mistake?
Greatly appreciate it if so!
<br />
import java.io.*;<br />
<br />
public class A<br />
{<br />
public static void main(String args[]) throws IOException<br />
{<br />
BufferedReader stdin=new BufferedReader (new InputStreamReader(System.in));<br />
String name,pwd;<br />
int n1;<br />
int p2;<br />
<br />
System.out.println("\tWelcome to ");<br />
System.out.println("*******SHINE IT Training Centre*******");<br />
System.out.println("**Please login before u calculate**");<br />
<br />
do<br />
{<br />
System.out.println("Enter user name: ");<br />
name=stdin.readLine();<br />
n1=Integer.parseInt(name);<br />
System.out.println("Enter password: ");<br />
pwd=stdin.readLine();<br />
p2=Integer.parseInt(pwd);<br />
<br />
} while ((name!="2208")&&(pwd!="1234"));<br />
<br />
<br />
System.out.println("Successful Login!!");<br />
<br />
}<br />
}<br />
|
|
|
|
|
eigther change
while ((name!="2208")&&(pwd!="1234"));
to
while ((!name.equals("2208"))&&(!pwd.equals("1234")));
or
while ((n1!=2208)&&(p2!=1234));
|
|
|
|
|
oic! Thank you very much!!
|
|
|
|
|
I have a class JPanel that I want to add other JPanels onto during run-time. I can add a JPanel using the NetBeans IDE for "design", but the IDE will not let me dynamically add a new JPanel and let me position it on the main JPanel . When I look at the documentation, it appears that there are inherited methods that would allow this type of operation, such as setLocation(int, int). The IDE complains about this method, and the list of available methods that appears when editing the code, has a very limited set. Is there a way around this using the IDE?
Thanks for your time.
AF Pilot
|
|
|
|
|
Reagan Conservative wrote: I have a class JPanel
I would rename your class to something more appropriate if I were you.
If you have a look at the code Netbeans generates with the designer, then you will see something which looks like this.
JPanel jp = new JPanel();
[InsertParentControlHere].add(jp);
Add that in the code where you need it.
My failometer has shot off the end of the scale!
I seem to have misplaced my ban button.. no wait... found it!
|
|
|
|
|
I was just using this as a generic example. The actual name is not JPanel. I was going to try and use this "JPanel" to draw graphics on and place it on another "JPanel". I think that the better approach is just to draw directly to the "JPanel" without adding a whole bunch of smaller "JPanel"s.
Thanks for replying.
AF Pilot
|
|
|
|
|
Apologies, I misunderstood.
Reagan Conservative wrote: I think that the better approach is just to draw directly to the "JPanel" without adding a whole bunch of smaller "JPanel"s.
Agreed, I see what you mean about inheritence now. Overriding the paintComponant method should do the trick. Have a look at this[^], it may help.
My failometer has shot off the end of the scale!
I seem to have misplaced my ban button.. no wait... found it!
|
|
|
|
|
I want to develop a company visitors software. the software will have the following columns:
Visitors name
Purpose of visiting
Who you are visiting
time in
time out
I am having a problem in how the interface should be. I am new in programming please can you descibe for me how the interface should be. especially the time out column. the managment should be able to see those who visited.
Thank you
|
|
|
|
|
Err, this has nothing todo with Java; unless that happens to be the language used in your school.
Alternatively, if this really is for work, use a sheet of paper that visitors sign in and out on.
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
Some remarks:
1) Don't cross-post, this is considered rude.
2) Provide a meaningful title for your message.
3) Read the posting guidelines (the first message on top of the message boards) before posting.
|
|
|
|
|
how can Read Barcode from an image
|
|
|
|
|