Aravind Prasad

But Boss

The data is saving properly in the database. The issue is with JTable. I have an updateTable Function, even if i am calling the function, it is not refreshing the data. That is my issue. Infact i have tried also repaint(), but still failing.

I have described the functioanlity such that, you might be able to assume the path/parent frame where the JDialog is opening.

Thanks/Regards

Aravind

Dear Ranchers

I am preparing a small solution. Below is how the functionality works.

1. Login Screen
2. Successful Login will take to a MDI Form
3. Click the menu, a JInternalFrame will open in the JDestopPane.
4. JInternalFrame has a JTable.
5. JInternalFrame has a JButton available for adding new data.
6. When JButton is clicked, a new JInternalFrame is popped up with some JTextField and JButton to save the data.
7. After saving the data (after insert query), a JDialog is opened to upload Logo (update query for BLOB), There are two buttons in the JDialog, one is for uploading the image, another one is uploading it later.
8. The logo is displayed in the JDialog and if the JButton, for upload is pressed, update the database and reload the JTable in the JInternalFrame is called.

My challenge is in point 8. The function is called properly, but the table is not getting refreshed.

Below provided my code, can you please help to understand where i went wrong.

JButton in JDialog for uploading the Logo
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: JOptionPane.showMessageDialog(this, "Image Uploaded Successfully"); companyConfig cc = new companyConfig(); //cc.reloadTable(); cc.updateTable(); this.dispose(); }

Code in the JInternalFrame to populate JTable
public void restructureTable() { jTable1.getColumn("Slno").setPreferredWidth(100); jTable1.getColumn("Company Name").setPreferredWidth(500); jTable1.getColumn("Short Name").setPreferredWidth(300); jTable1.getColumn("Contact Person").setPreferredWidth(300); } public void updateTable() { System.out.println("I have reached here!!"); HashMap hmp = new HashMap(); companyConfigs cc=new companyConfigs(); ArrayList companyList = new ArrayList(); companyList = (ArrayList)cc.listCompany(); System.out.println(companyList); List<Object[]> values = new ArrayList<>(1000); //int sizeofary=companyList.size(); //JOptionPane.showMessageDialog(this, companyList.size()); for(int i=0;i<companyList.size();i++) { hmp=(HashMap)companyList.get(i); Object[] row = new Object[4]; row[0] = i + 1; row[1] = (String)hmp.get("COMPANY_NAME"); row[2] = (String)hmp.get("COMPANY_SHORT_NAME"); row[3] = (String)hmp.get("CONTACT_PERSON"); values.add(row); } final DefaultTableModel model = new DefaultTableModel(new Object[]{"Slno", "Company Name", "Short Name", "Contact Person"}, 0) { @Override public boolean isCellEditable(int row, int column) { return false; } }; if (values.isEmpty()) { } else { jTable1.setModel(model); for (Object[] obj : values) { model.addRow(obj); } } jTable1.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); jTable1.setAutoCreateRowSorter(true); restructureTable(); }
>

Dear Ranchers

Happy New year!!

I am in the process of developing a JSP Web application, with frame sets and iframes. The purpose of using the frame set and iframe is the page remains same throughout the application (egs: Header, left panel menu, footer) and the content part will the only one changing.

Now, I have in my web.xml, I have the session time out set to 10 minutes.

<session-config> <session-timeout>10</session-timeout> <!-- 100 minutes --> </session-config>

My challenge, if I left the web page idle for more than 10 minutes, the session is getting invalidate and when I come back and click any link in the left menu/content page, the iframe or content frameset is only giving the session time out message and not the whole page.

Please give me an idea to resolve this.

Thanks/Regards

Aravind Prasad

Hi Ramesh

Sorry I found my mistake.

I initialized the object lList and recreate another object iList .

I have rectified it and thankyou very much for your time.

Regards / Aravind

Hi Ramesh

Here it is ....

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package ilogistics.cpanel; /** * * @author aravind.prasad */ public class countryDialogList extends javax.swing.JDialog { public static locationList lList; /** * Creates new form countryDialogList */ public countryDialogList(locationList parent, boolean modal) { //super(parent, modal); this.lList = parent; this.setModal(modal); initComponents(); setLocationRelativeTo(this); } public void test1() { locationList iList = new locationList(); String ctry = "Aravind"; iList.test(ctry); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jButton1 = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); jButton1.setText("test"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(185, 185, 185) .addComponent(jButton1) .addContainerGap(292, Short.MAX_VALUE)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(161, 161, 161) .addComponent(jButton1) .addContainerGap(207, Short.MAX_VALUE)) ); pack(); }// </editor-fold> private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { // TODO add your handling code here: this.test1(); } /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException ex) { java.util.logging.Logger.getLogger(countryDialogList.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(countryDialogList.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(countryDialogList.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(countryDialogList.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the dialog */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { countryDialogList dialog = new countryDialogList(lList, true); dialog.addWindowListener(new java.awt.event.WindowAdapter() { @Override public void windowClosing(java.awt.event.WindowEvent e) { System.exit(0); } }); dialog.setVisible(true); } }); } // Variables declaration - do not modify private javax.swing.JButton jButton1; // End of variables declaration }

Hi Ramesh

I am calling this function from another class.

When i run this, i can see the values are actually passing in System.out.println.

But the actual JTextField (countryName) is not displaying any field.

Regards / Aravind

Dear Ranchers

I am trying to send a value from one class to another class in Java Swing.

I wanted to display a string value in the JTextField and unfortunately I am failing to do that. But the getText() is displaying the answer well.

Below is the code and kindly help me understand where the problem is.

/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package ilogistics.cpanel; import javax.swing.JOptionPane; import com.bean.*; import com.SFramework.*; import com.dbModel.*; import java.awt.Frame; import java.util.ArrayList; import java.util.Collection; import java.util.Collections; import java.util.HashMap; import java.util.List; import java.util.Vector; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JFrame; import javax.swing.JTable; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableModel; /** * * @author aravind.prasad */ public class locationList extends javax.swing.JInternalFrame { public static countryDialogList cDialog; /** * Creates new form locationList */ public locationList() { super(); initComponents(); } public void test(String ctryName) { System.out.println("I have reached here" + ctryName); System.out.println("Before Updating: "+ countryName.getText()); String abc = ctryName; countryName.setText(abc); jTextField3.setText(abc); System.out.println("Text is: "+ countryName.getText()); } /** * This method is called from within the constructor to initialize the form. * WARNING: Do NOT modify this code. The content of this method is always * regenerated by the Form Editor. */ @SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code"> private void initComponents() { jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); jLabel1 = new javax.swing.JLabel(); jTextField1 = new javax.swing.JTextField(); jButton1 = new javax.swing.JButton(); jPanel2 = new javax.swing.JPanel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jTextField2 = new javax.swing.JTextField(); jButton2 = new javax.swing.JButton(); jButton3 = new javax.swing.JButton(); countryName = new javax.swing.JTextField(); listCountry = new javax.swing.JButton(); jTextField3 = new javax.swing.JTextField(); setClosable(true); setIconifiable(true); setTitle("Location Master"); jTable1.setModel(new javax.swing.table.DefaultTableModel( new Object [][] { {null, null, null}, {null, null, null}, {null, null, null}, {null, null, null} }, new String [] { "Slno", "Country Code", "Location Name" } )); jScrollPane1.setViewportView(jTable1); jLabel1.setText("Search:"); jButton1.setText("GO"); jPanel2.setBorder(javax.swing.BorderFactory.createTitledBorder("Add / Edit Location Master")); jLabel2.setText("Country Name:"); jLabel3.setText("Location Name:"); jButton2.setText("Save"); jButton3.setText("Remove"); listCountry.setText("#"); listCountry.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { listCountryActionPerformed(evt); } }); javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2); jPanel2.setLayout(jPanel2Layout); jPanel2Layout.setHorizontalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addGap(21, 21, 21) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addComponent(jLabel2) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(countryName) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(listCountry) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addGroup(jPanel2Layout.createSequentialGroup() .addComponent(jLabel3) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addGroup(jPanel2Layout.createSequentialGroup() .addComponent(jButton2) .addGap(18, 18, 18) .addComponent(jButton3) .addGap(0, 65, Short.MAX_VALUE)) .addComponent(jTextField2))))) ); jPanel2Layout.setVerticalGroup( jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup() .addContainerGap() .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2) .addComponent(countryName, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(listCountry, javax.swing.GroupLayout.PREFERRED_SIZE, 20, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGap(2, 2, 2) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel3) .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jButton2) .addComponent(jButton3)) .addContainerGap(29, Short.MAX_VALUE)) ); jTextField3.setText("jTextField3"); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGap(24, 24, 24) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE) .addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup() .addGap(69, 69, 69) .addComponent(jLabel1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 182, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jButton1))) .addContainerGap(13, Short.MAX_VALUE)) ); layout.setVerticalGroup( layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addContainerGap() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel1) .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jButton1)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 185, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(18, 18, 18)) .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup() .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(1, 1, 1))) .addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(14, Short.MAX_VALUE)) ); jPanel2.getAccessibleContext().setAccessibleDescription(""); pack(); }// </editor-fold> private void listCountryActionPerformed(java.awt.event.ActionEvent evt) { cDialog = new countryDialogList(this,true); cDialog.setVisible(true); } // Variables declaration - do not modify private javax.swing.JTextField countryName; private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JButton jButton3; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JPanel jPanel2; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTable jTable1; private javax.swing.JTextField jTextField1; private javax.swing.JTextField jTextField2; private javax.swing.JTextField jTextField3; private javax.swing.JButton listCountry; // End of variables declaration }

The function test() is the one giving the problem.

public void test(String ctryName)
{ System.out.println("I have reached here" + ctryName);
System.out.println("Before Updating: "+ countryName.getText());
String abc = ctryName;
countryName.setText(abc);
jTextField3.setText(abc);
System.out.println("Text is: "+ countryName.getText());
}

Awaiting your usual prompt support.

It is not actually sending the html tag. May be a limitation in the webpage.

I am sending the screen shot of the same.

Regards / Aravind

Sorry the code was not coming out well. Here it is, only the html part i am putting now.

messageBodyPart1.setContent( "<html><body bgcolor=#FFFFFF leftmargin=0 topmargin=0 marginwidth=0 marginheight=0></body></html>", "text/html; charset=utf-8" );

Regards / Aravind

Dear Ranchers

I have been assigned to make a small program for "Email Notification System" with the images and texts are coming from mysql database. This is used for sales promotion and stuffs like that. Some times attachments also has to be there... I have prepared a code snippet and below is the information. But when i run the code without any images in the background, the email is working so perfectly. The moment, when i put the images code (html part), the email recieved is with blank pages. Kindly let me know how best i can sort out the below issue with your enriched knowledge.

import java.util.*; import javax.mail.*; import javax.mail.internet.*; import javax.activation.*; class SendAttachment{ public static void main(String [] args){ String to="xxx@xxx.com";//change accordingly final String user="xxx@xxx.com";//change accordingly final String password="xxx";//change accordingly //1) get the session object Properties properties = System.getProperties(); properties.setProperty("mail.smtp.host", "mail.xxx.com");//change accordingly properties.put("mail.smtp.auth", "true"); Session session = Session.getDefaultInstance(properties, new javax.mail.Authenticator() { protected PasswordAuthentication getPasswordAuthentication() { return new PasswordAuthentication(user,password); } }); //2) compose message try{ MimeMessage message = new MimeMessage(session); message.setFrom(new InternetAddress(user)); message.addRecipient(Message.RecipientType.TO,new InternetAddress(to)); message.setSubject("TEST MAIL"); //message.setContent("<h1>sending html mail check</h1>","text/html" ); //3) create MimeBodyPart object and set your message content BodyPart messageBodyPart1 = new MimeBodyPart(); //messageBodyPart1.setContent( "<body bgcolor=red><H1>This is a test message from java</H1>", "text/html; charset=utf-8" ); messageBodyPart1.setContent( "<html><body bgcolor=#FFFFFF leftmargin=0 topmargin=0 marginwidth=0 marginheight=0><table border=0 ><tr><td ></td></tr><tr><td ></td><td ></td><td ></td></tr><tr><td ></td></tr></table></body></html>", "text/html; charset=utf-8" ); //messageBodyPart1.setHeader("Content-Type", "text/html"); //messageBodyPart1.setText("This is a test message from java"); //4) create new MimeBodyPart object and set DataHandler object to this object MimeBodyPart messageBodyPart2 = new MimeBodyPart(); String filename = "c:/abcd.pdf";//change accordingly DataSource source = new FileDataSource(filename); messageBodyPart2.setDataHandler(new DataHandler(source)); messageBodyPart2.setFileName(filename); //messageBodyPart2.setContent( "This is a test message from java", "text/html; charset=utf-8" ); //5) create Multipart object and add MimeBodyPart objects to this object Multipart multipart = new MimeMultipart(); multipart.addBodyPart(messageBodyPart1); multipart.addBodyPart(messageBodyPart2); //6) set the multiplart object to the message object message.setContent(multipart ); //7) send message Transport.send(message); System.out.println("message sent...."); }catch (MessagingException ex) {ex.printStackTrace();} } }

Thanks/Regards

Aravind Prasad

Dear Ranchers

I have a JSP file which is provided below.

<%@ page language="java" import="java.util.*,com.cordelia.Sframework.*,com.cordelia.projects.*,com.cordelia.bean.*" %> <% HashMap hmp = new HashMap(); BondHandler bh = new BondHandler(); ArrayList bondList = new ArrayList(); bondList = (ArrayList)bh.listBond(); int sizeofary=bondList.size(); int slno=0; %> <link href="../../../css/fontStyles.css" type="text/css" rel="stylesheet"> <table border="0" class="text"> <tr> <td class="textus">List of Bonds</td> </tr> <tr> <td ><hr></td> </tr> <tr> <td class="boxlistFfull" >Slno</td> <td class="boxlistFfull">Bond Number</td> <td class="boxlistFfull">Description</td> <td class="boxlistFfull">Issued On</td> <td class="boxlistFfull">Bond Type</td> <td class="boxlistFfull">Currency</td> <td class="boxlistFfull">Bond Value</td> <td class="boxlistFfull">Remarks</td> <td class="boxlistFfull">Bond Status</td> <td class="boxlistFfull" >Action</td> </tr> <% for(int i=0;i<bondList.size();i++) { slno = i + 1; hmp=(HashMap)bondList.get(i); %> <tr> <td class="new2"><%=slno%></td> <td > </td> </tr> <% } %> </table>

The Class File - bondhandler.java is also provided below.

/* Package section */ package com.cordelia.projects; /* Import section */ import java.sql.*; import java.util.*; import java.io.*; import java.rmi.server.UID; import java.util.Date; import java.rmi.server.UID; import java.text.*; import java.awt.*; import java.sql.*; import java.sql.Timestamp; import java.util.Calendar.*; import java.lang.*; import com.cordelia.projects.*; import com.cordelia.Sframework.*; import com.cordelia.bean.*; public class bondHandler { Handler db = new Handler(); UserBean user = null; HashMap hmap; /*****************Module 1 : Listing the Bonds ******************************/ public ArrayList listBonds() { String query = "select * from bonds"; ArrayList bondList =new ArrayList(); try { db.createConnection(); bondList = (ArrayList)db.select(query,1); } catch(Exception e) { System.out.println("Error in Displaying Item:Class:ictHandler: Error : "+e); } finally { db.close(); } return bondList; } }

The Javafile comiles and the class file is generated and put under the path WEB-INF\classes\com\cordelia\projects under the project folder.

I am using the following applications


JRE : 1.6
Tomcat Webserver : 6.0


When I run the page, I get the following error.

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

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

An error occurred at line: 8 in the jsp file: /programs/bonds/creation/index.jsp
BondHandler cannot be resolved to a type
5:
6:
7: HashMap hmp = new HashMap();
8: BondHandler bh = new BondHandler();
9: ArrayList bondList = new ArrayList();
10: bondList = (ArrayList)bh.listBond();
11: int sizeofary=bondList.size();


An error occurred at line: 8 in the jsp file: /programs/bonds/creation/index.jsp
BondHandler cannot be resolved to a type
5:
6:
7: HashMap hmp = new HashMap();
8: BondHandler bh = new BondHandler();
9: ArrayList bondList = new ArrayList();
10: bondList = (ArrayList)bh.listBond();
11: int sizeofary=bondList.size();

Please kindly help me resolve this issue.

Thanks/Regards

Aravind PRasad

Dear Seetharaman

Thanks again. Your proposal is really good, but customer wants it the way i explained.

Presently I am using the substring option and displaying is fine and the customer is happy. Code is provided FYI and please refer the screen shot's line number 37

String project_name = (String)hmp.get("project_name"); String prj_name = ""; //out.println(project_name.length()); if(project_name.length()>=40) { prj_name = project_name.substring(0,40); } else { prj_name = project_name; }


If there is any easier way, please advise, so that i can update myself accordingly.

thanks/Regards

Dear seetharaman

Thanks for the feedback.

I tried no-wrap before and if i put, the information is streatching the table and it is becoming un-tidy. The only option is to display few characters.

The solution in my mind is

1. get the value in the string.
2. make substring
3. display the sub-string.

I am not sure whether the above login is correct or is there any easier way to sort this out.

Thanks/Regards

Aravind

Dear Ranchers

I have to provide a tabluar view of the data retreiving from the database table. One column has a long description of the data where by i have provided 50% width for it. Once it is exceeding the 50% width, the information is going to the next line (like WRAP Text) which is making my display un-tidy.

I would like display only the information with 40 characters, so that all the table rows will look perfectly.

<tr> <td class="new2"><%=slno%></td> <td class="new2"><%=(String)hmp.get("project_name")%></td> <% int project_status = Integer.parseInt(hmp.get("project_status").toString()); if(project_status==1) {%> <td class="active">Active</td> <% } else { %> <td class="inactive">Closed</td> <% } %> </td> <td class="new3"><%=(String)hmp.get("firstname")%> <%=(String)hmp.get("lastname")%></td> <td class="new3"><%=(String)hmp.get("sector_name")%></td> <td class="new2" >  <%if(allow_edit==1) { %> <a href="##" onClick="openWin('update/index.jsp?project_id=<%=(String)hmp.get("project_id")%>', 'Projects','toolbar=0,location=0,directories=0,status=0,menuBar=0,scrollBars=0,resizable=0', '600', '950'); ">Edit</a> <%} else {%> Edit <%} if(allow_delete ==1) {%>     <a class="error" rel="nofollow">Delete</a> <%} else {%> Delete <%}%> </td> </tr>

Attached here with the sample output of the table. Please look at line number 37

Please let me have a solution for this.

Thanks/Regards

Aravind Prasad

Dear Ranchers

I have a table structure and the values in the table which are in trillions. Please see the below information for your better understanding.

Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use projects; Database changed mysql> desc project_main; +---------------------+--------------+------+-----+---------------------+------- + | Field | Type | Null | Key | Default | Extra | +---------------------+--------------+------+-----+---------------------+------- + | project_id | varchar(10) | NO | PRI | NULL | | | project_name | varchar(100) | NO | | NULL | | | client_id | varchar(20) | NO | | NULL | | | country | varchar(10) | NO | | NULL | | | project_sector | varchar(10) | NO | | NULL | | | project_type | varchar(10) | NO | | NULL | | | project_description | varchar(512) | NO | | NULL | | | project_cost | double | NO | | 0 | | | project_currency | varchar(10) | NO | | NULL | | | exchange_rate | double | NO | | 0 | | | project_cost_usd | double | NO | | 0 | | | created_by | varchar(45) | NO | | NULL | | | created_on | varchar(45) | NO | | 0000-00-00 00:00:00 | | +---------------------+--------------+------+-----+---------------------+------- + 13 rows in set (0.01 sec) mysql> use projects; Database changed mysql> select project_cost from project_main; +--------------+ | project_cost | +--------------+ | 800000000 | | 39860000 | | 150000000000 | | 220000000000 | | 270000000000 | | 260000000000 | | 140000000000 | | 85000000000 | | 182000000000 | | 110000000000 | | 120000000000 | | 320000307686 | | 200000000000 | | 200000000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 | | 12000000 | | 200000000 | | 12000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 | | 18000000 | | 1000000 | | 160000000 | | 200000000 | | 200000000 | | 15000000 | | 14000000 | | 200000000 | | 200000000 | | 200000000 | | 200000000 |

In the table the values are displaying properly. But when I call the Double value using query and display in the JSP Page, I get the values like 8.0E8 for 800000000

Please advise, how can i solve this issue..

Thanks/ Regards

Aravind