From 107623064b162aef3e5d1d734d0763d068a7c4f9 Mon Sep 17 00:00:00 2001
From: 81041 <81041@DESKTOP-025NVD9>
Date: 星期二, 12 十一月 2019 17:37:08 +0800
Subject: [PATCH] 后台第二次提交
---
platforms/android/app/src/main/java/com/sqlite_DaoHelper/DAOHelper.java | 16 +++++++++++-----
1 files changed, 11 insertions(+), 5 deletions(-)
diff --git a/platforms/android/app/src/main/java/com/sqlite_DaoHelper/DAOHelper.java b/platforms/android/app/src/main/java/com/sqlite_DaoHelper/DAOHelper.java
index d49b6a6..314e2cd 100644
--- a/platforms/android/app/src/main/java/com/sqlite_DaoHelper/DAOHelper.java
+++ b/platforms/android/app/src/main/java/com/sqlite_DaoHelper/DAOHelper.java
@@ -27,6 +27,10 @@
public class DAOHelper {
public static SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
public static SimpleDateFormat sdfwithOut=new SimpleDateFormat("yyyy-MM-dd");
+ public static Date getSimpDate(Date time){
+ //System.out.println(time);
+ return new java.sql.Date(time.getTime());
+ }
/**
* 灏佽鎵�鏈夋洿鏂扮殑鎿嶄綔(娣诲姞,鍒犻櫎,淇敼)
* @param conn
@@ -42,6 +46,7 @@
ps = conn.prepareStatement(sql);
if(values != null){
for (int i = 0; i < values.length; i++) {
+ //System.out.println(values[i]);
ps.setObject(i+1, values[i]);
}
}
@@ -70,7 +75,7 @@
public static List executeQuery(String sql,Connection conn,Object[] values,CallBack call){
//System.out.println("閲婃斁涔嬪墠************");
//DBUtil.getConnections();
- System.out.println("connection:"+conn);
+ //System.out.println("connection:"+conn);
PreparedStatement ps = null;
ResultSet rs = null;
try {
@@ -327,15 +332,16 @@
}
public static void main(String[] args) {
- String sql="SELECT * from main.tb_battinf where StationId=? ";
- List list=DAOHelper.executeQuery(sql, DBUtil.getConn(),new Object[]{"4208555"}, new CallBack() {
+ String sql="SELECT * from main.tb_battinf where num=?";
+ List list=DAOHelper.executeQuery(sql, DBUtil.getConn(),new Object[]{6}, new CallBack() {
@Override
public List getResults(ResultSet rs) {
List list=new ArrayList();
try {
while (rs.next()){
- list.add(rs.getString("StationId"));
- list.add(rs.getInt("FBSDeviceId"));
+ list.add(rs.getInt("BattGroupId"));
+ list.add(rs.getFloat("MonSerStd"));
+ list.add(rs.getDate("BattInUseDate"));
}
} catch (SQLException e) {
e.printStackTrace();
--
Gitblit v1.9.1