Servlet连接Mysql报错ClassNotFoundException
MySQL的驱动程序要放在webcontent/web-inf/lib路径下,并且右键点击构建路径。
package yzu;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class DataBaseServlet02
*/
@WebServlet("/DataBaseServlet02")
public class DataBaseServlet02 extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public DataBaseServlet02() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
// response.getWriter().append("Served at: ").append(request.getContextPath());
Connection con=null;
Statement st=null;
ResultSet rs=null;
//response.setContentType("text/html;charset=utf-8");
PrintWriter out= response.getWriter();
final String url="jdbc:mysql://localhost:3306/DataBase01?useSSL=false";
final String driver="com.mysql.jdbc.Driver";
final String user="root";
final String password="root";
try {
Class.forName(driver);
out.print("this is the test");
con=DriverManager.getConnection(url,user,password);
st=con.createStatement();
String sql="select sname,spwd from stu";
rs=st.executeQuery(sql);
out.print("<table border=1>");
while (rs.next()) {
out.print("<tr>");
out.print("<td>"+rs.getString("sname")+"</td>");
out.print("<td>"+rs.getInt("spwd")+"</td>");
out.print("</tr>");
}
out.print("</table>");
} catch (SQLException e) {
// TODO 自动生成的 catch 块
Logger.getLogger(DataBaseServlet02.class.getName()).log(Level.SEVERE, null, e);
} catch (ClassNotFoundException e1) {
// TODO 自动生成的 catch 块
Logger.getLogger(DataBaseServlet02.class.getName()).log(Level.SEVERE, null, e1);
}finally {
if (rs!=null) {
try {
rs.close();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
Logger.getLogger(DataBaseServlet02.class.getName()).log(Level.SEVERE, null, e);
}
}
if (st!=null) {
try {
st.close();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
Logger.getLogger(DataBaseServlet02.class.getName()).log(Level.SEVERE, null, e);
}
}
if (con!=null) {
try {
con.close();
} catch (SQLException e) {
// TODO 自动生成的 catch 块
Logger.getLogger(DataBaseServlet02.class.getName()).log(Level.SEVERE, null, e);
}
}
out.close();
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}
}
driver由于MySQL版本不同引入的驱动程序不同,driver也不一样,所以根据以下填写