sql = "update tour set ";
                sql += "Link_Tel=?,";
                sql += "View_Name=?,";
                sql += "Ticket_express_Service=?,";
                sql += "Line_Area=?,";
                sql += "View_Intro='" + all.getView_Intro() + "',";
                sql += "Service_Item='" + all.getService_Item() + "',";
                sql += "View_Ticket='" + all.getView_Ticket() + "',";
                sql += "View_Kind='" + all.getView_Kind() + "',";
                sql += "Open_Time='" + all.getOpen_Time() + "',";
                sql += "Agency_Grade='" + all.getAgency_Grade() + "',";
                sql += "View_Line='" + all.getView_Line() + "',";
                sql += "Ticket_booking_Service='"
                        + all.getTicket_booking_Service()
                        + "',";
                sql += "View_Grade='" + all.getView_Grade() + "',";
                sql += "View_Facility='" + all.getView_Facility() + "',";