有如下一段代码。。public User check(String name,String pwd){
Connection conn=null;
conn=DataBaseConnection.getConnection();
PreparedStatement pstmt=null;
ResultSet rs=null;
User user=null;
String sql="select name,pwd from account where name=?,pwd=?";
try {
pstmt=conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, pwd);
rs=pstmt.executeQuery();//这个是第34行。。
if(rs.next()){
user.setName(rs.getString(1));
user.setPwd(rs.getString(2));
}
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return user;
}当我测试的时候,总是报这个异常
java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:622)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:180)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:419)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:895)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:451)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:985)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2887)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2928)
at sml.User.check(User.java:34)
at sml.Txt.main(Txt.java:9)哪位大神指导一下啊
Connection conn=null;
conn=DataBaseConnection.getConnection();
PreparedStatement pstmt=null;
ResultSet rs=null;
User user=null;
String sql="select name,pwd from account where name=?,pwd=?";
try {
pstmt=conn.prepareStatement(sql);
pstmt.setString(1, name);
pstmt.setString(2, pwd);
rs=pstmt.executeQuery();//这个是第34行。。
if(rs.next()){
user.setName(rs.getString(1));
user.setPwd(rs.getString(2));
}
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return user;
}当我测试的时候,总是报这个异常
java.sql.SQLException: ORA-00933: SQL command not properly ended at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:622)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:180)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:419)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:895)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:451)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:985)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2887)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2928)
at sml.User.check(User.java:34)
at sml.Txt.main(Txt.java:9)哪位大神指导一下啊
解决方案 »
- 求教熟悉quartz的朋友。
- Spring启动错误
- 关于更新数据库中数据出现的问题,高手指教!
- 为什么我用request.getAttribute()页面就报错
- 提问:关于JAVAMAIL发送时提示不能连接SMTP服务器的问题
- 想把相册的图片加到一个地方~但由于字数限制~求可以把那个地址可以减少字数的方法?
- 关于在form表单中加入enctype="multipart/form-data"属性乱码的问题
- 学struts这么久了,不懂ActionErrors的add方法中那个property有什么用?
- JSP 应用
- 数据库关闭问题!!!!!!!!!!!!!!!
- struts2标签问题
- jsp注册求助~!
如果你是想要查询name等于什么或者pwd等于什么的话就用or"select name,pwd from account where name=? or pwd=?";不是用,号隔开!