jdbc 连接 mysql 获取数据集条数

最新推荐文章于 2024-10-20 13:15:00 发布

原创最新推荐文章于 2024-10-20 13:15:00 发布 · 3.5k 阅读

CC 4.0 BY-SA版权

本文介绍了一个使用Java Servlet实现的简单登录验证过程。该Servlet通过连接MySQL数据库来验证用户名和密码是否匹配，验证成功后返回相应的消息。代码展示了如何设置数据库连接、执行SQL查询并处理查询结果。

package nona;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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

public class LoginServlet extends HttpServlet {

	private int num = 0; //记录有多少条记录
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request, response);

	}

	public boolean login(String name, String password)  {
		// 连接数据库
		String driverName = "com.mysql.jdbc.Driver";
		Driver d;
		Connection con;
		Statement stmt;
		ResultSet results;
		try {
			d = (Driver) Class.forName(driverName).newInstance();
			con = DriverManager.getConnection("jdbc:mysql://localhost:3307/school",
					"root", "root");
			stmt = con.createStatement();
			String sqlstr = "select * from user where name = '"+ name +"' and password = '"+password +"'";
			results = stmt.executeQuery(sqlstr); // 获取数据库结果集
			
			while(results.next()){
				int id = results.getInt("id");
				String name1 = results.getString("name");
				String password1 = results.getString("password");
				System.out.println(" " + id + " " + name +" " + password);
				num ++;//数据条数
			}
            
			stmt.close();
			con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return true;
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		num = 0;
		String name = request.getParameter("name");
		String password = request.getParameter("password");
		System.out.println("name:"+ name +"  password: "+ password);
		boolean success = login(name, password);
		PrintWriter out = response.getWriter();
		if(success){
			out.write("login success: " +num);
		}else{
			out.write("login fail : " + num);
		}
		
	}
}