未重新服务器而导致的错误java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is
来源:互联网 发布:药品销售人员软件 编辑:程序博客网 时间:2024/06/05 08:39
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
用struts2,网页的action连接到数据库,使用main开始执行,不报错,但是,通过网页执行报错
数据库是mysql
(后面经过运行,下面的代码是可行的)
Class.forName("com.mysql.jdbc.Driver"); Connection connection=DriverManager.getConnection("jdbc:mysql://localhost","root",""); java.sql.Statement statement=connection.createStatement(); statement.execute("use test"); PreparedStatement preparedStatement=(PreparedStatement) connection.prepareStatement("SELECT * FROM `login` where username=? and password=?"); preparedStatement.setString(1, this.getUsername()); preparedStatement.setString(2, this.getPassword()); ResultSet resultSet=preparedStatement.executeQuery();
解决方案
我使用拼接的方式
String command="SELECT * FROM `login` where username='"+this.getUsername()+"' and password='"+this.getPassword()+"'"; System.out.println(command); ResultSet resultSet=statement.executeQuery(command);
成功了
但是
我真正的原因是,没有重启tomcat
0 0
- 未重新服务器而导致的错误java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is
- java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)
- BIRT出现java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)的问题
- java.sql.SQLException Parameter index out of range (9 > number of parameters, which is 8)
- java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
- Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0
- Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0
- Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1
- 造成原因java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 0).
- Caused by: java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2
- 解决ava.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)类似问题
- mybatis错误Parameter index out of range (1 > number of parameters, which is 0)
- sql异常之Parameter index out of range (1 > number of parameters, which is 0)
- 执行sql的时候为什么会出现Parameter index out of range (1 > number of parameters, which is 0)?
- 关于ibatis的parameter index out of range (1 > number parameters which is 0).异常
- Parameter index out of range (1 > number of parameters, which is 0)
- Java泛型
- [BZOJ1059] [ZJOI2007] 矩阵游戏 - 二分图匹配
- Android之Activity的生命周期
- C++——多次free和delete导致错误
- 字符串函数的实现
- 未重新服务器而导致的错误java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is
- c++第三次实验——作业
- HDU 1062 Text Reverse
- java反射机制
- UVA - 12186 Another Crisis 水树形dp
- JavaScript编写人机对战五子棋(六)
- View 的位置参数
- 进程的基本属性:进程ID、父进程ID、进程组ID、会话和控制终端
- inet_ntoa之坑------再谈不可重入函数中的static