import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class EmailInsert {
	final private static String defaultUrl = "jdbc:mariadb://localhost/test?user=root";

	//
	//  create table tmail(txt mediumtext);
	//
	
	public static void main(String[] args) throws SQLException {
		String bodyText = "some text \\\\''s more text ?";

		String sql = "insert into tmail(txt) values('"+bodyText+"')";

		Connection conn = DriverManager.getConnection(defaultUrl);
		PreparedStatement stmt = conn.prepareStatement(sql);

		System.out.println("running: "+sql);
		int cnt = stmt.executeUpdate();
		System.out.printf("inserted %d rows\n", cnt);
		conn.commit();

		stmt.close();
		conn.close();
	}
}
