Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- How to insert a string date to a mysql database date field
- package events;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.Statement;
- import java.util.Date;
- /**
- *
- * @author mewq
- */
- public class ConDb {
- public static void main(String[] args){
- String description = null;
- try{
- Connection conn = (Connection) DriverManager.getConnection("jdbc:mysql://localhost/tangkilikan", "user=root", "password=tangkilik");
- Statement stat = (Statement) conn.createStatement();
- String eventName = "Imba meeting";
- String Address = "Zamora, Cabarroguis, Quirino";
- Date date = '2011-09-09';
- String description = "meeting";
- String insert = "insert into events values ('" + eventName + "', '" + Address + "', ' + date + ', '" + description + "')";
- stat.executeUpdate(insert);
- } catch(Exception e) {
- }
- }
- }
- DateFormat formatter = new SimpleDateFormat("MM/dd/yy");
- Date date = (Date)formatter.parse("05/15/11");
- String insert = "insert into events values ('" + eventName + "', '" + Address + "', '" + date + "', '" + description + "')";
- Date date = '2011-09-09';
- String dateString = "2011-09-09";
- DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
- Date myDate = formatter.parse(dateString);
- String insert = "insert into events values (?, ? , ? , ?)";
- PreparedStatement ps = conn.prepareStatment(insert);
- ps.setString(1, eventName);
- ps.setString(2, Address);
- ps.setDate(3, myDate);
- ps.setString(4, description);
- ps.executeUpdate();
Add Comment
Please, Sign In to add comment