javabean使用有问题 各位大侠帮忙!烦死我了!
ConnectDB
package bbs;
import java.lang.*;
import java.sql.*;
public class ConnectDB {
String url="jdbc:odbc:bbs";
Connection dbConn;
String errMes;
public ConnectDB()
{
errMes="";
dbConn=null;
}
public Connection getConn()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
dbConn=DriverManager.getConnection("jdbc:odbc:bbs","sa","");
}catch(Exception e){
System.out.print(e);
}
return dbConn;
}
public String getErrMes()
{
return errMes;
}
}
package bbs;
import java.lang.*;
import java.sql.*;
public class ExecuteDB extends ConnectDB {
private Connection dbConn;
private Statement stmt;
private ResultSet rs;
private String errMes;
public ExecuteDB() {
dbConn=super.getConn();
stmt=null;
rs=null;
this.errMes=super.getErrMes();
}
public boolean exeSql(String strSql)
{
boolean isSuc=false;
try
{
stmt=dbConn.createStatement();
stmt.executeUpdate(strSql);
stmt.close();
isSuc=true;
}
catch(Exception e)
{
this.errMes=this.errMes+"<br>"+e.toString();
}
return isSuc;
}
public ResultSet exeQuery(String strSql)
{
try
{
stmt=dbConn.createStatement();
rs=stmt.executeQuery(strSql);
}
catch(Exception e)
{
this.errMes=this.errMes+"<br>"+e.toString();
rs=null;
}
return rs;
}
public String getErrMes()
{
return errMes;
}
}
package bbs;
import java.sql.*;
public class User extends ExecuteDB{
private long UserID;
private String UserName;
private String UserPassword;
private String Email;
private String Sex;
private String NickName;
private String CreateTime;
private String Role;
private String strSql;
public User()
{
super();
this.UserID=0;
this.UserName="";
this.UserPassword="";
this.Sex="";
this.NickName="";
this.Role="0";
this.Email="";
java.util.Date NowTime=new java.util.Date();
this.CreateTime=NowTime.toString();
this.strSql="";
}
public void setUserName(String name)
{
this.UserName=name;
}
public void setUserPassword(String password)
{
this.UserPassword=password;
}
public void setSex(String sex)
{
this.Sex=sex;
}
public void setNickName(String nickname)
{
this.NickName=nickname;
}
public void setEmail(String email)
{
this.Email=email;
}
public boolean add()
{
this.strSql="insert into users (UserName,UserPassword,Email,Sex,NickName,CreateTime) ";
this.strSql=" values('"+UserName+"','"+UserPassword+"','"+Email+"','"+Sex+"','"+NickName+"')";
boolean isAdd=super.exeSql(this.strSql);
return isAdd;
}
public boolean modify_info()
{
this.strSql="update users set";
this.strSql=this.strSql+"Email="+"'"+this.Email+"',";
this.strSql=this.strSql+"Sex="+"'"+this.Sex+"',";
this.strSql=this.strSql+"NickName="+"'"+this.NickName+"',";
this.strSql=this.strSql+"Create="+"'"+this.CreateTime+"',";
this.strSql=this.strSql+"where UserID='"+this.UserID+"'";
boolean isUpdate=super.exeSql(this.strSql);
return isUpdate;
}
public boolean modify_UserPassword()
{
this.strSql="update users set";
this.strSql=this.strSql+"UserPassword="+"'"+this.UserPassword+"'";
this.strSql=this.strSql+"where UserID='"+this.UserID+"'";
boolean isUpdateKey=super.exeSql(this.strSql);
return isUpdateKey;
}
public boolean init()
{
this.strSql="select * from 'users' where UserID=";
this.strSql=this.strSql+"'"+this.UserID+"'";
try
{
ResultSet rs=super.exeQuery(this.strSql);
if(rs.next())
{
this.UserID=rs.getLong("UserID");
this.UserName=rs.getString("UserName");
this.UserPassword=rs.getString("UserPassword");
this.Sex=rs.getString("Sex");
this.NickName=rs.getString("NickName");
this.Email=rs.getString("Email");
this.CreateTime=rs.getString("CreateTime");
return true;
}
else
{
return false;
}
}catch(Exception e)
{
System.out.println(e.toString());
return false;
}
}
public boolean valid()
{
this.strSql="select UserID,UserName,Role from 'users'";
this.strSql=this.strSql+" where UserName='"+this.UserName+"'";
this.strSql=this.strSql+" and UserPassword='"+this.UserPassword+"'";
System.out.println(this.strSql);
try
{
ResultSet rs=super.exeQuery(this.strSql);
if(rs.next())
{
this.UserID=rs.getLong("UserID");
this.UserName=rs.getString("UserName");
this.Role=rs.getString("Role");
return true;
}
else
{
return false;
}
}catch(Exception ex)
{
return false;
}
}
public boolean exist()
{
this.strSql="select * from 'users' ";
this.strSql=this.strSql+" where UserName='"+this.UserName+"'";
try
{
ResultSet rs=super.exeQuery(this.strSql);
if(rs.next())
{
return true;
}
else
{
return false;
}
}catch(Exception exe)
{
System.out.println(exe.toString());
return false;
}
}
}
在调用add方法时候出错...
[解决办法]
找不到bbs.User
[解决办法]
<jsp:setProperty name="bean0" property=""/ >
应该改为
<jsp:setProperty name="bean0" property="*"/ >
[解决办法]
有个小错误
this.strSql=" values( '"+UserName+" ', '"+UserPassword+" ', '"+Email+" ', '"+Sex+" ', '"+NickName+" ')";
应该是
this.strSql+=.................吧
[解决办法]
顶,楼上的
[解决办法]
把bean中的属性首字母全改成小写,就搞定了,记得结帖...要不然下次不告诉你了 呵呵
private long UserID;
private String UserName;
private String UserPassword;
private String Email;
private String Sex;
private String NickName;
private String CreateTime;
private String Role;
private String strSql;
[解决办法]
当然是个问题..get/set方法会把你bean属性中的首字母变大写..所以你get不到 当然add不进去了..
结贴.......
[解决办法]
你帖出来的代码不都是大写么?