A simple generator for spring's JdbcTemplate requirement jinja2 mysql-python-connector(not included in requiremetns.txt) usage edit config.py in shell: python generator.py table_name Then copy generated java file to your project.