java.sql.SQLException: Invalid parameter binding(s).是什么错误啊? java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter binding(s). 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 参数不匹配。http://topic.csdn.net/u/20070613/11/ee52daa9-d8fe-4f6c-9b14-8223531d9f3b.html参看这个帖子,看是否问题相似。如果不相似。贴出你的查询代码。 无效的参数绑定,估计是你JDBC的URL连接参数有错误,仔细检查检查 我是在向数据库写入数据时报这个错~代码是这样的public int addUser(String username,String password,String permission,String name,String photo,String sexy) throws Exception { connect=new DBConnection(); String sql1="select Username from Users where Username='"+username+"'"; rs=connect.getQueryResultSet(sql1, username); if(rs.next()) { return 0; } else { String sql="insert into Users(Username,Password,Permission,Name,Photo,Sexy) values('"; sql+=username+"','"+password+"','"+permission+"','"+name+"','"+photo+"','"+sexy+"')"; int count=connect.getUpdateCount(sql); return count; } }public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=utf-8;"); String username=request.getParameter("username"); String password=request.getParameter("password"); String permission=request.getParameter("Permission"); String name=request.getParameter("name"); String sexy=request.getParameter("sexy"); String photo=request.getParameter("photo"); if(username==""||password==""||permission==""||name==""||sexy=="") { request.setAttribute("flag", "请将信息填写完整!"); RequestDispatcher requestDis = request.getRequestDispatcher("admin/userAdd.jsp"); requestDis.forward(request, response); } else { try { usermanage user=new usermanageImpl(); int count=user.addUser(username, password, permission, name, photo, sexy); if(count==1) { int choose=JOptionPane.showConfirmDialog(null, "添加成功,是否继续上传","消息框",JOptionPane.YES_NO_OPTION); if(choose==0) { response.sendRedirect("admin/userAdd.jsp"); } else { response.sendRedirect("admin/right_default.jsp"); } } else if(count==0) { request.setAttribute("flag", "用户名已经存在!"); RequestDispatcher requestDis = request.getRequestDispatcher("admin/userAdd.jsp"); requestDis.forward(request, response); } }catch (Exception e) { e.printStackTrace(); } } } 无效的参数绑定,估计是这出的问题String sql="insert into Users(Username,Password,Permission,Name,Photo,Sexy) values('"; sql+=username+"','"+password+"','"+permission+"','"+name+"','"+photo+"','"+sexy+"')"; int count=connect.getUpdateCount(sql); return count; 数学的魅力,用程序实现 如何去掉javawebstart启动程序时的安全告警 请教各位大侠:ACCESS数据库里的排序语句是什么? 关于项目引领 请问我的笔记本是酷睿双核的,下载了几个J2SE的平台都不能用,有哪位高手能帮忙解决吗? 在jScrollPane上添加删除jPanel 这个网站的JAVA电子书不错,速度快的,免费的,还更新了 请问各位对中间件有研究的高手 Weblogic6.0+JBuild5.0整合后,JB如何启动Weblogic? 关于继承和覆盖的问题 关于java用hibernate调用数据库的问题。 用java解析sql语句
http://topic.csdn.net/u/20070613/11/ee52daa9-d8fe-4f6c-9b14-8223531d9f3b.html
参看这个帖子,看是否问题相似。如果不相似。贴出你的查询代码。
{
connect=new DBConnection();
String sql1="select Username from Users where Username='"+username+"'";
rs=connect.getQueryResultSet(sql1, username);
if(rs.next())
{
return 0;
}
else
{
String sql="insert into Users(Username,Password,Permission,Name,Photo,Sexy) values('";
sql+=username+"','"+password+"','"+permission+"','"+name+"','"+photo+"','"+sexy+"')";
int count=connect.getUpdateCount(sql);
return count;
}
}public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8;");
String username=request.getParameter("username");
String password=request.getParameter("password");
String permission=request.getParameter("Permission");
String name=request.getParameter("name");
String sexy=request.getParameter("sexy");
String photo=request.getParameter("photo");
if(username==""||password==""||permission==""||name==""||sexy=="")
{
request.setAttribute("flag", "请将信息填写完整!");
RequestDispatcher requestDis = request.getRequestDispatcher("admin/userAdd.jsp");
requestDis.forward(request, response);
}
else
{
try
{
usermanage user=new usermanageImpl();
int count=user.addUser(username, password, permission, name, photo, sexy);
if(count==1)
{
int choose=JOptionPane.showConfirmDialog(null, "添加成功,是否继续上传","消息框",JOptionPane.YES_NO_OPTION);
if(choose==0)
{
response.sendRedirect("admin/userAdd.jsp");
}
else
{
response.sendRedirect("admin/right_default.jsp");
}
}
else if(count==0)
{
request.setAttribute("flag", "用户名已经存在!");
RequestDispatcher requestDis = request.getRequestDispatcher("admin/userAdd.jsp");
requestDis.forward(request, response);
}
}catch (Exception e) {
e.printStackTrace();
}
}
}
无效的参数绑定,估计是这出的问题
String sql="insert into Users(Username,Password,Permission,Name,Photo,Sexy) values('";
sql+=username+"','"+password+"','"+permission+"','"+name+"','"+photo+"','"+sexy+"')";
int count=connect.getUpdateCount(sql);
return count;