|
发表于 2014-10-31 17:02:37
|
显示全部楼层
恩 我测试过了 是这样,table返回了就不行了,但是换了个方法,接近了
- public static String querydatetest(){
- java.sql.Connection conn = null;
- java.sql.PreparedStatement pstmt = null;
- java.sql.ResultSet rs = null;
- String sql = null;
- String d = null;
- try {
- conn = com.justep.model.ModelUtils.getConnectionInTransaction("/CNBF/Inventory_Manager/data");
- sql = " SELECT INVENTORY_DATE FROM INVENTORY_DETAIL";
- pstmt = conn.prepareStatement(sql);
- rs = pstmt.executeQuery();
- while(rs.next()){
- d = rs.getDate("INVENTORY_DATE").toString()+rs.getTime("INVENTORY_DATE");
-
- }
- } catch (NamingException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }finally{
- try {
- if (pstmt != null) {
- pstmt.close();
- }
- if (conn != null) {
- conn.close();
- }
- if(rs != null){
- rs.close();
- }
- } catch (SQLException e) {
- throw new RuntimeException(e.getMessage());
- }
- }
- return d;
-
-
- }
- }
复制代码
这样得到的是一个字符串,然后你去前台用js的方法把string转成dateTime 这个可以百度. 你试试吧 |
评分
-
查看全部评分
|