应该不对,字符前要加引号
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'";
解决方案 »
- 问一个关于字符串截取的简单问题
- Java中怎么把字符串数组转为整形数组
- 关于object建立的对象
- 界面问题请教,新手初学,望指教,谢谢
- java web start 启动程序时,如何识别相关jar包已更新?换句话,我们打jar包时,应做什么工作?
- Java调用Linux下的top命令的问题?
- JList 水平滚动条没出现
- ◆菜鸟提问了!关于Servlet的一个很简单的问题。◆
- 请推荐一个写java程序的编译环境……
- java.net.BindException: Permission denied
- 如何关闭一个JApplet???急!!!请大家看看呀!!!
- 初学java应该用什么开发工具较好?
字符串和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 +"'"