Karl66
asked on
Data values being read in are -.50 when odd in data source?? See simple example!
Java output string changing dollar values by .50 cents (less) when I read in from DB and output to string? How weird! The odd numbers are dropped down by .5??? (code below) any help?
Orig data:(in exel)
59,198 44,398 50,318 63,583
After reading in and outputting to screen:
59197.5 44398.0 50318.0 63582.5
CODE:
/*
* SDP.java
*
* Created on March 29, 2007, 4:16 PM
*/
package my.SDP;
import javax.swing.*;
import java.sql.*;
/**
*
* @author Karl Smith
*/
public class SDP extends javax.swing.JFrame {
/** Creates new form SDP */
public SDP() {
initComponents();
}
/** 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.
*/
// <editor-fold defaultstate="collapsed" desc=" Generated Code ">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jComboBox1 = new javax.swing.JComboBox();
jComboBox2 = new javax.swing.JComboBox();
jComboBox3 = new javax.swing.JComboBox();
jComboBox4 = new javax.swing.JComboBox();
jComboBox5 = new javax.swing.JComboBox();
jLabel6 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
setDefaultCloseOperation(j avax.swing .WindowCon stants.EXI T_ON_CLOSE );
setCursor(new java.awt.Cursor(java.awt.C ursor.HAND _CURSOR));
jPanel1.setBorder(javax.sw ing.Border Factory.cr eateTitled Border("Ar chive Appliance"));
jLabel1.setText("Slots");
jLabel2.setText("Drives");
jLabel3.setText("Cache");
jLabel4.setText("Response" );
jLabel5.setText("Years");
jComboBox1.setModel(new javax.swing.DefaultComboBo xModel(new String[] { "Select One...", "16", "32", "80", "174", "238", "438", "638" }));
jComboBox1.setPreferredSiz e(new java.awt.Dimension(200, 20));
jComboBox1.addActionListen er(new java.awt.event.ActionListe ner() {
public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
jComboBox1ActionPerformed( evt);
}
});
jComboBox2.setModel(new javax.swing.DefaultComboBo xModel(new String[] { "Select One...", "2", "4", "6" }));
jComboBox2.setPreferredSiz e(new java.awt.Dimension(200, 20));
jComboBox2.addActionListen er(new java.awt.event.ActionListe ner() {
public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
jComboBox2ActionPerformed( evt);
}
});
jComboBox3.setModel(new javax.swing.DefaultComboBo xModel(new String[] { "Select One...", "Standard", "2TB Cache" }));
jComboBox3.setPreferredSiz e(new java.awt.Dimension(200, 20));
jComboBox3.addActionListen er(new java.awt.event.ActionListe ner() {
public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
jComboBox3ActionPerformed( evt);
}
});
jComboBox4.setModel(new javax.swing.DefaultComboBo xModel(new String[] { "Select One...", "9x5 NBD", "9x5x4", "24x7x4" }));
jComboBox4.setPreferredSiz e(new java.awt.Dimension(200, 20));
jComboBox4.addActionListen er(new java.awt.event.ActionListe ner() {
public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
jComboBox4ActionPerformed( evt);
}
});
jComboBox5.setModel(new javax.swing.DefaultComboBo xModel(new String[] { "Select One...", "2 Years Additional", "1 Year Uplift", "3 Years Uplift", "1 Year Post", "3 Years Post" }));
jComboBox5.setPreferredSiz e(new java.awt.Dimension(200, 20));
jComboBox5.addActionListen er(new java.awt.event.ActionListe ner() {
public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
jComboBox5ActionPerformed( evt);
}
});
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jP anel1);
jPanel1.setLayout(jPanel1L ayout);
jPanel1Layout.setHorizonta lGroup(
jPanel1Layout.createParall elGroup(ja vax.swing. GroupLayou t.Alignmen t.LEADING)
.addGroup(jPanel1Layout.cr eateSequen tialGroup( )
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.cr eateParall elGroup(ja vax.swing. GroupLayou t.Alignmen t.LEADING)
.addComponent(jLabel5)
.addComponent(jLabel3)
.addComponent(jLabel2)
.addComponent(jLabel1)
.addComponent(jLabel4))
.addGap(25, 25, 25)
.addGroup(jPanel1Layout.cr eateParall elGroup(ja vax.swing. GroupLayou t.Alignmen t.LEADING, false)
.addComponent(jComboBox2, javax.swing.GroupLayout.Al ignment.TR AILING, 0, javax.swing.GroupLayout.DE FAULT_SIZE , Short.MAX_VALUE)
.addComponent(jComboBox3, javax.swing.GroupLayout.Al ignment.TR AILING, 0, javax.swing.GroupLayout.DE FAULT_SIZE , Short.MAX_VALUE)
.addComponent(jComboBox4, javax.swing.GroupLayout.Al ignment.TR AILING, 0, javax.swing.GroupLayout.DE FAULT_SIZE , Short.MAX_VALUE)
.addComponent(jComboBox5, 0, javax.swing.GroupLayout.DE FAULT_SIZE , Short.MAX_VALUE)
.addComponent(jComboBox1, javax.swing.GroupLayout.PR EFERRED_SI ZE, javax.swing.GroupLayout.DE FAULT_SIZE , javax.swing.GroupLayout.PR EFERRED_SI ZE))
.addContainerGap(41, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalG roup(
jPanel1Layout.createParall elGroup(ja vax.swing. GroupLayou t.Alignmen t.LEADING)
.addGroup(jPanel1Layout.cr eateSequen tialGroup( )
.addContainerGap()
.addGroup(jPanel1Layout.cr eateParall elGroup(ja vax.swing. GroupLayou t.Alignmen t.LEADING)
.addComponent(jLabel1, javax.swing.GroupLayout.Al ignment.TR AILING)
.addComponent(jComboBox1, javax.swing.GroupLayout.Al ignment.TR AILING, javax.swing.GroupLayout.PR EFERRED_SI ZE, javax.swing.GroupLayout.DE FAULT_SIZE , javax.swing.GroupLayout.PR EFERRED_SI ZE))
.addGroup(jPanel1Layout.cr eateParall elGroup(ja vax.swing. GroupLayou t.Alignmen t.LEADING)
.addGroup(jPanel1Layout.cr eateSequen tialGroup( )
.addGap(17, 17, 17)
.addComponent(jComboBox2, javax.swing.GroupLayout.PR EFERRED_SI ZE, javax.swing.GroupLayout.DE FAULT_SIZE , javax.swing.GroupLayout.PR EFERRED_SI ZE))
.addGroup(javax.swing.Grou pLayout.Al ignment.TR AILING, jPanel1Layout.createSequen tialGroup( )
.addGap(23, 23, 23)
.addComponent(jLabel2)))
.addGroup(jPanel1Layout.cr eateParall elGroup(ja vax.swing. GroupLayou t.Alignmen t.LEADING)
.addGroup(jPanel1Layout.cr eateSequen tialGroup( )
.addGap(19, 19, 19)
.addComponent(jComboBox3, javax.swing.GroupLayout.PR EFERRED_SI ZE, javax.swing.GroupLayout.DE FAULT_SIZE , javax.swing.GroupLayout.PR EFERRED_SI ZE))
.addGroup(javax.swing.Grou pLayout.Al ignment.TR AILING, jPanel1Layout.createSequen tialGroup( )
.addGap(25, 25, 25)
.addComponent(jLabel3)))
.addGap(35, 35, 35)
.addGroup(jPanel1Layout.cr eateParall elGroup(ja vax.swing. GroupLayou t.Alignmen t.LEADING)
.addComponent(jComboBox4, javax.swing.GroupLayout.Al ignment.TR AILING, javax.swing.GroupLayout.PR EFERRED_SI ZE, javax.swing.GroupLayout.DE FAULT_SIZE , javax.swing.GroupLayout.PR EFERRED_SI ZE)
.addComponent(jLabel4, javax.swing.GroupLayout.Al ignment.TR AILING))
.addGroup(jPanel1Layout.cr eateParall elGroup(ja vax.swing. GroupLayou t.Alignmen t.LEADING)
.addGroup(jPanel1Layout.cr eateSequen tialGroup( )
.addGap(20, 20, 20)
.addComponent(jComboBox5, javax.swing.GroupLayout.PR EFERRED_SI ZE, javax.swing.GroupLayout.DE FAULT_SIZE , javax.swing.GroupLayout.PR EFERRED_SI ZE))
.addGroup(javax.swing.Grou pLayout.Al ignment.TR AILING, jPanel1Layout.createSequen tialGroup( )
.addGap(26, 26, 26)
.addComponent(jLabel5)))
.addContainerGap(16, Short.MAX_VALUE))
);
jLabel6.setText("Part#");
jButton1.setText("Submit") ;
jButton1.addActionListener (new java.awt.event.ActionListe ner() {
public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
jButton1ActionPerformed(ev t);
}
});
jButton2.setText("Clear");
jButton2.addActionListener (new java.awt.event.ActionListe ner() {
public void actionPerformed(java.awt.e vent.Actio nEvent evt) {
jButton2ActionPerformed(ev t);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(ge tContentPa ne());
getContentPane().setLayout (layout);
layout.setHorizontalGroup(
layout.createParallelGroup (javax.swi ng.GroupLa yout.Align ment.LEADI NG)
.addGroup(layout.createSeq uentialGro up()
.addGroup(layout.createPar allelGroup (javax.swi ng.GroupLa yout.Align ment.TRAIL ING, false)
.addGroup(javax.swing.Grou pLayout.Al ignment.LE ADING, layout.createSequentialGro up()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.DE FAULT_SIZE , javax.swing.GroupLayout.DE FAULT_SIZE , Short.MAX_VALUE))
.addGroup(javax.swing.Grou pLayout.Al ignment.LE ADING, layout.createSequentialGro up()
.addGap(23, 23, 23)
.addComponent(jLabel6)
.addPreferredGap(javax.swi ng.LayoutS tyle.Compo nentPlacem ent.RELATE D)
.addComponent(jTextField1, javax.swing.GroupLayout.PR EFERRED_SI ZE, 135, javax.swing.GroupLayout.PR EFERRED_SI ZE)
.addGap(31, 31, 31)
.addComponent(jButton2)
.addPreferredGap(javax.swi ng.LayoutS tyle.Compo nentPlacem ent.RELATE D)
.addComponent(jButton1)))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup (javax.swi ng.GroupLa yout.Align ment.LEADI NG)
.addGroup(layout.createSeq uentialGro up()
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.PR EFERRED_SI ZE, javax.swing.GroupLayout.DE FAULT_SIZE , javax.swing.GroupLayout.PR EFERRED_SI ZE)
.addGap(15, 15, 15)
.addGroup(layout.createPar allelGroup (javax.swi ng.GroupLa yout.Align ment.BASEL INE)
.addComponent(jLabel6)
.addComponent(jTextField1, javax.swing.GroupLayout.PR EFERRED_SI ZE, javax.swing.GroupLayout.DE FAULT_SIZE , javax.swing.GroupLayout.PR EFERRED_SI ZE)
.addComponent(jButton1)
.addComponent(jButton2))
.addContainerGap(17, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void jButton1ActionPerformed(ja va.awt.eve nt.ActionE vent evt) {
search(bstring);
}
private void jComboBox5ActionPerformed( java.awt.e vent.Actio nEvent evt) {
// Code for size of years
String select5;
select5 = (String)jComboBox5.getSele ctedItem() ;
if (select5 == "2 Years Additional") bstring = bstring + "W36";
else if (select5 == "1 Year Uplift") bstring = bstring + "W12";
else if (select5 == "3 Years Uplift") bstring = bstring + "W36";
else if (select5 == "1 Year Post") bstring = bstring + "P12";
else if (select5 == "3 Years Post") bstring = bstring + "P36";
jTextField1.setText(bstrin g);
}
private void jComboBox4ActionPerformed( java.awt.e vent.Actio nEvent evt) {
// Code for size of response
String select4;
select4 = (String)jComboBox4.getSele ctedItem() ;
if (select4 == "9x5 NBD") bstring = bstring + "1";
else if (select4 == "9x5x4") bstring = bstring + "2";
else if (select4 == "24x7x4") bstring = bstring + "3";
jTextField1.setText(bstrin g);
}
private void jComboBox3ActionPerformed( java.awt.e vent.Actio nEvent evt) {
// Code for size of cache
String select3;
select3 = (String)jComboBox3.getSele ctedItem() ;
if (select3 == "Standard") bstring = bstring + "A";
else if (select3 == "2TB Cache") bstring = bstring + "B";
jTextField1.setText(bstrin g);
}
private void jButton2ActionPerformed(ja va.awt.eve nt.ActionE vent evt) {
// Code for clear
jComboBox1.setSelectedInde x(0);
jComboBox2.setSelectedInde x(0);
jComboBox3.setSelectedInde x(0);
jComboBox4.setSelectedInde x(0);
jComboBox5.setSelectedInde x(0);
bstring ="";
jTextField1.setText(" ");
}
private void jComboBox2ActionPerformed( java.awt.e vent.Actio nEvent evt) {
// Code for # of drives
String select2;
select2 = (String)jComboBox2.getSele ctedItem() ;
bstring = bstring + select2 +"D";
jTextField1.setText(bstrin g);
}
private void jComboBox1ActionPerformed( java.awt.e vent.Actio nEvent evt) {
// Code for # of slots
String select1;
select1 = (String)jComboBox1.getSele ctedItem() ;
bstring = bstring + "AA" + select1 + "-";
jTextField1.setText(bstrin g);
}
/**
* @My class scope cariables :-)
*/
String bstring ="";
public static void aa() { // a.k.a. main originally no aa static?
java.awt.EventQueue.invoke Later(new Runnable() {
public void run() {
new SDP().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JComboBox jComboBox1;
private javax.swing.JComboBox jComboBox2;
private javax.swing.JComboBox jComboBox3;
private javax.swing.JComboBox jComboBox4;
private javax.swing.JComboBox jComboBox5;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JPanel jPanel1;
private javax.swing.JTextField jTextField1;
// End of variables declaration
//}
public void search(String partnum) {
Connection conn=null;
Statement stmt=null;
String sql="";
ResultSet rs=null;
try {
conn=DriverManager.getConn ection("jd bc:odbc:ex cel","","" );
stmt=conn.createStatement( );
sql="select * from [Sheet1$] " +
"where Code='"+ partnum +"'";
rs=stmt.executeQuery(sql);
String output = "";
boolean resultFound = false;
while(rs.next()){
resultFound = true;
output = output + ("Part Number: " + rs.getString("Code")
+ "\n\nDescription: "+ rs.getString("Product") + "\n\nList:\t$"+ rs.getString("List")
+ "\nLatin America\t$"+ rs.getString("ListL") + "\nAsia Pacific\t$"+ rs.getString("ListA") +"\nJapan\t$"
+ rs.getString("ListJ") + "\n\nDistributor:\t$" + rs.getString("Dist") + "\nLatin America\t$" + rs.getString("DistL")
+ "\nAsia Pacific\t$" + rs.getString("DistA") + "\nJapan\t$" + rs.getString("DistJ") + "\n\nSystems Int: \t$"
+ rs.getString("Sys Int") + "\nLatin America: \t$" + rs.getString("Sys IntL")+ "\nAsia Pacific: \t$"
+ rs.getString("Sys IntA") + "\nJapan: \t$" + rs.getString("Sys IntJ"));
JTextArea outputA = new JTextArea();
outputA.setText(output);
// Display results from excel query
JOptionPane.showMessageDia log(null, outputA); <----------- HERE IS THE OUTPUT LINE
}
if(!resultFound) {
JOptionPane.showMessageDia log(null, "\nInvalid configuration or not found.\n\nPlease press Clear and retry.\n\n");
}
}
catch (Exception e){
System.err.println(e);
}
finally {
try{
rs.close();
stmt.close();
conn.close();
rs=null;
stmt=null;
conn=null;
}
catch(Exception e){}
}
}
}
Orig data:(in exel)
59,198 44,398 50,318 63,583
After reading in and outputting to screen:
59197.5 44398.0 50318.0 63582.5
CODE:
/*
* SDP.java
*
* Created on March 29, 2007, 4:16 PM
*/
package my.SDP;
import javax.swing.*;
import java.sql.*;
/**
*
* @author Karl Smith
*/
public class SDP extends javax.swing.JFrame {
/** Creates new form SDP */
public SDP() {
initComponents();
}
/** 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.
*/
// <editor-fold defaultstate="collapsed" desc=" Generated Code ">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jComboBox1 = new javax.swing.JComboBox();
jComboBox2 = new javax.swing.JComboBox();
jComboBox3 = new javax.swing.JComboBox();
jComboBox4 = new javax.swing.JComboBox();
jComboBox5 = new javax.swing.JComboBox();
jLabel6 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
setDefaultCloseOperation(j
setCursor(new java.awt.Cursor(java.awt.C
jPanel1.setBorder(javax.sw
jLabel1.setText("Slots");
jLabel2.setText("Drives");
jLabel3.setText("Cache");
jLabel4.setText("Response"
jLabel5.setText("Years");
jComboBox1.setModel(new javax.swing.DefaultComboBo
jComboBox1.setPreferredSiz
jComboBox1.addActionListen
public void actionPerformed(java.awt.e
jComboBox1ActionPerformed(
}
});
jComboBox2.setModel(new javax.swing.DefaultComboBo
jComboBox2.setPreferredSiz
jComboBox2.addActionListen
public void actionPerformed(java.awt.e
jComboBox2ActionPerformed(
}
});
jComboBox3.setModel(new javax.swing.DefaultComboBo
jComboBox3.setPreferredSiz
jComboBox3.addActionListen
public void actionPerformed(java.awt.e
jComboBox3ActionPerformed(
}
});
jComboBox4.setModel(new javax.swing.DefaultComboBo
jComboBox4.setPreferredSiz
jComboBox4.addActionListen
public void actionPerformed(java.awt.e
jComboBox4ActionPerformed(
}
});
jComboBox5.setModel(new javax.swing.DefaultComboBo
jComboBox5.setPreferredSiz
jComboBox5.addActionListen
public void actionPerformed(java.awt.e
jComboBox5ActionPerformed(
}
});
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jP
jPanel1.setLayout(jPanel1L
jPanel1Layout.setHorizonta
jPanel1Layout.createParall
.addGroup(jPanel1Layout.cr
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.cr
.addComponent(jLabel5)
.addComponent(jLabel3)
.addComponent(jLabel2)
.addComponent(jLabel1)
.addComponent(jLabel4))
.addGap(25, 25, 25)
.addGroup(jPanel1Layout.cr
.addComponent(jComboBox2, javax.swing.GroupLayout.Al
.addComponent(jComboBox3, javax.swing.GroupLayout.Al
.addComponent(jComboBox4, javax.swing.GroupLayout.Al
.addComponent(jComboBox5, 0, javax.swing.GroupLayout.DE
.addComponent(jComboBox1, javax.swing.GroupLayout.PR
.addContainerGap(41, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalG
jPanel1Layout.createParall
.addGroup(jPanel1Layout.cr
.addContainerGap()
.addGroup(jPanel1Layout.cr
.addComponent(jLabel1, javax.swing.GroupLayout.Al
.addComponent(jComboBox1, javax.swing.GroupLayout.Al
.addGroup(jPanel1Layout.cr
.addGroup(jPanel1Layout.cr
.addGap(17, 17, 17)
.addComponent(jComboBox2, javax.swing.GroupLayout.PR
.addGroup(javax.swing.Grou
.addGap(23, 23, 23)
.addComponent(jLabel2)))
.addGroup(jPanel1Layout.cr
.addGroup(jPanel1Layout.cr
.addGap(19, 19, 19)
.addComponent(jComboBox3, javax.swing.GroupLayout.PR
.addGroup(javax.swing.Grou
.addGap(25, 25, 25)
.addComponent(jLabel3)))
.addGap(35, 35, 35)
.addGroup(jPanel1Layout.cr
.addComponent(jComboBox4, javax.swing.GroupLayout.Al
.addComponent(jLabel4, javax.swing.GroupLayout.Al
.addGroup(jPanel1Layout.cr
.addGroup(jPanel1Layout.cr
.addGap(20, 20, 20)
.addComponent(jComboBox5, javax.swing.GroupLayout.PR
.addGroup(javax.swing.Grou
.addGap(26, 26, 26)
.addComponent(jLabel5)))
.addContainerGap(16, Short.MAX_VALUE))
);
jLabel6.setText("Part#");
jButton1.setText("Submit")
jButton1.addActionListener
public void actionPerformed(java.awt.e
jButton1ActionPerformed(ev
}
});
jButton2.setText("Clear");
jButton2.addActionListener
public void actionPerformed(java.awt.e
jButton2ActionPerformed(ev
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(ge
getContentPane().setLayout
layout.setHorizontalGroup(
layout.createParallelGroup
.addGroup(layout.createSeq
.addGroup(layout.createPar
.addGroup(javax.swing.Grou
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.DE
.addGroup(javax.swing.Grou
.addGap(23, 23, 23)
.addComponent(jLabel6)
.addPreferredGap(javax.swi
.addComponent(jTextField1,
.addGap(31, 31, 31)
.addComponent(jButton2)
.addPreferredGap(javax.swi
.addComponent(jButton1)))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup
.addGroup(layout.createSeq
.addContainerGap()
.addComponent(jPanel1, javax.swing.GroupLayout.PR
.addGap(15, 15, 15)
.addGroup(layout.createPar
.addComponent(jLabel6)
.addComponent(jTextField1,
.addComponent(jButton1)
.addComponent(jButton2))
.addContainerGap(17, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void jButton1ActionPerformed(ja
search(bstring);
}
private void jComboBox5ActionPerformed(
// Code for size of years
String select5;
select5 = (String)jComboBox5.getSele
if (select5 == "2 Years Additional") bstring = bstring + "W36";
else if (select5 == "1 Year Uplift") bstring = bstring + "W12";
else if (select5 == "3 Years Uplift") bstring = bstring + "W36";
else if (select5 == "1 Year Post") bstring = bstring + "P12";
else if (select5 == "3 Years Post") bstring = bstring + "P36";
jTextField1.setText(bstrin
}
private void jComboBox4ActionPerformed(
// Code for size of response
String select4;
select4 = (String)jComboBox4.getSele
if (select4 == "9x5 NBD") bstring = bstring + "1";
else if (select4 == "9x5x4") bstring = bstring + "2";
else if (select4 == "24x7x4") bstring = bstring + "3";
jTextField1.setText(bstrin
}
private void jComboBox3ActionPerformed(
// Code for size of cache
String select3;
select3 = (String)jComboBox3.getSele
if (select3 == "Standard") bstring = bstring + "A";
else if (select3 == "2TB Cache") bstring = bstring + "B";
jTextField1.setText(bstrin
}
private void jButton2ActionPerformed(ja
// Code for clear
jComboBox1.setSelectedInde
jComboBox2.setSelectedInde
jComboBox3.setSelectedInde
jComboBox4.setSelectedInde
jComboBox5.setSelectedInde
bstring ="";
jTextField1.setText(" ");
}
private void jComboBox2ActionPerformed(
// Code for # of drives
String select2;
select2 = (String)jComboBox2.getSele
bstring = bstring + select2 +"D";
jTextField1.setText(bstrin
}
private void jComboBox1ActionPerformed(
// Code for # of slots
String select1;
select1 = (String)jComboBox1.getSele
bstring = bstring + "AA" + select1 + "-";
jTextField1.setText(bstrin
}
/**
* @My class scope cariables :-)
*/
String bstring ="";
public static void aa() { // a.k.a. main originally no aa static?
java.awt.EventQueue.invoke
public void run() {
new SDP().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JComboBox jComboBox1;
private javax.swing.JComboBox jComboBox2;
private javax.swing.JComboBox jComboBox3;
private javax.swing.JComboBox jComboBox4;
private javax.swing.JComboBox jComboBox5;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JPanel jPanel1;
private javax.swing.JTextField jTextField1;
// End of variables declaration
//}
public void search(String partnum) {
Connection conn=null;
Statement stmt=null;
String sql="";
ResultSet rs=null;
try {
conn=DriverManager.getConn
stmt=conn.createStatement(
sql="select * from [Sheet1$] " +
"where Code='"+ partnum +"'";
rs=stmt.executeQuery(sql);
String output = "";
boolean resultFound = false;
while(rs.next()){
resultFound = true;
output = output + ("Part Number: " + rs.getString("Code")
+ "\n\nDescription: "+ rs.getString("Product") + "\n\nList:\t$"+ rs.getString("List")
+ "\nLatin America\t$"+ rs.getString("ListL") + "\nAsia Pacific\t$"+ rs.getString("ListA") +"\nJapan\t$"
+ rs.getString("ListJ") + "\n\nDistributor:\t$" + rs.getString("Dist") + "\nLatin America\t$" + rs.getString("DistL")
+ "\nAsia Pacific\t$" + rs.getString("DistA") + "\nJapan\t$" + rs.getString("DistJ") + "\n\nSystems Int: \t$"
+ rs.getString("Sys Int") + "\nLatin America: \t$" + rs.getString("Sys IntL")+ "\nAsia Pacific: \t$"
+ rs.getString("Sys IntA") + "\nJapan: \t$" + rs.getString("Sys IntJ"));
JTextArea outputA = new JTextArea();
outputA.setText(output);
// Display results from excel query
JOptionPane.showMessageDia
}
if(!resultFound) {
JOptionPane.showMessageDia
}
}
catch (Exception e){
System.err.println(e);
}
finally {
try{
rs.close();
stmt.close();
conn.close();
rs=null;
stmt=null;
conn=null;
}
catch(Exception e){}
}
}
}
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
BTW use StringBuilders for string concatenation
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ah the actual values in the spreadsheet were x.50 -- it was showing rounded -- ok so why does java round down when I do int and only show one digit (x.0) when I do Double. Round .5 down?
Hmm, not sure.
Integers are always rounded to floor, so:
int value = (int) 3.5; //value = 3
int value = (int) 3.7; //value = 3
But doubles should keep their fractional part, I still think it has todo with the formatting of your excel sheet. Did you put it on number or string?
Mark
Integers are always rounded to floor, so:
int value = (int) 3.5; //value = 3
int value = (int) 3.7; //value = 3
But doubles should keep their fractional part, I still think it has todo with the formatting of your excel sheet. Did you put it on number or string?
Mark
How did that work? You need to have if ( select5.equalsIgnoreCase ( "2 Years Additional" ) )