수다닷컴

MYsql을 이용하려고 합니다.

그래서 소스는 다음과 같이 만들어 주었습니다.
package model;
import java.sql.*;
public class ConnectionManager {

//직접적인 연결 생성
public static Connection getConnection() {
Connection conn = null;
try {
//JDBC 드라이버 객체 생성
Class.forName(org.git.mm.mysql.Driver);
//DBMS와 연결하기
conn = DriverManager.getConnection(
jdbc:mysql://127.0.0.1:3306/woodi,
root, mers4u

);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}

}
제 컴퓨터에서 mysqld.exe 을 실행 시켰구요

mysql-connector-java-2[1].0.14-bin-sungback.jar 파일을 /WEB-INF/lib에 복사했습닌다.

그리고 제가 이클립스를 사용하고 있어서. project - properties - java Build Path 에서 Order and Export에 추가해주고 체크 했습니다.

일단 컴파일이 되고 있을 때 다음과 같은 메시지가 나타 납니다.

[DevLoader] Starting DevLoader
[DevLoader] projectdir=E:\JAVA\work\wood-i\web
[DevLoader] added file:/E:/JAVA/work/wood-i/web/WEB-INF/lib/mysql-connector-java-2[1].0.14-bin-sungback.jar
[DevLoader] JSPCompiler Classpath = E:\JAVA\work\wood-i\web\WEB-INF\lib\mysql-connector-java-2[1].0.14-bin-sungback.jar;E:/JAVA/work/wood-i/web/WEB-INF/classes/;E:/JAVA/work/wood-i/web/WEB-INF/lib/jaxen-full.jar;E:/JAVA/work/wood-i/web/WEB-INF/lib/jdbc2_0-stdext.jar;E:/JAVA/work/wood-i/web/WEB-INF/lib/jstl.jar;E:/JAVA/work/wood-i/web/WEB-INF/lib/mysql-connector-java-2[1].0.14-bin-sungback.jar;E:/JAVA/work/wood-i/web/WEB-INF/lib/saxpath.jar;E:/JAVA/work/wood-i/web/WEB-INF/lib/standard.jar;E:/JAVA/work/wood-i/web/WEB-INF/lib/xalan.jar;E:/JAVA/work/wood-i/web/WEB-INF/lib/xercesImpl.jar;E:/JAVA/work/wood-i/web/WEB-INF/lib/xml-apis.jar;E:/JAVA/tomcat%205.5/bin/bootstrap.jar;C:/Program%20Files/Java/jdk1.5.0_06/lib/tools.jar;C:/Program%20Files/Java/jdk1.5.0_06/jre/lib/ext/dnsns.jar;C:/Program%20Files/Java/jdk1.5.0_06/jre/lib/ext/localedata.jar;C:/Program%20Files/Java/jdk1.5.0_06/jre/lib/ext/sunjce_provider.jar;C:/Program%20Files/Java/jdk1.5.0_06/jre/lib/ext/sunpkcs11.jar;
2006. 5. 12 오후 3:30:52 org.apache.catalina.core.ApplicationContext log
정보: Marking servlet jsp as unavailable
2006. 5. 12 오후 3:30:52 org.apache.catalina.core.ApplicationContext log
심각: Error loading WebappClassLoader
delegate: false
repositories:
/WEB-INF/classes/
---------- Parent Classloader:
sun.misc.Launcher$AppClassLoader@82ba41
org.apache.jasper.servlet.JspServlet
java.lang.ClassNotFoundException: org.apache.jasper.servlet.JspServlet - 여기 에러가 왜 나는 지 모르겠습니다.
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1352)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1034)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3917)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4201)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at org.apache.catalina.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
2006. 5. 12 오후 3:30:52 org.apache.catalina.core.StandardContext loadOnStartup
심각: Servlet threw load() exception
java.lang.ClassNotFoundException: org.apache.jasper.servlet.JspServlet - 여기 에러가 왜 나는 지 모르겠습니다.
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1352)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1034)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3917)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4201)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at org.apache.catalina.core.Sa.core.StandardService.start(StandardService.java:450)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
2006. 5. 12 오후 3:30:52 org.apache.commons.modeler.Registry registerComponent
심각: Null component Catalina:type=JspMonitor,name=jsp,WebModule=//localhost/,J2EEApplication=none,J2EEServer=none
2006. 5. 12 오후 3:30:53 org.apache.coyote.http11.Http11BaseProtocol start
정보: Starting Coyote HTTP/1.1 on http-8080
2006. 5. 12 오후 3:30:53 org.apache.jk.common.ChannelSocket init
정보: JK: ajp13 listening on /0.0.0.0:8009
2006. 5. 12 오후 3:30:53 org.apache.jk.server.JkMain start
정보: Jk running ID=0 time=0/172 config=null
2006. 5. 12 오후 3:30:53 org.apache.catalina.startup.Catalina start
정보: Server startup in 5438 ms
일단 index.jsp 파일을 열리는데 거기서 로그인을 하려고 만든 버튼을 누르면 다음과 같이 나오네요...

그리고 다음은 로그인 버튼 누르면 mysql에 접속해야 하는 부분에서 에러가 나는 것 같은데요 ...
description The server encountered an internal error () that prevented it from fulfilling this request.

exception javax.servlet.ServletException: Error allocating a servlet instance
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:595)
root cause java.lang.NoClassDefFoundError: javax/servlet/http/HttpServlet
java.lang.ClassLoader.defineClass1(Native Method)
java.lang.ClassLoader.defineClass(ClassLoader.java:620)
java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)
org.apache.catalina.loader.WebappClassLoader.findClassInternal(WebappClassLoader.java:1812)
org.apache.catalina.loader.WebappClassLoader.findClass(WebappClassLoader.java:866)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1319)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:595)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.17 logs.

초보자에게 피가 되고 살이 되는 도움 주시면 감사하겠습니다.^^;;

신청하기