程序如下:
public Account queryByid(int id) throws SQLException {
Account acc = null;
Connection conn = this.getConnection();
CallableStatement toesUp = conn.prepareCall("{?=call account_GetModel(?)}");
// toesUp.setString(1, account);
toesUp.registerOutParameter(1, Types.OTHER);
toesUp.setInt(2, id);
boolean hasResults = toesUp.execute() ;
if (hasResults) {
ResultSet rs = toesUp.getResultSet();
acc = new Account();
acc.setId(rs.getInt(1));
acc.setUsername(rs.getString(2));
acc.setPwd(rs.getString(3));
acc.setEmail(rs.getString(4));
}
return acc;
}
连接数据库的:
public Connection getConnection(){
final String MYSQL_DRIVER="com.mysql.jdbc.Driver";//
final String MYSQL_USERNAME="root";//
final String MYSQL_PASSWORD="888888";//
final String MYSQL_URL="jdbc:mysql://localhost:3306/wlsla";//
try{
Class.forName(MYSQL_DRIVER);
return DriverManager.getConnection(MYSQL_URL, MYSQL_USERNAME,MYSQL_PASSWORD);
}catch(Exception e){
e.printStackTrace(); }
return null;
}
报错是:
HTTP Status 500 -
org.apache.jasper.JasperException: javax.servlet.ServletException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION wlsla.account_GetModel does not exist
找不到方法? 有什么原因是找不到的~``?
2009年9月09日 09:59