报错:
java.lang.IllegalStateException: Illegal access: this web application instance has been stopped already. Could not load [java.net.BindException]. The following stack trace is thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access.
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForResourceLoading(WebappClassLoaderBase.java:1311)
at org.apache.catalina.loader.WebappClassLoaderBase.checkStateForClassLoading(WebappClassLoaderBase.java:1299)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1158)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
at com.mysql.jdbc.CommunicationsException.<init>(CommunicationsException.java:155)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2723)
at com.mysql.jdbc.MysqlIO.quit(MysqlIO.java:1401)
at com.mysql.jdbc.Connection.realClose(Connection.java:4882)
at com.mysql.jdbc.Connection.cleanup(Connection.java:2062)
at com.mysql.jdbc.Connection.finalize(Connection.java:3369)
at java.lang.System$2.invokeFinalize(Unknown Source)
at java.lang.ref.Finalizer.runFinalizer(Unknown Source)
at java.lang.ref.Finalizer.access$100(Unknown Source)
at java.lang.ref.Finalizer$FinalizerThread.run(Unknown Source)
之前的源代码:
/* 将需要查看数据封装到user对象里,模糊查询*/
public ArrayList queryuserskey(String key)
{
conn=getconnection();
list=new ArrayList<User>();
try {
pst=conn.prepareStatement("select * from form where username = ?");
pst.setString(1, "%"+key+"%");
rs=pst.executeQuery();
while(rs.next())
{
User user=new User();
user.setID(rs.getInt("id"));
user.setUsername(rs.getString("username"));
user.setPwd1(rs.getString("pwd1"));
user.setPwd2(rs.getString("pwd2"));
user.setSex(rs.getString("sex"));
user.setTelephone(rs.getString("telephone"));
user.setEmail(rs.getString("email"));
list.add(user);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list;
}
需要修改的地方是:SQL语句like与=的应用
pst=conn.prepareStatement("select * from form where username like ?");