· 8 years ago · Mar 21, 2018, 04:18 PM
1javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
2You have an error in your SQL syntax; check the manual
3that corresponds to your MySQL server version for the
4right syntax to use near ',,,,,,,'yes','yes',,,,'admin')' at line 1
5
6sql="Insert into field_visit_details (visit_date,block,village,flw_category,
7 flw_name,flw_contact_no,aware_zinc,
8aware_ors,past_zinc,past_ors,qty_avail_zinc_ten,qty_avail_zinc_twe,qty_avail_zinc_syr,
9qty_avail_ors,qty_disp_zinc_ten,qty_disp_zinc_twe,qty_disp_zinc_syr,qty_disp_ors,
10stockout_zinc,stockout_ors,diar_cases_seen,diar_cases_reff,diar_deaths_less_than_five,
11added_by)
12 values
13('"+field_visit_date+"','"+block_row_one+"','"+village_row_one+"','"+flw_category_row_one
14+"','"+flw_name_row_one+"','"+flw_contact_no_row_one+"','"+aware_zinc_row_one+"','"+
15aware_ors_row_one+"','"+past_zinc_row_one+"','"+past_ors_row_one+"','"+
16qty_avail_zinc_ten_row_one+"','"+qty_avail_zinc_twe_row_one+"','"+
17qty_avail_zinc_syr_row_one+"','"+qty_avail_ors_row_one+"','"+qty_disp_zinc_ten_row_one
18+"','"+qty_disp_zinc_twe_row_one+"','"+qty_disp_zinc_syr_row_one+"','"+
19qty_disp_ors_row_one+"','"+stockout_zinc_row_one+"','"+stockout_ors_row_one+
20"','"+diar_cases_seen_row_one+"','"+diar_cases_reff_row_one+"','"+diar_deaths_row_one
21+"','"+loginid+"')";
22 System.out.println(sql);
23 int x=stmt.executeUpdate(sql);
24 if(x>0)
25 SUCCESS="admin";
26
27CREATE TABLE IF NOT EXISTS `field_visit_details` (
28`field_visit_id` int(11) NOT NULL auto_increment,
29`visit_date` date NOT NULL,
30`block` varchar(100) NOT NULL,
31`village` varchar(100) NOT NULL,
32`flw_category` varchar(45) NOT NULL,
33`flw_name` varchar(100) NOT NULL,
34`flw_contact_no` varchar(13) NOT NULL,
35`aware_zinc` varchar(10) NOT NULL,
36`aware_ors` varchar(10) NOT NULL,
37`past_zinc` varchar(10) NOT NULL,
38`past_ors` varchar(10) NOT NULL,
39`qty_avail_zinc_ten` int(11) NOT NULL,
40`qty_avail_zinc_twe` int(11) NOT NULL,
41`qty_avail_zinc_syr` int(11) NOT NULL,
42`qty_avail_ors` int(11) NOT NULL,
43`qty_disp_zinc_ten` int(11) NOT NULL,
44`qty_disp_zinc_twe` int(11) NOT NULL,
45`qty_disp_zinc_syr` int(11) NOT NULL,
46`qty_disp_ors` int(11) NOT NULL,
47`stockout_zinc` varchar(11) NOT NULL,
48`stockout_ors` varchar(11) NOT NULL,
49`diar_cases_seen` int(11) NOT NULL,
50`diar_cases_reff` int(11) NOT NULL,
51`diar_deaths_less_than_five` int(11) NOT NULL,
52`added_by` varchar(100) NOT NULL,
53PRIMARY KEY (`field_visit_id`) )
54ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
55
56Insert into field_visit_details (visit_date,block,village,flw_category,flw_name,
57flw_contact_no,aware_zinc,aware_ors,past_zinc,past_ors,qty_avail_zinc_ten,
58qty_avail_zinc_twe,qty_avail_zinc_syr,qty_avail_ors,
59 qty_disp_zinc_ten,qty_disp_zinc_twe,qty_disp_zinc_syr,qty_disp_ors,stockout_zinc,
60 stockout_ors,diar_cases_seen,diar_cases_reff,diar_deaths_less_than_five,added_by)
61 values
62 ('2014-07-02','ASDASD','','asha','asd+','99','yes','yes','yes','yes',
63 '12','12','12','12','12','12','12','12','yes','yes','12','12','12','admin')