乐趣区

关于机器学习:ava代码审计之不安全的Java代码

作者：

jiezi

在

​ SQLI(SQL Injection)， SQL注入是因为程序未能正确对用户的输出进行查看，将用户的输出以拼接的形式带入SQL语句，导致了SQL注入的产生。攻击者可通过SQL注入间接获取数据库信息，造成信息透露。
SQL注入之JDBC注入

​ JDBC有两个办法执行SQL语句，别离是PrepareStatement和Statement。

破绽代码：

// 采纳原始的Statement拼接语句，导致破绽产生

public String jdbcVul(String id) {

StringBuilder result = new StringBuilder();
try {
    Class.forName("com.mysql.cj.jdbc.Driver");
    Connection conn = DriverManager.getConnection(db_url, db_user, db_pass);

    Statement stmt = conn.createStatement();
    // 拼接语句产生SQL注入
    String sql = "select * from users where id = '" + id + "'";
    ResultSet rs = stmt.executeQuery(sql);

    while (rs.next()) {
        String res_name = rs.getString("user");
        String res_pass = rs.getString("pass");
        String info = String.format("查问后果 %s: %s", res_name, res_pass);
        result.append(info);
    }

破绽代码二：

// PrepareStatement会对SQL语句进行预编译，但有时开发者为了便当，间接采取拼接的形式结构SQL，此时进行预编译也无用。

Connection conn = DriverManager.getConnection(db_url, db_user, db_pass);
String sql = “select * from users where id = ” + id;
PreparedStatement st = conn.prepareStatement(sql);
System.out.println(“[*] 执行SQL语句：” + st);
ResultSet rs = st.executeQuery();

​
SQL注入之MyBatis

​ MyBatis框架底层曾经实现了对SQL注入的进攻，但存在使用不当的状况下，依然存在SQL注入的危险。

破绽代码：

// 此破绽呈现频率较高并且很重大！
// 为何产生：因为应用 #{} 会将对象转成字符串，造成 order by “user” desc 造成谬误，因而很多研发会采纳${}来解决，从而造成SQL注入
// 点击运行可通过报错语句获取数据库user

@RequestMapping(“/mybatis/vul/order”)
public List<User> orderBy(String field, String sort) {

return userMapper.orderBy(field, sort);

}

// mapper.xml语句
<select id=”orderBy” resultType=”com.best.hello.entity.User”>

select * from users order by ${field} ${sort}

</select>

破绽代码二：
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
https://weibo.com/a/hot/76273…
// 含糊搜寻时，间接应用’%#{q}%’ 会报错，局部研发图不便间接改成’%${q}%’从而造成注入

评论

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注

这个站点使用 Akismet 来减少垃圾评论。了解你的评论数据如何被处理。

更多文章