private void getdetailsMouseClicked( java.awt.event.MouseEvent evt) { // GEN-FIRST:event_getdetailsMouseClicked // TODO add your handling code here: det.setText(""); String aid, an, ac, ad, aen, ap, ainfo = null; aid = (String) applist.getSelectedItem(); connector ob = new connector(); int a = Integer.parseInt(aid); try { Connection my = ob.connect(); Statement s = my.createStatement(); ResultSet rs = s.executeQuery("select * from appinfo where appid=" + a); if (rs.next()) { // applist.addItem(rs.getString("appid")); an = "App Name: " + rs.getString("appname"); ac = "Cost: " + rs.getString("appcost"); ad = "Desc: " + rs.getString("appdesc"); aen = "Enhancements: " + rs.getString("appen"); ap = "Power: " + rs.getString("apppow"); ainfo = an + "\n" + ac + "\n" + ad + "\n" + aen + "\n" + ap + "\n\n"; det.setText(ainfo); } } catch (Exception e) { System.out.println(e); } } // GEN-LAST:event_getdetailsMouseClicked
/** Creates new form ViewAppDetails */ public ViewAppDetails() { initComponents(); connector ob = new connector(); try { Connection my = ob.connect(); Statement s = my.createStatement(); ResultSet rs = s.executeQuery("select appid from appinfo"); while (rs.next()) { applist.addItem(rs.getString("appid")); } } catch (Exception e) { System.out.println(e); } }
private void addMouseClicked(java.awt.event.MouseEvent evt) { // GEN-FIRST:event_addMouseClicked // TODO add your handling code here: String a, b, c, d, ee; c = (cphone.getText()); a = cname.getText().trim(); b = caddr.getText().trim(); int cn = Integer.parseInt(c); System.out.println(cn); d = prefer.getText().trim(); ee = "" + capid; connector ob = new connector(); try { Connection my = ob.connect(); Statement s = my.createStatement(); s.execute( "insert into cinfo values(" + cusid + ",'" + a + "'," + cn + ",'" + b + "','" + ee + "','" + d + "')"); } catch (Exception e) { System.out.println(e); } this.setVisible(false); } // GEN-LAST:event_addMouseClicked
/** Creates new form AddCustomer */ public AddCustomer() { initComponents(); connector ob = new connector(); int c = 0; try { Connection my = ob.connect(); Statement s = my.createStatement(); ResultSet rs = s.executeQuery("select cid,cappid from cinfo"); while (rs.next()) { c++; } rs = s.executeQuery("select cid,cappid from cinfo"); int k = 0; while (k < c) { rs.next(); k++; } // rs.previous(); capid = rs.getInt("cappid"); cusid = rs.getInt("cid"); capid++; cusid++; cappid.setText("" + capid); cid.setText("" + cusid); } catch (Exception e) { System.out.println(e); } }