Stanley Mungai

Tony, I am the One who asked the Question even at stackoverflow,, I Understand How it works and What I do not Understand is the format pattern.

Hello friends I am writing String to A file like this as I got it from http://stackoverflow.com/questions/15949737/write-string-to-a-specific-position-in-file/15949990?noredirect=1#15949990:

I however need to write Upto four Strings in this format and I do not know How to go About this

import java.io.BufferedWriter; import java.io.File; import java.io.FileWriter; import java.io.IOException; public class Test { public static void main(String[] args) throws IOException { String myname = "JOHN DOE MAXWELL"; String myotherName = "MELCHIZEDEK NEBUCHARDINEZZAR"; String mylocation = "SOUTH EAST"; String myotherlocation = "SOUTH WEST"; File f = new File("MyFile.txt"); BufferedWriter bw = new BufferedWriter(new FileWriter(f)); bw.write(String.format("%-50s%s", myname, mylocation)); bw.newLine(); bw.write(String.format("%-50s%s", myotherName, myotherlocation)); bw.close(); } }

What Would I need to do if I wanted to write three Strings or More like

bw.write(String.format("%-50s%s", myotherName, myotherlocation, myHometown));

Please Help

Oh Nice I can see it Now But have Other components on The Jpanel. I will Habe to Shrink Them too?

The List Is still there without the Scroll Pane

It looks the same ..The List is there without the ScrollPane

Yes RItchie I see the List But I do not See the Scroll Pane and If the List is very Long it Disappers into the JPanel.

Hi friends I am trying to Get A Jlist Into a scrollpane But I do not seem to succees because I do not see the ScrollPane:

public class Checkboxlistener extends JFrame { private JPanel jpAcc = new JPanel(); private JList checkBoxesJList; Checkboxlistener() { // super("Deposit base", false, true, false, true); setSize(1300, 600); jpAcc.setLayout(null); jpAcc.setBackground(Color.LIGHT_GRAY); String labels[] = {"A", "B", "C", "D", "E", "F", "G", "H", "I", "J"}; checkBoxesJList = new JList(labels); checkBoxesJList.setBounds(10, 30, 80, 600); checkBoxesJList.setBackground(Color.LIGHT_GRAY); checkBoxesJList.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); JScrollPane scrollPane = new JScrollPane(checkBoxesJList); jpAcc.add(checkBoxesJList); jpAcc.add(scrollPane); getContentPane().add(jpAcc); setVisible(true); } public static void main(String args[]) { Checkboxlistener cbl = new Checkboxlistener(); } }

What am I doing wrong?

Ok Got it thanks

Hello friends, I have this Piedataset that I am creating from an Oracle database Like this:

final PieDataset dataset = createDataset(schm); final JFreeChart chart = createChart(dataset); final ChartPanel chartPanel = new ChartPanel(chart); chartPanel.setPreferredSize(new Dimension(900, 900)); chartPanel.setBounds(550, 30, 700, 500); ..................................................................... private PieDataset createDataset(String schm) throws SQLException, ClassNotFoundException { // create the dataset... Connection conn = null; Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.80:1521:simba9i", "SYSTEM", "system123"); final DefaultPieDataset dataset = new JDBCPieDataset(conn, "select distinct SCHM_CODE, sum(DEP_AMT) as AMOUNT from DLY_DEP_VIEW where schm_code = '" + schm + "' group by schm_code"); try { } catch (Exception ad) { JOptionPane.showMessageDialog(this, ad, "Error", JOptionPane.ERROR_MESSAGE); } return dataset; } private JFreeChart createChart(final PieDataset dataset) { // create the chart... final JFreeChart chart = ChartFactory.createPieChart3D( "Deposit Base", dataset, true, true, false); // set the background color for the chart... chart.setBackgroundPaint(Color.white); // get a reference to the plot for further customisation... final PiePlot3D plot = (PiePlot3D) chart.getPlot(); plot.setLabelGenerator(null); plot.setForegroundAlpha(1f); plot.setNoDataMessage("No data to display"); return chart; }

I also have a JList on the same Screen that I have Rendered to Checkboxes and I have added a ListSelectionListener

checkBoxesJList.addListSelectionListener(new ListSelectionListener() { public void valueChanged(ListSelectionEvent evt) { if (evt.getValueIsAdjusting()) { return; } Object[] temp = checkBoxesJList.getSelectedValues(); for (int i = 0; i < temp.length; i++) { // System.out.println(temp[i]); Connection conn = null; schm = temp[i].toString(); System.out.println(schm); try { createDataset(schm); } catch (Exception ae) { } } } });

I need the Pie chart to refresh with the New Values say if I click on one checkbox the dataset should change But My Pie chart is not refreshing. Wgat could I be doing wrong? I will appreciate example too.

NO Ritchie, The hashing is Happening from the database. When Creating a New User from Swing Application, the query:

exec MUNGAI.p_auth_insert_user('USERNAME', 'Password', 'WorkClass');
is executed that Calls the Procedure above to Hash the password so that the database users are not able to view it.

HI Guys I have Built a Java Swing Application that Connects to a Database, I have Been Using Mysql But I have Changed to Oracle 11g and Now I am facing Problems authanticating user Log in from the Aplication. I have Hashed the Password using this Procedure:

CREATE OR REPLACE procedure MUNGAI.p_auth_insert_user (par_username in varchar2, par_password in varchar2, par_work in varchar2 ) is l_hash raw(2000); begin l_hash := dbms_crypto.hash (utl_i18n.string_to_raw (par_password || par_work || upper(par_username), 'AL32UTF8' ), dbms_crypto.hash_sh1 ); insert into user_login_table (user_name, p_word, work_class) values (par_username, l_hash, par_work); end p_auth_insert_user; /


I Insert into the Database from the Java Application Using the Query:

exec MUNGAI.p_auth_insert_user('USERNAME', 'Password', 'WorkClass');


My Problem is that when the user Logs in Using the Correct Credentials the login fails. Initially While I was Using MYSQL I Used:
select * from user_login_table where user_name = 'username' and Pass_word = SHA1('password');


Am looking for the best way to authenticate user login from My swing App.

Hi Guys, I have Been Writing data to a .dat file in My Local Machine File.dat. I have FTP ed the File to an Online Location http://domain.com/File.dat. Is thete a way to write to the File now that it is not In My Local Machine?

I have Been Using this Code to Write to It...

void saveFile () { try { FileOutputStream fos = new FileOutputStream ("File.dat", true); DataOutputStream dos = new DataOutputStream (fos); dos.writeUTF (saves[count][0]); dos.writeUTF (saves[count][1]); dos.writeUTF (saves[count][2]); dos.writeUTF (saves[count][3]); dos.writeUTF (saves[count][4]); dos.writeUTF (saves[count][5]); JOptionPane.showMessageDialog (this, "The Record has been Saved Successfully", "Record Saved", JOptionPane.PLAIN_MESSAGE); txtClear (); dos.close(); fos.close(); } catch (IOException ioe) { JOptionPane.showMessageDialog (this, "There are Some Problem with File", "Problem", JOptionPane.PLAIN_MESSAGE); } }

Is there a way to do what Am trying to Do and if Yes, What is the best Way to do it?

Hi Guys I am Displaying the Content of a MySql Database Table in a JTable where Status = 'O', After I select one record, the details are displayed in a different GUI and After an action Event on the new JFrame, the Status of the table is update to 'R' so that it does Not meet the Criteria for the Next Display in the JTable. Right After that I am Supposed to Go back to the Jtable GUI to select another record, so the selected record Should not be there. But In My Application the earlier Selected record is there even after the Database table Status has been Update to 'R' and I have to exit the Entire Program for the Effect to take Place. Is there a way in which I can go back to find the Jtable GUI refreshed so that the selected Records are still not there....

NB: The Database table is getting Update Well

Here is the Class for Display In the JTable:

import java.awt.BorderLayout; import java.awt.Dimension; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import java.sql.Connection; import java.sql.ResultSet; import java.awt.event.MouseEvent; import java.util.Vector; import java.awt.event.MouseAdapter; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.*; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JPanel; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.table.DefaultTableModel; import javax.swing.table.TableColumn; public class DisplayOrderedParts extends JFrame{ static Vector<Vector<String>> data = new Vector<Vector<String>>(); static JTable table; DisplayOrderedParts(final String st) throws InterruptedException, SQLException{ super("Order Details Inquiry"); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); JPanel topPanel = new JPanel(); getContentPane().add(topPanel, BorderLayout.PAGE_START); Vector<String> headers = new Vector<String>(); headers.add("Order Number"); headers.add("Date"); headers.add("Part Number"); headers.add("Part Name"); headers.add("Application"); headers.add("Quantity"); headers.add("Total Cost"); headers.add("Supplier"); headers.add("Country"); getData(); //this is the model which contain actual body of JTable DefaultTableModel model = new DefaultTableModel(data, headers); table = new JTable(model); table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS); //table.enable(false); table.addMouseListener(new DisplayOrderedParts.MyMouseAdapter()); boolean b = table.isCellEditable(WIDTH, WIDTH); b = false; header_size(); JScrollPane scroll = new JScrollPane(table); scroll.setHorizontalScrollBarPolicy( JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED); scroll.setVerticalScrollBarPolicy( JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED); getContentPane().add(scroll, BorderLayout.PAGE_START); pack(); setResizable(false); setVisible(true); setSize(1000, 700); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } /** * Setting the particular Column Size in JTable */ public static void header_size() { TableColumn column = table.getColumnModel().getColumn(0); column.setPreferredWidth(100); column = table.getColumnModel().getColumn(1); column.setPreferredWidth(100); } /** * Fetching Data From MySql Database and storing in a Vector of a Vector to * Display in JTable */ private static void getData() throws SQLException { // Enter Your MySQL Database Table name in below Select Query. String str = "select order_number, Part_number, spare_desc, vehicle_app, qnty_ordered," + "seller_name, total_purchases, country, order_date from order_details_table where status = 'O'"; Connection cn = null; ResultSet rs; Statement st; try { // Change the database name, hosty name, // port and password as per MySQL installed in your PC. cn = DriverManager.getConnection("jdbc:mysql://" + "localhost:3306/test", "root", "gatungo@123"); st = cn.createStatement(); rs = st.executeQuery(str); while (rs.next()) { Vector<String> d = new Vector<String>(); d.add(rs.getString("order_number")); d.add(rs.getString("order_date")); d.add(rs.getString("Part_number")); d.add(rs.getString("spare_desc")); d.add(rs.getString("vehicle_app")); d.add(rs.getString("qnty_ordered")); d.add(rs.getString("total_purchases")); d.add(rs.getString("seller_name")); d.add(rs.getString("country")); d.add("\n\n\n\n\n\n\n"); data.add(d); } cn.close(); } catch (SQLException e) { e.printStackTrace(); } } public class MyMouseAdapter extends MouseAdapter { public void mousePressed(MouseEvent e) { int colIdx = table.columnAtPoint(e.getPoint()); int rowIdx = table.rowAtPoint(e.getPoint()); Object obj = table.getModel().getValueAt(rowIdx, colIdx) ; String order = obj.toString(); JOptionPane.showMessageDialog(null,"Receive Order "+ order + "?", "Success", JOptionPane.INFORMATION_MESSAGE); // return; try { SelectOrder seo = new SelectOrder(order); seo.setVisible(true); //setVisible(false); dispose(); } catch (InterruptedException ex) { Logger.getLogger(DisplayOrderedParts.class.getName()).log(Level.SEVERE, null, ex); } } } }


And this is the Class for Displaying the details, and Updating the Database table Status;



import java.awt.Window; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.*; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.Date; /** * * @author implvcb */ public class SelectOrder extends JFrame { SelectOrder(final String order) throws InterruptedException { setLayout(null); setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE); setTitle("Enter Products To Store"); setSize(1024, 768); final JLabel header, menu, lrdate, user, lpart, ldesc, lapp, lqnty, lcost, lcountry, lstore, llocation, lretail; final JTextField option, tpart, tdesc, tapp, tqnty, tcost, tcountry, tstore, tlocation, tretail, trdate; final JButton go, store, back, bmenu; header = new JLabel(); menu = new JLabel(); lrdate = new JLabel("Delivery Date"); lrdate.setVisible(false); user = new JLabel(); option = new JTextField(); go = new JButton("INQUIRE"); store = new JButton("STORE ITEMS"); store.setVisible(false); back = new JButton("BACK TO ORDERS"); bmenu = new JButton("BACK TO MENU"); lpart = new JLabel("Part Number"); lpart.setVisible(false); ldesc = new JLabel("Description"); ldesc.setVisible(false); lapp = new JLabel("Application"); lapp.setVisible(false); lqnty = new JLabel("Quantity"); lqnty.setVisible(false); lcost = new JLabel("Cost per Unit"); lcost.setVisible(false); lcountry = new JLabel("Country"); lcountry.setVisible(false); lstore = new JLabel("Store Name"); lstore.setVisible(false); llocation = new JLabel("Store Location"); llocation.setVisible(false); lretail = new JLabel("Selling Price"); lretail.setVisible(false); tpart = new JTextField(); tpart.setVisible(false); tpart.setEditable(false); tdesc = new JTextField(); tdesc.setVisible(false); tdesc.setEditable(false); tapp = new JTextField(); tapp.setVisible(false); tapp.setEditable(false); tqnty = new JTextField(); tqnty.setVisible(false); tqnty.setEditable(false); tcost = new JTextField(); tcost.setVisible(false); tcost.setEditable(false); tcountry = new JTextField(); tcountry.setVisible(false); tcountry.setEditable(false); tstore = new JTextField(); tstore.setVisible(false); tlocation = new JTextField(); tlocation.setVisible(false); tretail = new JTextField(); tretail.setVisible(false); trdate = new JTextField(); trdate.setVisible(false); trdate.setEditable(false); header.setBounds(370, 10, 200, 20); menu.setBounds(10, 60, 200, 20); option.setBounds(150, 60, 200, 20); option.setText(order); option.setEditable(false); lpart.setBounds(400, 60, 200, 20); tpart.setBounds(500, 60, 200, 20); ldesc.setBounds(10, 110, 200, 20); tdesc.setBounds(150, 110, 200, 20); lapp.setBounds(400, 110, 200, 20); tapp.setBounds(500, 110, 200, 20); lqnty.setBounds(10, 160, 200, 20); tqnty.setBounds(150, 160, 200, 20); lcost.setBounds(400, 160, 200, 20); tcost.setBounds(500, 160, 200, 20); lcountry.setBounds(10, 210, 200, 20); tcountry.setBounds(150, 210, 200, 20); lretail.setBounds(400, 210, 200, 20); tretail.setBounds(500, 210, 200, 20); lstore.setBounds(10, 260, 200, 20); tstore.setBounds(150, 260, 200, 20); llocation.setBounds(400, 260, 200, 20); tlocation.setBounds(500, 260, 200, 20); lrdate.setBounds(10, 310, 200, 20); trdate.setBounds(150, 310, 200, 20); go.setBounds(750, 10, 150, 30); store.setBounds(750, 50, 150, 30); back.setBounds(750, 100, 150, 30); bmenu.setBounds(750, 150, 150, 30); user.setBounds(10, 10, 200, 20); header.setText("Enter Product To Store"); menu.setText("Order Number"); add(header); add(menu); add(option); add(lpart); add(tpart); add(ldesc); add(tdesc); add(lapp); add(tapp); add(lqnty); add(tqnty); add(lcost); add(tcost); add(lcountry); add(tcountry); add(lstore); add(tstore); add(llocation); add(tlocation); add(lretail); add(tretail); add(lrdate); add(trdate); add(go); add(store); add(back); add(bmenu); add(user); getRootPane().setDefaultButton(go); go.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { try { lpart.setVisible(true); tpart.setVisible(true); ldesc.setVisible(true); tdesc.setVisible(true); lapp.setVisible(true); tapp.setVisible(true); lqnty.setVisible(true); tqnty.setVisible(true); lcost.setVisible(true); tcost.setVisible(true); lcountry.setVisible(true); tcountry.setVisible(true); lstore.setVisible(true); tstore.setVisible(true); llocation.setVisible(true); tlocation.setVisible(true); lretail.setVisible(true); tretail.setVisible(true); store.setVisible(true); lrdate.setVisible(true); trdate.setVisible(true); Connection conn = null; String url = "jdbc:mysql://localhost:3306/"; String db = "test"; String driver = "com.mysql.jdbc.Driver"; Class.forName(driver); conn = DriverManager.getConnection(url + db, "root", "gatungo@123"); Statement st = conn.createStatement(); String quer = "select part_number, spare_desc, vehicle_app, qnty_ordered, cost_per_unit," + "country from order_details_table where order_number = '" + order + "'"; ResultSet rs = st.executeQuery(quer); while (rs.next()) { String partno = rs.getString("part_number"); String sparedesc = rs.getString("spare_desc"); String vapp = rs.getString("vehicle_app"); String qunty = rs.getString("qnty_ordered"); String costper = rs.getString("cost_per_unit"); String country = rs.getString("country"); DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy"); Date date = new Date(); trdate.setText(dateFormat.format(date)); //ResultSet rs = st.executeUpdate(val); // st.execute(quer); tpart.setText(partno); tdesc.setText(sparedesc); tapp.setText(vapp); tqnty.setText(qunty); tcost.setText(costper); tcountry.setText(country); } } catch (ClassNotFoundException ex) { Logger.getLogger(SelectOrder.class.getName()).log(Level.SEVERE, null, ex); } catch (SQLException ex) { Logger.getLogger(SelectOrder.class.getName()).log(Level.SEVERE, null, ex); } } }); store.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { try { String price = tretail.getText(); String storename = tstore.getText(); String Plocation = tlocation.getText(); if (price.equals("")) { JOptionPane.showMessageDialog(null, "Selling Price Must Be Entered", "Error", JOptionPane.INFORMATION_MESSAGE); return; } if (storename.equals("")) { JOptionPane.showMessageDialog(null, "Store Name Must Be Entered", "Error", JOptionPane.INFORMATION_MESSAGE); return; } if (Plocation.equals("")) { JOptionPane.showMessageDialog(null, "StoreLocation Must Be Entered", "Error", JOptionPane.INFORMATION_MESSAGE); return; } Connection conn = null; String url = "jdbc:mysql://localhost:3306/"; String db = "test"; String driver = "com.mysql.jdbc.Driver"; Class.forName(driver); conn = DriverManager.getConnection(url + db, "root", "gatungo@123"); Statement st = conn.createStatement(); String partno = tpart.getText(); String sparedesc = tdesc.getText(); String vapp = tapp.getText(); String qunty = tqnty.getText(); String costper = tcost.getText(); String country = tcountry.getText(); String retail = tretail.getText(); String store = tstore.getText(); String location = tlocation.getText(); String rdate = trdate.getText(); String storeit = "INSERT INTO Store_info_table (Part_number, spare_desc, vehicle_app, qnty_received, cost_per_unit" + ", selling_price, country, store_name, store_location, recvd_date) " + "VALUES ('" + partno + "', '" + sparedesc + "', '" + vapp + "', '" + qunty + "', '" + costper + "','" + retail + "','" + country + "','" + store + "','" + location + "','" + rdate + "' )"; st.execute(storeit); String updateOrder = "UPDATE order_details_table set status = 'R' where order_number = '" + order + "'"; st.execute(updateOrder); JOptionPane.showMessageDialog(null,"Item Stored Successfully", "Success", JOptionPane.INFORMATION_MESSAGE); conn.close(); DisplayOrderedParts rop = new DisplayOrderedParts(order); rop.setVisible(true); dispose(); } catch (InterruptedException ex) { Logger.getLogger(SelectOrder.class.getName()).log(Level.SEVERE, null, ex); } catch (ClassNotFoundException ex) { Logger.getLogger(SelectOrder.class.getName()).log(Level.SEVERE, null, ex); } catch (SQLException ex) { Logger.getLogger(SelectOrder.class.getName()).log(Level.SEVERE, null, ex); } } }); back.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { } }); bmenu.addActionListener(new ActionListener() { public void actionPerformed(ActionEvent e) { } }); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); } }


Can some one please tell me what I should Do or What I am Missing out

The Html file and the Jars are all in the same directory if that is what you mean???

Hi guys I have these two Applets that I want to run from My web browser, I need to start the server app and then the client app on a webpage: I wrote this HTNL to do that:

<html> <body> <center> <applet code="com.ays.javachat.server.Main" height="500" width="500"> </applet> <applet code="com.ays.javachat.client.Main" height="500" width="500"> </applet> </center> </body> </html>



When I Launch them them This is the Error I get for Both of them:



Java Plug-in 1.6.0_32 Using JRE version 1.6.0_32-b05 Java HotSpot(TM) Client VM User home directory = C:\Documents and Settings\implvcb ---------------------------------------------------- c: clear console window f: finalize objects on finalization queue g: garbage collect h: display this help message l: dump classloader list m: print memory usage o: trigger logging q: hide console r: reload policy configuration s: dump system and deployment properties t: dump thread list v: dump thread stack x: clear classloader cache 0-5: set trace level to <n> ---------------------------------------------------- load: class com.ays.javachat.server.Main not found. load: class com.ays.javachat.client.Main not found. java.lang.ClassNotFoundException: com.ays.javachat.server.Main at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source) at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source) at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Exception: java.lang.ClassNotFoundException: com.ays.javachat.server.Main java.lang.ClassNotFoundException: com.ays.javachat.client.Main at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Unknown Source) at sun.plugin2.applet.Plugin2Manager.createApplet(Unknown Source) at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Exception: java.lang.ClassNotFoundException: com.ays.javachat.client.Main


Can some one Please Assist me in what Kind Of setting I need to make to make the Applets run.
The Applets are running fine on the desktop.