1 // Copyright 2022 Code Intelligence GmbH 2 // 3 // Licensed under the Apache License, Version 2.0 (the "License"); 4 // you may not use this file except in compliance with the License. 5 // You may obtain a copy of the License at 6 // 7 // http://www.apache.org/licenses/LICENSE-2.0 8 // 9 // Unless required by applicable law or agreed to in writing, software 10 // distributed under the License is distributed on an "AS IS" BASIS, 11 // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 12 // See the License for the specific language governing permissions and 13 // limitations under the License. 14 15 package com.example; 16 17 import com.code_intelligence.jazzer.api.FuzzedDataProvider; 18 import java.sql.Connection; 19 import java.sql.SQLException; 20 import org.h2.jdbcx.JdbcDataSource; 21 22 public class SqlInjection { 23 static Connection conn = null; 24 fuzzerInitialize()25 public static void fuzzerInitialize() throws Exception { 26 JdbcDataSource ds = new JdbcDataSource(); 27 ds.setURL("jdbc:h2:./test.db"); 28 conn = ds.getConnection(); 29 conn.createStatement().execute( 30 "CREATE TABLE IF NOT EXISTS pet (id IDENTITY PRIMARY KEY, name VARCHAR(50))"); 31 } 32 insecureInsertUser(String userName)33 static void insecureInsertUser(String userName) throws SQLException { 34 // Never use String.format instead of java.sql.Connection.prepareStatement ... 35 conn.createStatement().execute(String.format("INSERT INTO pet (name) VALUES ('%s')", userName)); 36 } 37 fuzzerTestOneInput(FuzzedDataProvider data)38 public static void fuzzerTestOneInput(FuzzedDataProvider data) throws Exception { 39 insecureInsertUser(data.consumeRemainingAsString()); 40 } 41 } 42