小弟今天在写sql语句时遇到一个问题,总觉得下面写的不对
String sqltxt = "insert into t_role_right values("
+ roleNo + ","
+ "'" + roleName + "',"
+ "'" + roleDesc + "')";/**上面roleNo是int型,roleName和roleDesc是String型 */大家帮我改改吧,谢谢!
String sqltxt = "insert into t_role_right values("
+ roleNo + ","
+ "'" + roleName + "',"
+ "'" + roleDesc + "')";/**上面roleNo是int型,roleName和roleDesc是String型 */大家帮我改改吧,谢谢!
PreparedStatement pst = conn.preparedStatement(sql);
pst.setInt(1, roleNo );
pst.setString(2, roleName );
pst.setString(3,roleDesc);pst.executeUpdate() ;
values (20060207,'2006年02月07日',200602,'2006年02月',2006,'2006年')
roleNo两边用+对吗?我就这点搞不清楚