我想在Java Web应用程序中连接到数据库。我在servlet中编写了以下代码,并添加了相关的jar文件(ojdbc),但当我运行它时,它给出以下错误:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
public class DBConnection extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public DBConnection() {
super();
// TODO Auto-generated constructor stub
}
public void service(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {
Connection con = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.101.84:1521:orcl","XXXX","XXXX");
if(con!=null)
System. out.println("Connection Successful");
else
System. out.println("error");
}
catch (Exception e) {
//System.out.println(e);
}
...
我应该做什么?
classes12.jar
放在WEB-INF/lib
目录下。 - AllTooSirWEB-INF/lib
文件夹中。它将在运行时从该位置被获取。 - AllTooSir