糖尿病康复 > linux jsp连接mysql_linux下jsp连接mysql出现无法在入mysql连接文件的问题？？？

linux jsp连接mysql_linux下jsp连接mysql出现无法在入mysql连接文件的问题？？？

时间：2020-11-19 13:02:20

.bash_profile文件为

PATH=$PATH:$HOME/bin:/yin/tomcat311/bin:/yin/apache132/bin:/yin/mysql/bin/:/yin/jdk122/lib:

BASH_ENV=$HOME/.bashrc

USERNAME="root"

export USERNAME BASH_ENV PATH

JAVA_HOME=/yin/jdk122

PATH=$PATH:$JAVA_HOME/bin

CLASSPATH=/yin/jdk122/lib/tools.jar:/yin/jdk122/lib/:

export JAVA_HOME

export PATH CALSSPATH

我将mysql的jdbc连接文件(org.gjt.mm.mysql目录)解压后拷贝到/yin/jdk122/lib下

我的jsp程序是：

Connection Conn;

Statement Stmt;

ResultSet Rst;

try

{

Class.forName("org.gjt.mm.mysql.Driver").newInstance();

}

catch(ClassNotFoundException e)

{

out.print("数据库连接文件没有找到，请正确配置classpath参数！！！

");

out.print(e);

}

String url="jdbc:mysql://10.110.1.88/longte?user=root&password=123456&useUnicode=true&characterEncoding=8859_1";

Conn=DriverManager.getConnection(url);

Stmt=Conn.createStatement();

执行显示：

Error: 500

Location: /data.jsp

Internal Servlet Error:

javax.servlet.ServletException: No suitable driver

at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:386)

at _0002fdata_0002ejspdata_jsp_3._jspService(_0002fdata_0002ejspdata_jsp_3.java:113)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.jasper.runtime.JspServlet$JspServletWrapper.service(JspServlet.java:174)

at org.apache.jasper.runtime.JspServlet.serviceJspFile(JspServlet.java:261)

at org.apache.jasper.runtime.JspServlet.service(JspServlet.java:369)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)

at org.apache.tomcat.core.ServletWrapper.handleRequest(ServletWrapper.java:503)

at org.apache.tomcat.core.ContextManager.service(ContextManager.java:559)

at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:160)

at org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java:338)

at java.lang.Thread.run(Thread.java:472)

Root cause:

java.sql.SQLException: No suitable driver

at java.sql.DriverManager.getConnection(DriverManager.java:470)

at java.sql.DriverManager.getConnection(DriverManager.java:152)

at _0002fdata_0002ejspdata_jsp_3._jspService(_0002fdata_0002ejspdata_jsp_3.java:101)