?

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格式的時間轉換為datelong 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();} }

mysql資料庫修改新增Date格式列的方法

相關文章