我在MyEclipse中调用Oracle出现问题,但是我添加了JDBC jar包,而且buildpath也对,我找不出问题所在,请高手帮帮忙,谢谢
下面贴出代码及截图package com.controller;import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class LoginClServlet extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
} public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=uft-8");
response.setCharacterEncoding("utf-8");
//解决提交表单时发生中文乱码的方法,设置request的编码格式
request.setCharacterEncoding("utf-8");
//PrintWriter pw=response.getWriter();
String name=request.getParameter("username");
int id=Integer.parseInt(name);
String password=request.getParameter("password");
System.out.println(id+" "+password);
//到数据库中验证
Connection ct=null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
//加载驱动
Class.forName("oracle.jdbc.driver.oracleDriver");
//创建连接
ct=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:ORCL","scott","junsun1982");
//创建preparestatements
ps=ct.prepareStatement("select * from users where id=? and password=?");
ps.setObject(1,id);
ps.setObject(2, password);
//执行
rs=ps.executeQuery();
//验证
if(rs.next()){
request.getRequestDispatcher("/mainFrame?name="+id).forward(request, response);
}else{
request.getRequestDispatcher("/loginServlet").forward(request, response);
}
} catch (Exception e) {
e.printStackTrace();
}finally{
//关闭资源
// try {
// rs.close();
// ps.close();
// ct.close();
// } catch (SQLException e) {
// e.printStackTrace();
// }
}
}}