java通过jdbc连接数据库并更新数据（包括java.util.Date类型数据的更新）

packagecom.yh.dao;

importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.PreparedStatement;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjava.text.SimpleDateFormat;
importjava.util.Date;

importcom.yh.util.ConfigManager;

public classNewsDao {
    public static voidmain(String[] args) {
        NewsDao nd = newNewsDao();
        nd.addData(005, "洪旭", 21, newDate().getTime());
        nd.getData();
    }

    //查询数据
    public voidgetData() {
        Connection con = null;
        ConfigManager configManager =ConfigManager.getInstance();
        String url = configManager.getString("jdbc.connection.url");
        String username = configManager.getString("jdbc.connection.username");
        String password = configManager.getString("jdbc.connection.password");
        String driver = configManager.getString("jdbc.SQLServerDriver.class");

        try{
            //加载驱动
Class.forName(driver);
            //获得数据库连接
            con =DriverManager.getConnection(url, username, password);
            //执行sql语句
            String sql = "select * from student";
            Statement statement =con.createStatement();
            ResultSet rs =statement.executeQuery(sql);
            while(rs.next()) {
                int id = rs.getInt(1);
                String name = rs.getString(2);
                int age = rs.getInt(3);
                long createDate = rs.getLong(4);
                Date date = newDate(createDate);
                SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
                System.out.println(id + "	" + name + "	" + age + "	" +sdf.format(date));
            }
        } catch(ClassNotFoundException e) {
            e.printStackTrace();
        } catch(SQLException e) {
            //TODO Auto-generated catch block
e.printStackTrace();
        } finally{
            try{
                con.close();
            } catch(SQLException e) {
                //TODO Auto-generated catch block
e.printStackTrace();
            }
        }
    }

    //插入数据
    public void addData(int id, String name, int age, longcreateDate) {
        Connection con = null;
        ConfigManager configManager =ConfigManager.getInstance();
        String url = configManager.getString("jdbc.connection.url");
        String username = configManager.getString("jdbc.connection.username");
        String password = configManager.getString("jdbc.connection.password");
        String driver = configManager.getString("jdbc.SQLServerDriver.class");
        try{
            //加载驱动
Class.forName(driver);
            //获得数据库连接
            con =DriverManager.getConnection(url, username, password);
            //执行sql语句
            String sql = "insert into student (id,name,age,createDate)values(?,?,?,?)";
            PreparedStatement ps =con.prepareStatement(sql);
            ps.setInt(1, id);
            ps.setString(2, name);
            ps.setInt(3, age);
            ps.setLong(4, createDate);
            int line =ps.executeUpdate();
            System.out.println("影响行数：" +line);
        } catch(ClassNotFoundException e) {
            e.printStackTrace();
        } catch(SQLException e) {
            //TODO Auto-generated catch block
e.printStackTrace();
        } finally{
            try{
                //释放资源
                ps.close();
con.close();
            } catch(SQLException e) {
                //TODO Auto-generated catch block
e.printStackTrace();
            }
        }
    }
}