JSP连接mysql的问题 怎么解决

来源：百度知道 编辑：UC知道 时间：2024/09/28 08:12:51
javax.servlet.ServletException: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.ym1.html.connection_jsp._jspService(org.apache.jsp.ym1.html.connection_jsp:101)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

原因

java.sql.SQLException: No suitable driver
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.ym1.htm

没有加载驱动,

给你一个完整的程序看看
package Bean;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.*;
import Bean.User;

import org.apache.tools.ant.taskdefs.SQLExec.Transaction;

import Bean.MyDialog;

public class ODBCB {
/*public static void main(String[] args){
ODBCB odbcb=new ODBCB("mySQL","Login");

}*/
String url="jdbc:odbc:Login";
Statement sm=null;
String command=null;
ResultSet rs=null;
String cName=null;
String result=null;
Connection con=null;
boolean login=false;
boolean zuce=false;
String tableName=null;
String sqlName=null;
String message=null;
BufferedReader input=new BufferedReader(new InputStreamReader(System.in));
public void fileclose()
{
try {
rs.close();
sm.close();
con.close();
} catch