代码差不多,Connection的两次执行结果为何不同?谢谢!! 你是执行完rs2 = stmt2.executeQuery(strsql2);就立即查询结果的吗? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 当一个statement关闭时,或者重新执行时,或者要从另外有个或多个Result获得数据时,原来的resultset会自动关闭,所以第一个会是空! zhutouzip(Speak out!-shyboy) : 那要避免这种情况得怎么处理呢?只能用连接池的办法吗?谢谢!! 改成PreparedStatement试试,PreparedStatement可以执行多次! 不知我操作是否有误.若改用PreparedStatement,则产生下列错误E:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\test\login_config_jsp.java:61: incompatible typesfound : java.sql.Statementrequired: java.sql.PreparedStatementPreparedStatement stmt2 = conn.createStatement(); ^An error occurred at line: 14 in the jsp file: /test/login_config.jspGenerated servlet error:E:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\test\login_config_jsp.java:62: incompatible typesfound : java.sql.Statementrequired: java.sql.PreparedStatement PreparedStatement stmt = conn.createStatement(); PreparedStatement不是用这种方法啊!用PreparedStatement ps=conn.prepareStatement(); An error occurred at line: 14 in the jsp file: /test/login_config.jsp还是不行,怎么办?Generated servlet error: [javac] Compiling 1 source fileE:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\test\login_config_jsp.java:62: cannot resolve symbolsymbol : method prepareStatement ()location: interface java.sql.Connection PreparedStatement stmt = conn.prepareStatement(); prepareStatement(String sql)这个应该有参数的,详细的你看看文档! 新建了个文件夹,路径不知道变成什么了 java web 登录密码区分大小字问题 windows7配置jdk不好使 谁知道那个跟文本框似的一点就出来日期的那个控件! 404错误,如何解决? 怎样修改IE临时文件夹下的.js文件 一个奇怪的struts问题 求助Struts验证问题 spring 加mybatis 最基本的CURD ,第一次用,不熟悉,,帮帮忙 在form中自定义了一个属性responder="abc",如何在servlet中访问? 一个免费的WebService服务,天气预报、即时股票、IP地址、外汇牌价 jsp中验证输入的问题
若改用PreparedStatement,则产生下列错误E:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\test\login_config_jsp.java:61: incompatible types
found : java.sql.Statement
required: java.sql.PreparedStatement
PreparedStatement stmt2 = conn.createStatement();
^An error occurred at line: 14 in the jsp file: /test/login_config.jspGenerated servlet error:
E:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\test\login_config_jsp.java:62: incompatible types
found : java.sql.Statement
required: java.sql.PreparedStatement
PreparedStatement stmt = conn.createStatement();
用PreparedStatement ps=conn.prepareStatement();
还是不行,怎么办?Generated servlet error:
[javac] Compiling 1 source fileE:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\_\test\login_config_jsp.java:62: cannot resolve symbol
symbol : method prepareStatement ()
location: interface java.sql.Connection
PreparedStatement stmt = conn.prepareStatement();