java数据库怎么在tomcat运行_关于java jdbc连接oracle数据库在tomcat上运行问题

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

package com.tsinghua;

import javax.servlet.http.*;

import java.io.*;

import java.sql.*;

public class LoginCl extends HttpServlet{

public void doGet(HttpServletRequest req,HttpServletResponse res){

Connection ct=null;

Statement sm=null;

ResultSet rs=null;

try{

String u=req.getParameter("username");

String p=req.getParameter("passwd");

Class.forName("oracle.jdbc.driver.OracleDriver");

ct=DriverManager.getConnection("jdbc:oracle:thin@127.0.0.1:1521:orcl","SCOTT","tiger");

sm=ct.createStatement();

rs=sm.executeQuery("select top 1 *from users where username='"+u

+ "'and passed='"+p+"'");

if(rs.next()){

HttpSession hs=req.getSession(true);

hs.setMaxInactiveInterval(20);

hs.setAttribute("pass","ok");

res.sendRedirect("wel?uanme="+u+"&upass="+p);

}else{

res.sendRedirect("login");

}

}catch(Exception ex){

ex.printStackTrace();

}finally{

try{

if(rs!=null){

rs.close();

}

if(sm!=null){

sm.close();

}

if(ct!=null){

ct.close();

}

}catch(Exception ex){

ex.printStackTrace();

}

}

}

public void doPost(HttpServletRequest req,HttpServletResponse res){

this.doGet(req,res);

}

}