Mysql中datetime字段读取小数位处理

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();
		} 
	}
}