1.使用ResultSet类的getTimestamp()方法读取字段中的时间 ,其格式为“2017-04-06 11:10:53.0”;
2.使用SimpleDateFormat 类的format()方法来格式化时间格式。格式化后的值为“2017-04-06 11:10:53”;
Demo:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.HashMap;
import java.util.Map;
public class Test {
public static void main(String[] args) throws ParseException {
try{
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
//加载MySql的驱动类
Class.forName("com.mysql.jdbc.Driver") ;
String url = "jdbc:mysql://localhost:3306/e6904285" ;
String username = "root";
String password = "master";
Connection con = DriverManager.getConnection(url , username , password );
String sql = "SELECT p.operatetime,p.prj_examinant, p.prj_name,p.prj_code, "
+ "p.prj_posttime,p.prj_openlocation,pm.pcm_money,pm.pcm_closetime, "
+ "pm.pcm_account,pm.pcm_paytype, pc.pa_auditor,pc.pa_auditresult, "
+ "p.serialno prj_serialno,pc.serialno pc_serialno,pm.serialno pm_serialno, "
+ "pc.pa_audittime FROM project p LEFT JOIN projectcautionmoney pm ON p.serialno = pm.projectfileid LEFT "
+ "JOIN projectaudit pc ON p.serialno = pc.projectfileid "
+ "WHERE p.serialno = ?";
PreparedStatement pstmt = con.prepareStatement(sql) ;
pstmt.setString(1, "4411CD5B166D403C94121CC5A57A6CFB");
ResultSet rs = pstmt.executeQuery();
Map map = new HashMap();
while(rs.next()){
map.put("prj_opentime", sdf.format(rs.getTimestamp("operatetime") ));
map.put("prj_posttime", rs.getString("prj_posttime"));
map.put("prj_openlocation", rs.getString("prj_openlocation"));
map.put("pcm_closetime", rs.getString("pcm_closetime"));
map.put("pcm_account", rs.getString("pcm_account"));
map.put("pcm_money", rs.getString("pcm_money"));
map.put("pcm_paytype", rs.getString("pcm_paytype"));
map.put("pa_auditor", rs.getString("pa_auditor"));
map.put("pa_auditresult", rs.getString("pa_auditresult"));
map.put("prj_serialno", rs.getString("prj_serialno"));
map.put("pc_serialno", rs.getString("pc_serialno"));
map.put("pm_serialno", rs.getString("pm_serialno"));
map.put("pa_audittime", rs.getString("pa_audittime"));
map.put("prj_examinant", rs.getString("prj_examinant"));
}
System.out.println(map);
} catch(ClassNotFoundException e) {
System.out.println("找不到驱动程序类 ,加载驱动失败!");
e.printStackTrace() ;
} catch (SQLException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
}