捣腾了很久。我用的是mysql5,连接数据的jar包是mysql-connector-java-5.0.7.jar
最近自学servlet时,看视频说要导入三个包到tomcat的lib目录下,需要的另外两个包是什么呢?
aspectjtools-1.5.3.jar+mysql-connector-java-5.0.7-bin-g.jar
我试了一下。不行,控制台出现一大堆trace。。求大神指教。。不想倒在起跑路上。。谢谢解答。。
最近自学servlet时,看视频说要导入三个包到tomcat的lib目录下,需要的另外两个包是什么呢?
aspectjtools-1.5.3.jar+mysql-connector-java-5.0.7-bin-g.jar
我试了一下。不行,控制台出现一大堆trace。。求大神指教。。不想倒在起跑路上。。谢谢解答。。
解决方案 »
- 帮忙推荐下产品加密的技术
- 利用jacob将Word转成PDF时候报错:Invoke of: SaveAs
- tomcat 启动时报这个错 请高手帮忙
- Hibernate在one-to-many关系中如何实现在删除ONE的时候自动删除MANY
- 关于AJAX+HIBERNATE的问题
- 为什么我用的hibernate里居然session.getTransaction() 没这个方法
- 高手留步,hibernate中idbag出现的问题!!!
- 送70分;求助?求助?求助?求助?求助?求助?求助?急!急!急!急!急!急!急
- 一个很简单的问题?急!
- Java web 如何改变上传文件的大小?
- Java 按照成绩给考试人员名次 排序
- eclipse 中的问题
拷什么jar 包额。
严重: Servlet.service() for servlet logincheck threw exception
java.lang.ClassNotFoundException: org.aspectj.lang.Signature
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:423)
at java.lang.ClassLoader.loadClass(ClassLoader.java:356)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:186)
at com.gcj.logincheck.doGet(logincheck.java:91)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:722)
try {
System.out.println("ddddd");
String u=request.getParameter("username");
String p=request.getParameter("passwd");
//连接数据库
Class.forName("com.mysql.jdbc.Driver");
//得到连接
ct=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/dblogin","root","123456");
//创建statement
sm=((java.sql.Connection) ct).createStatement();
rs=sm.executeQuery("select *from user where uname='"+u+"' and upass='"+p+"'");
//验证
// System.out.println("bbbb");
//session的生命周期只有三十分钟(用户发呆时间)
if (rs.next()) {
System.out.println("bbbb");
//合法
//将验证成功的信息写入session
//得到session
HttpSession hs=request.getSession(true);
//修改session的存在时间,默认半小时发呆时间
hs.setMaxInactiveInterval(20);//秒计算
hs.setAttribute("pass", u);
//跳转到wel
response.sendRedirect("wel?uname="+u+"&psd="+p);
} else {
//不合法
//跳转
response.sendRedirect("login");//写servlet的url,切记;
}
} catch (Exception e) {
e.printStackTrace();
}finally{
try {
if (rs!=null){
sm.close();}
if(ct!=null){
ct.close();}
if(rs!=null){
rs.close();}
}
catch (Exception e2) {
e2.printStackTrace();
}
}
} 上面是我的程序代码
root cause java.lang.NoClassDefFoundError: org/aspectj/lang/Signature
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:186)
com.gcj.logincheck.doGet(logincheck.java:91)
javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause java.lang.ClassNotFoundException: org.aspectj.lang.Signature
java.net.URLClassLoader$1.run(URLClassLoader.java:366)
java.net.URLClassLoader$1.run(URLClassLoader.java:355)
java.security.AccessController.doPrivileged(Native Method)
java.net.URLClassLoader.findClass(URLClassLoader.java:354)
java.lang.ClassLoader.loadClass(ClassLoader.java:423)
java.lang.ClassLoader.loadClass(ClassLoader.java:356)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:186)
com.gcj.logincheck.doGet(logincheck.java:91)
javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs.
[code=/Java]
java.lang.ClassCastException: com.mysql.jdbc.Connection cannot be cast to com.sun.corba.se.pept.transport.Connection
at com.gcj.logincheck.doGet(logincheck.java:93)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:875)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:722)[/code]
ct 这个对象 , 你把它改成java.sql.Connection
Statement sm=null;
java.sql.Connection ct=null;
ResultSet rs=null;
try {
System.out.println("ddddd");
String u=request.getParameter("username");
String p=request.getParameter("passwd");
//连接数据库
Class.forName("com.mysql.jdbc.Driver");
//得到连接
ct= DriverManager.getConnection("jdbc:mysql://localhost:3306/dblogin","root","123456");
//创建statement
sm=ct.createStatement();
rs=sm.executeQuery("select *from user where uname='"+u+"' and upass='"+p+"'");
import java.sql.Connection ;
import java.sql.*;import javax.sql.DataSource;public class Database {
public static Connection cn=null;
public static Statement st=null;
public static ResultSet rs=null; public static boolean joinDB() {
boolean joinFlag;
try {
joinFlag = true; Class.forName("com.microsoft.jdbc.sqlsever.SQLSeverDriver"); String url="jdbc:microsoft:sqlsever://localhost:1433;Database=EmployeeInformationMS";
String user="sa";
String password="";
Connection cn= DriverManager.getConnection(url,user,password);
cn.setCatalog("EmployeeInformationMS");
System.out.println("数据库连接成功");
st = cn.createStatement();
return joinFlag; } catch (SQLException sqlEx) {
System.out.println(sqlEx.getMessage()); joinFlag = false;
return joinFlag; } catch (ClassNotFoundException notfoundEX) {
System.out.println(notfoundEX.getMessage()); joinFlag = false;
return joinFlag;
}
} public static boolean executeSQL(String sqlString) {
boolean executeFlag;
try {
st.execute(sqlString);
executeFlag = true;
} catch (Exception e) {
executeFlag = false;
System.out.println("sql exception:" + e.getMessage());
}
return executeFlag;
}
public static boolean query(String sqlString) { try {
rs = null; rs = st.executeQuery(sqlString);
} catch (Exception Ex) {
System.out.println("sql exception:" + Ex);
return false;
}
return true;
}
}