当前页面: 开发资料首页 → JSP 专题 → 高手进！！此题已困多时！！！帮忙啊！

高手进！！此题已困多时！！！帮忙啊！

摘要: 高手进！！此题已困多时！！！帮忙啊！

我做了一个javabean的程序。谁知在编译过程中出现了很多错误，经过不断的更改总算错误大大的减少但还存在一个错误：
E:/>javac W:/business/WEB-INF/classes/org/pan/web/baiwan.java
W:/business/WEB-INF/classes/org/pan/web/baiwan.java:125: incompatible types
found : boolean
required: java.sql.ResultSet
rs=stmt.execute(sqlStr);
^
1 error
我的一部分程序是：
package org.pan.web;

import java.sql.*;
import org.pan.util.*;
import javax.servlet.http.HttpServletRequest;
import java.sql.ResultSet;
public class baiwan {
private String UserName1;
private String Password1;
private String UserName2;
private String Password2;
private boolean IsTimeUp=false;
private String IsRight="no";
private javax.servlet.http.HttpServletRequest Request;
private int BookId;
private String BookName;
private String BookContent;
private float Price;
private String SubmitTime;
private String CheckTime;
private String Email;
private String IsPayOff;
String mysqldriver="org.gjt.mm.mysql.Driver";
String url="jdbc:mysql://localhost:3306/business?user=wyn63559956;password=19861004";
Connection con;
Statement stmt;
ResultSet rs;


public baiwan() throws Exception{

try{
Class.forName(mysqldriver);
con=DriverManager.getConnection(url,"","");
stmt=con.createStatement();
}
catch(Exception e)
{
System.out.println(e);
}
UserName1="";
Password1="";
UserName2="";
Password2="";
SubmitTime="";
BookId=0;
BookName="";
BookContent="";
Price=0;
SubmitTime="";
CheckTime="";
Email="";
}

public String getUserName1() throws Exception{ //这是用户的函数
return UserName1;
}
public void setUsername1(String newusername) {
UserName1 = newusername;
}

public String getPassword1() throws Exception{
return Password1;
}
public void setPassword1(String newpasswd) {
Password1 = newpasswd;
}
public String getUserName2() {
return UserName2;
}
public void setUserName2(String newusername){
UserName2=newusername;
}
public String getPassword2() {
return Password2;
}
public void setPassword2(String newpasswd){
Password2=newpasswd;
}
public String getSubmitTime() {
return SubmitTime;
}
public String getIsRight() throws Exception{
return IsRight;
}
public String getSql1(){
String sqlStr="select * from baiwanhezi where UserName1='"+getUserName1()+ " 'and Password1='"+getPassword1()+" '";
return sqlStr;
}
public boolean checkUser1() throws Exception{
boolean flag=false;
rs=stmt.executeQuery(getSql1());
if(rs.next())
flag=true;
rs.close();
return flag;
}
public String getSql2(){
String sqlStr="select * from My_Users where UserName='"+getUserName2()+ " 'and PassWord='"+getPassword2()+" '";
return sqlStr;
}
public boolean checkUser2() throws Exception{
boolean flag=false;
rs=stmt.executeQuery(getSql2());
if(rs.next())
flag=true;
rs.close();
return flag;
}

public boolean haveRight() throws Exception {

String sqlStr;
boolean flag=false;
try
{
sqlStr = "update baiwanhezi set";
sqlStr = sqlStr + "UserName1 = '" + getUserName2() + "',";
sqlStr = sqlStr + "Password1 = '" + getPassword2() + "',";
sqlStr = sqlStr + "SubmitTime = '" + getSubmitTime() + "'";
rs=stmt.execute(sqlStr);
}
catch(SQLException e)
{
System.out.println(e);
return flag;
}
sqlStr = "delete UserName2,Password2 from baiwanhezi";
try
{
stmt.execute(sqlStr);
}
catch(SQLException e)
{
System.out.println(e);
rs.close();
return flag;
}
rs.close();
flag=true;
return flag;
}
请各位指教！！！

---

stmt.execute(sqlStr);返回的是boolean，不是java.sql.ResultSet
可以用rs = stmt.executeQuery(sqlStr);

---

incompatible types
found : boolean
required: java.sql.ResultSet

---

很明显的错误，楼上两位都已经说了
rs=stmt.execute(sqlStr);改为stmt.executeUpdate(sqlStr);
另外考虑到效率问题，sql文最好用StringBuffer

---

sql语句为何用StringBuffer 好一点呢？！

---

String 的修改(如+)都会重新生成一个新的String再赋值同名变量.
而StringBuffer则能在后面直接添加.

---

mark

---