应该不对,字符前要加引号
query = "update Customer_info set Customer_name='"+Str_customer_name+"',Customer_id_type='"+Str_customer_id_type+"',Customer_id_num="+Str_customer_id_num+" where Customer_account='Str_customer_account'";
query = "update Customer_info set Customer_name='"+Str_customer_name+"',Customer_id_type='"+Str_customer_id_type+"',Customer_id_num="+Str_customer_id_num+" where Customer_account='Str_customer_account'";
字符串和SQL语句的连结应该是"sql语句"+string+"sql语句"这种形式才对;
把最后一行改为
Customer_account="+Str_customer_account;
query = "update Customer_info set Customer_name='"+Str_customer_name+"',Customer_id_type='"+Str_customer_id_type+"',Customer_id_num='"+Str_customer_id_num+"' where Customer_account='"+Str_customer_account+"'";
其实最简单的测试方法是在sql的查询工具里面测
的字段进行根新,就要加单引号。
例如:
String sqlStr = "select * from myTabel where name ='" + yourname +"'"