Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. fdate-->observingtextfield
  2.  
  3. JFormattedTextField dateField = new JFormattedTextField(new SimpleDateFormat("dd/MM/yyyy"));
  4. dateField.setValue(new java.util.Date());
  5. java.util.Date theDate = (java.util.Date)dateField.getValue();
  6. java.sql.Date sqlDate;
  7. sqlDate = new java.sql.Date(fdate.getText());
  8.  
  9. Class.forName("com.mysql.jdbc.Driver").newInstance();
  10. Connection c = DriverManager.getConnection("jdbc:mysql://localhost/fundedprojects", "root", "root");
  11. //System.out.println("connectiClasson successful");
  12. st = c.createStatement();
  13.  
  14. PreparedStatement stat2 = c.prepareStatement("insert into addtb(name,dept,desg,type,agency,amt,dosn,fdats,tdats) values(?,?,?,?,?,?,?,?,?)");
  15. //System.out.println("connection successful");
  16. stat2.setString(1, tfname.getText().toLowerCase());
  17. stat2.setString(2, (String) cfdept.getSelectedItem());
  18. stat2.setString(3, (String) cfdesg.getSelectedItem());
  19. stat2.setString(4, (String) ctype.getSelectedItem());
  20. stat2.setString(5, (String) cfunage.getSelectedItem());
  21. stat2.setString(6, tamt.getText());
  22. stat2.setDate(7, sqlDate);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement