mysql数据库修改添加Date格式列的方法

import java.sql.*;import java.text.DateFormat;//数据库的查询public class SelectTable { String dbDriver="com.mysql.jdbc.Driver"; String dbUrl="jdbc:mysql://localhost:3306/sss";//根据实际情况变化 String username="root"; String p

import java.sql.*; import java.text.DateFormat; //数据库的查询 public class SelectTable {

String dbDriver="com.mysql.jdbc.Driver";  
 String dbUrl="jdbc:mysql://localhost:3306/sss";//根据实际情况变化 
 String username="root"; 
 String password="123"; 
 public Connection getConn() 
 { 
   Connection conn=null; 
   try 
   { 
     Class.forName(dbDriver); 
   } 
   catch (ClassNotFoundException e) 
   { 
     e.printStackTrace(); 
   } 
   try 
   { 
     conn = DriverManager.getConnection(dbUrl,username,password);//注意是三个参数 
   } 
   catch (SQLException e) 
   { 
     e.printStackTrace(); 
   } 
   return conn; 
 } 

public void select(){ Connection conn = getConn(); try{ Statement stmt = conn.createStatement(); //创建Statement对象 System.out.println("成功连接到数据库！"); String sql = "select * from jdbc"; //要执行的SQL ResultSet rs = stmt.executeQuery(sql);//创建数据对象

    System.out.println("id"+"\t"+"name"+"\t"+"brithday");
    while (rs.next()){          
    System.out.print(rs.getInt(1) + "\t");
      System.out.print(rs.getString(2) + "\t");
      System.out.print(rs.getDate(3) + "\t");
      System.out.println();
    }

}catch(Exception e){ e.printStackTrace(); }

  } 

public void insert(){ Connection conn = getConn(); try{ Statement stmt = conn.createStatement(); System.out.println("成功连接到数据库！"); String sql = "insert into jdbc (id,name,birthday) values(?,?,?)"; PreparedStatement pst =conn.prepareStatement(sql); DateFormat df = DateFormat.getDateInstance();

java.util.Date dd = df.parse("2000-12-12");//将YYYY-MM-DD格式的时间转换为date long t = dd.getTime(); java.sql.Date date = new java.sql.Date(t);

pst.setInt(1, 5); pst.setString(2, "limazhi"); pst.setDate(3, date); pst.executeUpdate(); select(); }catch(Exception e){ e.printStackTrace(); }

} public static void main(String args[]){ SelectTable st = new SelectTable(); st.insert(); }

}