jsp向mysql中添加记录Invalid character constant
我在做一个jsp页面往mysql里添加数据的例子,有一个总是提示Invalid character constant错误,请懂的朋友帮忙看看是为什么,谢谢
An error occurred at line: 19 in the jsp file: /tjia.jsp
Invalid character constant
16:
17: con=DriverManager.getConnection(uri,"root","java");
18: stmt=con.createStatement();
19: String sql="insert into syan(id,name,sex,year)values(id,"'+name+'","'+sex+'","'+year+'")";
20: rs.executeUpdate(sql);