JDBC中Date类型数据的插入

来源：互联网发布：selfie city照相软件编辑：程序博客网时间：2024/06/05 21:16

package com.mypractice.five;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;/** *  * 2014.07.23 * @author zhutianpeng * 使用单例建立JDBC工具类 */public class JDBCUtil {private static String driver = "com.mysql.jdbc.Driver";private static String url = "jdbc:mysql://localhost:3306/ww";private static String root = "root";private static String password = "sa";private static JDBCUtil jdbcUtil = null;private static Connection conn = null;private JDBCUtil(){}static{try {Class.forName(driver);} catch (ClassNotFoundException e) {System.out.println("【加载驱动失...】");e.printStackTrace();}}/** *  * @return jdbcUtil *  * 实现获取JDBCUtil工具类的对象 */public static JDBCUtil getInstance(){if(jdbcUtil==null){synchronized(JDBCUtil.class){if(jdbcUtil==null){jdbcUtil = new JDBCUtil();}}}return  jdbcUtil;}/** *  * @return conn *  * 获取数据库连接 */public Connection getConnection(){try {conn  = DriverManager.getConnection(url,root,password);} catch (SQLException e) {System.out.println("【获取连接失败...】");e.printStackTrace();}return conn;}/** *  * @param rs * @param st * @param conn *  * 关闭数据库连接 */public void free(ResultSet rs,Statement st,Connection conn){if(rs!=null){try {rs.close();} catch (SQLException e) {System.out.println("【ResultSet关闭失败...】");e.printStackTrace();}finally{if(st!=null){try {st.close();} catch (SQLException e) {System.out.println("【Statement关闭失败...】");e.printStackTrace();}finally{if(conn!=null){try {conn.close();} catch (SQLException e) {System.out.println("【Connection关闭失败...】");e.printStackTrace();}}}}}}}}

package com.mypractice.five;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;import java.util.Date;public class DateTest {/** * @param args * @throws SQLException  */public static void main(String[] args) throws SQLException {create("zhutianpeng",new Date(1992-03-21),222F);}public static void create(String name,Date birthday,float money) throws SQLException{Connection conn = JDBCUtil.getInstance().getConnection();String sql = "insert into user(name,birthday,money)values(?,?,?)";PreparedStatement ps = conn.prepareStatement(sql);ps.setString(1,name);ps.setDate(2,new java.sql.Date(birthday.getTime()));ps.setFloat(3, money);ps.executeUpdate();}}

注：

①一定要将Java的util包中的Date类型转换至Java.sql.Date类型

new java.sql.Date(birthday.getTime())

②sql中的Date类是继承至java.uti.Date类，也就是java.sql.Date类是java.util.Date的子类。

0 0