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