mysql出现No value specified for parameter1?
时间:2011-09-15
来源:互联网
就是在jsp中页面中把从上个页面获得的数据写入mysql数据库,数据能写入数据库,但tomcat却给出错误信息:No value specified for parameter1。有哪位高手遇见过,给解释下,最好给出解决方法,谢谢啦。我的代码如下:
String ac = request.getParameter("account");
String pa = request.getParameter("password");
int dataID=0;
boolean regstate=false;
Connection conn = null;
PreparedStatement ps = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/userdata?user=root&password=429300";
conn = DriverManager.getConnection(url);
String sqlString = "insert into users (id,account,password) values (?,?,?)";
ps = conn.prepareStatement(sqlString);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from chart");
while(rs.next()){dataID++;}
out.println(dataID);
stmt.executeUpdate("insert into chart values('"+(dataID+1)+"','"+ac+"',"+pa+");");
if (ps.executeUpdate() > 0)
regstate=true;
} catch (Exception e) {
// TODO: handle exception
System.out.println("插入失败");
e.printStackTrace();
} finally {
try {
if (ps != null) {
ps.close();
ps = null;
}
if (conn != null) {
conn.close();
conn = null;
}
} catch (Exception e2) {
e2.printStackTrace();
// TODO: handle exception
}
}
String ac = request.getParameter("account");
String pa = request.getParameter("password");
int dataID=0;
boolean regstate=false;
Connection conn = null;
PreparedStatement ps = null;
try {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost/userdata?user=root&password=429300";
conn = DriverManager.getConnection(url);
String sqlString = "insert into users (id,account,password) values (?,?,?)";
ps = conn.prepareStatement(sqlString);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from chart");
while(rs.next()){dataID++;}
out.println(dataID);
stmt.executeUpdate("insert into chart values('"+(dataID+1)+"','"+ac+"',"+pa+");");
if (ps.executeUpdate() > 0)
regstate=true;
} catch (Exception e) {
// TODO: handle exception
System.out.println("插入失败");
e.printStackTrace();
} finally {
try {
if (ps != null) {
ps.close();
ps = null;
}
if (conn != null) {
conn.close();
conn = null;
}
} catch (Exception e2) {
e2.printStackTrace();
// TODO: handle exception
}
}
作者: Programmer_xxx 发布时间: 2011-09-15
数据库表未与程序对应,仔细检查。
作者: leecyz 发布时间: 2011-09-15
对应了啊,哪儿没对应啊?
作者: Programmer_xxx 发布时间: 2011-09-15
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28