import java.sql.*;

import java.text.DateFormat;

//數(shù)據(jù)庫的查詢

public class SelectTable {

String dbDriver="com.mysql.jdbc.Driver";

String dbUrl="jdbc:mysql://localhost:3306/sss";//根據(jù)實(shí)際情況變化

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);//注意是三個(gè)參數(shù)

}

catch (SQLException e)

{

e.printStackTrace();

}

return conn;

}

public void select(){

Connection conn = getConn();

try{

Statement stmt = conn.createStatement(); //創(chuàng)建Statement對象

System.out.println("成功連接到數(shù)據(jù)庫！");

String sql = "select * from jdbc"; //要執(zhí)行的SQL

ResultSet rs = stmt.executeQuery(sql);//創(chuàng)建數(shù)據(jù)對象

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("成功連接到數(shù)據(jù)庫！");

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格式的時(shí)間轉(zhuǎn)換為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();

}

}

原文：http://www.jb51.net/article/52634.htm

總結(jié)

以上是生活随笔為你收集整理的mysql改date格式_mysql数据库修改添加Date格式列的方法的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。