qiaohe-1 2016-08-07 02:38 采纳率: 50%
浏览 1290

初学java web 关于JDBC连接对象关闭问题?

package myweb2;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

//import com.mysql.jdbc.Connection;
import java.sql.Connection;
import com.mysql.jdbc.PreparedStatement;

public class LoginServlet extends HttpServlet {

/**
 * Constructor of the object.
 */
public LoginServlet() {
    super();
}

/**
 * Destruction of the servlet. <br>
 */
public void destroy() {
    super.destroy(); // Just puts "destroy" string in log
    // Put your code here
}

/**
 * The doGet method of the servlet. <br>
 *
 * This method is called when a form has its tag value method equals to get.
 * 
 * @param request the request send by the client to the server
 * @param response the response send by the server to the client
 * @throws ServletException if an error occurred
 * @throws IOException if an error occurred
 */
public void doGet(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {

        String username=request.getParameter("username");
        String password=request.getParameter("password");
        if(username==null||username.equals("")||password==null||password.equals("")){
            System.out.println("您输入的用户名和密码有误");
            return;
        }
        DBManager dbmanager=null;
        try {
            Connection conn = dbmanager.getConn();
            PreparedStatement pst=(PreparedStatement) conn.prepareStatement("select * from mytable where username=? AND password=?");
            pst.setString(1,username);
            pst.setString(2,password);
            ResultSet rs=pst.executeQuery();
            if (rs.next()){
                System.out.println("访问成功");
            } else { System.out.println("访问失败 ");}
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        finally{
        conn.close();
            };

if(username=="woniu"&&password=="123456"){


}
}
 问题:  conn.close(); 老是报错,提示有问题,关不不来,是怎么回事啊,那个大神给看看啊
  • 写回答

5条回答

  • bhtj27 2016-08-07 02:45
    关注

    先关掉rs试试
    rs.close();
    conn.close();

    评论

报告相同问题?

悬赏问题

  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
  • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站
  • ¥50 成都蓉城足球俱乐部小程序抢票
  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)
  • ¥15 电力市场出清matlab yalmip kkt 双层优化问题
  • ¥30 ros小车路径规划实现不了,如何解决?(操作系统-ubuntu)