JDBC连接Oracle数据库
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
String name=request.getParameter("name");
String pwd=request.getParameter("pwd");
try {
//1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//2.获取连接
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","123456");
//3.创建命令
Statement sttm=conn.createStatement();
//4.创建sql命令
String sql="select * from users where name='"+name+"' and pwd='"+pwd+"'";
//5.执行命令获取结果集
ResultSet rs=sttm.executeQuery(sql);
if(rs.next()){
response.sendRedirect("/web3/dologin.jsp");
}else{
request.setAttribute("msg", "用户名或密码错误!");
request.getRequestDispatcher("/login.jsp").forward(request, response);
}
} catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}