java rs.last_rs.last()

package com.runoob.test;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import sun.security.action.GetBooleanAction;

/**

* Servlet implementation class Login

*/

@WebServlet("/Login")

public class Login extends HttpServlet {

private static final long serialVersionUID = 1L;

//JDBC驱动器名称和数据库的URL

static final String JDBC_DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";

static final String DB_URL="jdbc:sqlserver://localhost:1433;DatabaseName=ReportServerTempDB";

//数据库的凭据

static final String USER="sa";

static final String PASS="123457";

private Statement stmt;

private Connection conn;

private ResultSet rs;

/**

* @see HttpServlet#HttpServlet()

*/

public Login() {

super();

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)

*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

//throw new ServletException("GET method used with " +

//getClass( ).getName( )+": POST method required.");

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

// TODO Auto-generated method stub

//doGet(request,response);

String site0 = request.getContextPath() + "/InPut.jsp";

String site1 = new String("http://localhost:8080/Login/Login.jsp");

String userId=request.getParameter("userId");

String pass=request.getParameter("password");

response.setContentType("text/html;charset=UTF-8");

try{

//注册JDBC驱动器

Class.forName(JDBC_DRIVER);

//打开一个连接

conn = DriverManager.getConnection(DB_URL, USER, PASS);

//执行SQL查询

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

String sql = "SELECT userId,password FROM Table_1 where userId ='" + userId +"' and password = '" + pass + "'";

rs = stmt.executeQuery(sql);

rs.last(); //定位到最后一行，即读出到最后一行，否则，计算不出来所有的行数

int rowCount = rs.getRow();

if(rowCount>0)

{

request.getSession().setAttribute("userInfo", userId);

response.sendRedirect(site0);

}

else

{

response.sendRedirect(site1);

}

}

catch(SQLException se){

//处理JDBC错误

se.printStackTrace();

}

catch(Exception e){

//处理Class.forName错误

e.printStackTrace();

}

finally{

//最后是用于关闭资源的块

try{

if(stmt!=null)

stmt.close();

}

catch(SQLException se2){

}//我们不能做什么

try {

rs.close();

} catch (SQLException e) {

e.printStackTrace();

}

try{

if(conn!=null)

conn.close();

}

catch(SQLException se){

se.printStackTrace();

}//end finally try

}//end try

}

}

posted on

2016-08-17 15:31

cyy_13

阅读(295)

评论(0)

编辑

收藏