得到数据库日期

import java.sql.Connection;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

得到数据库日期
public class DataBaseUtil {


public static Date getCurrentDate(){
String sql = "select sysdate from dual";
ConnectionPool cp = new ConnectionPool(10);
Connection conn = null;
Statement st = null;
ResultSet rs = null;
Date date =null;
try {
conn = cp.getConnection();
st = conn.createStatement();
rs = st.executeQuery(sql);
while(rs.next())
date = rs.getDate("sysdate");

} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
rs.close();
st.close();

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return date;

}
}

private String adduser = "insert into user1(name,passwd,email,phone,reg_date) values(?,?,?,?,?)";
//用户注册
public void addUser(User user) {

try {
conn = pool.getConnection();
stmt = conn.prepareStatement(adduser);

stmt.setString(1, user.getName());
stmt.setString(2, user.getPasswd());
stmt.setString(3, user.getEmail());
stmt.setString(4, user.getPhone());
stmt.setDate(5, DataBaseUtil.getCurrentDate());

int num = stmt.executeUpdate();
if (num > 0) {
System.out.println("插入成功");
} else {
conn.rollback();
System.out.println("插入失败");
}

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if(stmt != null && res != null){
res.close();
stmt.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

}

//测试方法用到 增加用户

@Test
public void testaddUser(){
UserDaoOption udo=new UserDaoOption();
User user=new User();
user.setUsreId(3);
user.setName("张大三");
user.setPasswd("123456");
user.setEmail("zhangsan@.163.com");
user.setPhone("15888888888");
user.setReg_date(DataBaseUtil.getCurrentDate());
System.out.println(user.getUsreid()+" "+user.getName()+" "+user.getPasswd()+" "+user.getEmail()
+" "+user.getPhone()+" "+user.getReg_date());
udo.addUser(user);