1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
| package com.thread.devs;
|
| import com.mode.Motor_State;
| import com.sql.MysqlConnPool;
| import com.sql.Sql_Mysql;
|
| public class Manage_Simul_Motor_Thread_SQL {
|
| public static void insertMotor_State_Table(MysqlConnPool pool,Motor_State state) {
| String sql_str = " SELECT device_id FROM "+Sql_Mysql.Tb_Motor_State_Table+" WHERE device_id = " + state.device_id;
| String sql_str_ins = " INSERT INTO " + Sql_Mysql.Tb_Motor_State_Table +
| "(device_id,record_time,motor_curr,motor_power,motor_speed,motor_vol,motor_out_tmp,motor_into_tmp,motor_torque,motor_state) " +
| "VALUES("+state.device_id+",'"+state.record_time+"',"+state.motor_curr+","+state.motor_power+","+state.motor_speed+","+state.motor_vol+","+state.motor_out_tmp+","+state.motor_into_tmp+","+state.motor_torque+","+state.motor_state+")";
|
| }
|
| }
|
|
