Spring Boot + Heroku

– Download heroku-cli-win64.exe – Installation without GIT (it was installed in version 2.9) – First command „heroku login“ in starts 12MB update C:\Temp>heroku –version heroku-cli/5.12.0-211263f (windows-amd64) go1.7.5C:\Temp>heroku –version heroku-cli/5.12.0-211263f (windows-amd64) go1.7.5 – heroku create – project demo-spring-heroku changed to JDK umgestellt (for „mvn install“ to work) – Eclipse/Run as: maven clean – Eclipse/Run as: maven […]

The Joel Test

Our current rating for the The Joel Test: 12 Steps to Better Code. – Do you use source control? – Can you make a build in one step? – Do you make daily builds? – Do you have a bug database? – Do you fix bugs before writing new code? – Do you have an […]

SQL-Abfrage zu XML-Datei

Das tägliche Abfrageergebnis als XML-Datei schreiben. Die Spalte „erstellt“ enthält Datum und Uhrzeit von der Datensatzanlage. @echo off set jahr=%date:~-2% set monat=%date:~-7,2% set tag=%date:~-10,2% bcp "select t1.* \ , convert(date, dateadd(day, -1, ‚%tag%.%monat%.%jahr%‘), 104) as exportkey \ from db..table t1 \ where convert(date, [erstellt]) = dateadd(day, -1, ‚%tag%.%monat%.%jahr%‘) \ order by [erstellt] desc \ for […]

Structured Query Language (SQL)

DML (Data Manipulation Language): select, insert, update, delete DDL (Data Definition Language): create, alter, drop DCL (Data Control Language): grant, revoke TCL (Transaction Control Language): begin tran, commit tran, rollback


„MyBatis is a first class persistence framework with support for custom SQL, stored procedures and advanced mappings. MyBatis eliminates almost all of the JDBC code and manual setting of parameters and retrieval of results.“ package org.mybatis.example; public interface BlogMapper { @Select("SELECT * FROM blog WHERE id = #{id}") Blog selectBlog(int id); }package org.mybatis.example; public interface […]