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+")";
		
	}
	
}