1. public class SQL注入 {
    2. public static void main(String[] args) {
    3. // login("weisong","123456");
    4. login("'or '1=1","123456");
    5. }
    6. //登录业务
    7. public static void login(String username , String password){
    8. Connection conn = null;
    9. Statement st = null;
    10. ResultSet rs = null;
    11. try {
    12. conn = JdbcUtils.getConnection();
    13. st = conn.createStatement();
    14. //SQL SELECT * FROM users WHERE `Name` = 'weisong' AND PASSWORD = '123456';
    15. String sql = "SELECT * FROM users WHERE `Name` = '"+username+"' AND `PASSWORD` = '"+password+"'";
    16. rs = st.executeQuery(sql);//查询完毕会返回结果集
    17. while(rs.next()){
    18. System.out.println(rs.getString("NAME"));
    19. System.out.println(rs.getString("password"));
    20. }
    21. } catch (SQLException e) {
    22. e.printStackTrace();
    23. }finally{
    24. JdbcUtils.release(conn,st,rs);
    25. }
    26. }
    27. }

    sql存在漏洞,会被攻击导致数据泄露,SQL会被拼接or