java jdbc 更新_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+ "\t" + name + "\t" + age + "\t" +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();

}

}

}

}