模拟用户登录 LoginUser.java

package com.tedu;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;

import com.tedu.utill.jdbcUtil;

/**

• 模拟用户登录

*/

public class LoginUser {
public static void main(String[] args) {
System.out.println(“请登录…”);
System.out.println(“请输入用户名：”);
Scanner sc = new Scanner(System.in);
String username = sc.nextLine();
System.out.println(“请输入密码：”);
String password = sc.nextLine();
Login(username, password);
}

/**
 * 根据用户名密码查询用户信息
 *
 */
public static void Login(String username, String password) {
	Connection conn = null;
	Statement stat = null;
	ResultSet rs = null;

	try {
		conn = jdbcUtil.getconn();
		stat = conn.createStatement();
		String sql = "select * from user where username='"
				+ "" + username + "'and password='" + password + "'";
		rs = stat.executeQuery(sql);
		if (rs.next()) {
			System.out.println("恭喜您登录成功！");
		} else {
			System.out.println("账号或密码错误！");
		}

	} catch (Exception e) {
		// TODO: handle exception
	} finally {
		jdbcUtil.close(conn, stat, rs);
	}

}

}