Java基础--JDBC（数据库连接、方法一）

public class TestLogin {
        //Beforey已经被BeforeEach替代
	@BeforeEach
	public void Before() {
		System.out.println("Before");
	}

	@Test
	public void TestLogin() {
		try {
			loginTest(null, "root", "root");
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
        //After已经被AfterEach替代
	@AfterEach
	public void After() {
		System.out.println("After");
	}

	public static void login(String url, String user, String password) throws ClassNotFoundException, SQLException {

		Connection conn = null; // 获取连接对象信息
		Statement stmt = null; // 创建执行SQL语句对象
		ResultSet rs = null; // 执行SQL语句

		// 1.注册驱动
		Class.forName("com.mysql.jdbc.Driver");
		// 连接默认URL;
		String defaultUrl = "jdbc:mysql://localhost:3306/root";
		url = url == null ? defaultUrl : url;

		// 2.获取连接
		conn = DriverManager.getConnection(url, user, password);
		stmt = conn.createStatement();

		String sql = "select * from user_info where " + "uname = '" + user + "' and upassword = '" + password + "'";
		// 执行SQL语句
		rs = stmt.executeQuery(sql);

		if (rs.next()) {
			System.out.println("验证成功");
		} else
			System.out.println("验证错误");

		// 释放资源
		if (rs != null)
			rs.close();
		if (stmt != null)
			stmt.close();
		if (conn != null)
			conn.close();
	}

	public static void loginTest(String url, String user, String password) throws ClassNotFoundException, SQLException {

		Connection conn = null; // 获取连接对象信息
		PreparedStatement pstmt = null; // 创建执行SQL语句对象
		ResultSet rs = null; // 执行SQL语句

		// 1.注册驱动
		Class.forName("com.mysql.jdbc.Driver");
		// 2.连接默认URL;
		String defaultUrl = "jdbc:mysql://localhost:3306/root";
		url = url == null ? defaultUrl : url;

		// 3.获取连接
		conn = DriverManager.getConnection(url, user, password);
		
		//4.编写SQL语句
		String sql = "select * from user_info where uname = ? and upassword = ?";
		
		//5.创建预编译处理对象
		pstmt = conn.prepareStatement(sql);
		
		//6.设置参数
		pstmt.setString(1, user); //此时这里数字1,表示的是上面的SQL语句中那个参数;
		pstmt.setString(2, password);
		
		//执行SQL操作
		rs = pstmt.executeQuery();
		
		if (rs.next()) {
			System.out.println("验证成功");
			System.out.println(rs.getObject(1));
		} else
			System.out.println("验证错误");

		// 释放资源
		if (rs != null)
			rs.close();
		if (pstmt != null)
			pstmt.close();
		if (conn != null)
			conn.close();
	}
}