连接数据库的工具类

public class JdbcUtils {


private static String driver = "com.mysql.jdbc.Driver";
private static String url = "jdbc:mysql://localhost:3306/test1";
private static String user = "root";
private static String password = "123456";


// 获取连接对象
public static Connection getConnection() {
Connection conn = null;
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, password);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}


// 执行增删改的sql语句的方法
public static int exec(String sql) {
Connection conn = getConnection();
int num = 0;
try {
Statement stmt = conn.createStatement();
num = stmt.executeUpdate(sql);
close(conn,stmt,null);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return num;
}


// 关闭资源
public static void close(Connection conn, Statement stmt, ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
if (stmt != null) {
stmt.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
if (conn != null) {
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


}

}

   登录的案例

public class LoginDemo01 {
public static void main(String[] args) throws Exception {
//获取用户输入的用户名和密码
Scanner scanner = new Scanner(System.in);
System.out.println("请输入用户名:");
String username = scanner.nextLine();
System.out.println("请输入密码:");
String password = scanner.nextLine();

// System.out.println(username+"  "+password);

//1.

Connection conn = JdbcUtils.getConnection();

//2.

Statement stmt = conn.createStatement();

//3.

String sql="SELECT * FROM t_user WHERE username=? AND PASSWORD=?";
PreparedStatement pstmt = conn.prepareStatement(sql);
//第一个参数:?的索引值,从1开始
//第二个参数:?处对应的值
pstmt.setString(1, username);
pstmt.setString(2, password);


ResultSet rs = pstmt.executeQuery();
User user=null;
if(rs.next()){
user= new User(rs.getString(1),rs.getString(2),rs.getString(3));
}
//4.关闭资源
//PreparedStatement是Statement的子接口
JdbcUtils.close(conn, pstmt, rs);
//判断用户是否登录成功
if(user!=null){
System.out.println("登录成功!");
}else{
System.out.println("登录失败!");
}

}


}