正确代码
// 添加用户的操作
public boolean insert(User user) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
// 获得数据的连接
conn = JDBCUtils.getConnection();
// 获得Statement对象
stmt = conn.createStatement();
// 初始化时间
String create_time=accesstime();
// String create_time="NULL NULL ";
System.out.println("CREATE_TIME0:"+create_time);
//初始化参数
String CREATE_TIME_real=create_time;
System.out.println("CREATE_TIME1:"+CREATE_TIME_real);
String STARTTIME_real=create_time;
String ENDTIME_real=create_time;
String SITE_real="0";
String PAREA_real="0";
String LINE_real="0";
String OP_real="0";
String EQP_ID_real="0";
String UNIT_ID_real="0";
String PORT_ID_real="0";
String LOT_NO_real="0";
String MODEL_NO_real="0";
String PART_NO_real="0";
String PARAMETER_real="0";
String PARAMETER_DESC_real="0";
String PARAMVALUE_real="0";
String IS_CONFIG_DATA_real="N";
String IS_REAL_DATA_real="Y";
// 发送SQL语句
// String sql = "INSERT INTO s02 (CREATE_TIME,STARTTIME,ENDTIME,SITE,PAREA,LINE,OP,EQP_ID,UNIT_ID,PORT_ID, LOT_NO, MODEL_NO,PART_NO,PARAMETER,PARAMETER_DESC,PARAMVALUE,IS_CONFIG_DATA,IS_REAL_DATA)"+ " VALUES(" + CREATE_TIME_real+"," +STARTTIME_real,ENDTIME_real,SITE_real+ "," + PAREA_real,LINE_real,OP_real,EQP_ID_real,UNIT_ID_real,PORT_ID_real, LOT_NO_real,MODEL_NO_real,PART_NO_real,PARAMETER_real + "," +PARAMETER_DESC_real,PARAMVALUE_real + ","+ IS_CONFIG_DATA_real,IS_REAL_DATA_real + ")";
String sql = "insert into s02 values ("+"\'"+CREATE_TIME_real+"\'"+","+"\'"+STARTTIME_real+"\'"+","+"\'"+ ENDTIME_real+"\'"+","+SITE_real+","+PAREA_real+","+LINE_real+","+OP_real+","+EQP_ID_real+","+UNIT_ID_real+","+PORT_ID_real+","+LOT_NO_real+","+MODEL_NO_real+","+PART_NO_real+","+PARAMETER_real+","+PARAMETER_DESC_real+","+PARAMVALUE_real+","+"\'"+IS_CONFIG_DATA_real+"\'"+","+"\'"+IS_REAL_DATA_real+"\'"+")";
System.out.println("sql:"+sql);
boolean num=stmt.execute(sql);
System.out.println("num:"+num);
// stmt.executeUpdate(sql);
// int num = stmt.executeUpdate(sql);
// if (num > 0) {
// return true;
// }
// return false;
} catch (Exception e) {
e.printStackTrace();
} finally {
JDBCUtils.release(rs, stmt, conn);
}
return false;
}
错误代码
// 发送SQL语句
// String sql = "INSERT INTO s02 (CREATE_TIME,STARTTIME,ENDTIME,SITE,PAREA,LINE,OP,EQP_ID,UNIT_ID,PORT_ID, LOT_NO, MODEL_NO,PART_NO,PARAMETER,PARAMETER_DESC,PARAMVALUE,IS_CONFIG_DATA,IS_REAL_DATA)"+ " VALUES(" + CREATE_TIME_real+"," +STARTTIME_real,ENDTIME_real,SITE_real+ "," + PAREA_real,LINE_real,OP_real,EQP_ID_real,UNIT_ID_real,PORT_ID_real, LOT_NO_real,MODEL_NO_real,PART_NO_real,PARAMETER_real + "," +PARAMETER_DESC_real,PARAMVALUE_real + ","+ IS_CONFIG_DATA_real,IS_REAL_DATA_real + ")";
总结
Java的字符串需要用引号。
花了2天时间,才解决这个问题,不得不承认自身没有系统化的学习Java,容易在一些细节上卡住。