LaTeX Forum

\renewcommand{\thesection}{\Alph{section}}
\appendix
\addchap{Anhang MySQL}
\section{Create Tables Script}
\label{sec:a1}
 \lstset{language = SQL, title=""}
  \begin{lstlisting} 
   ...
   \end{lstlisting}
   
\clearpage
\section{Insert Into Script}
\lstset{language = SQL, title=""}
  \begin{lstlisting} 
    ....
   \end{lstlisting}

% define documentclass
\documentclass[12pt, bibliography=totoc, a4paper, abstracton, numbers=noenddot,liststotoc]{scrreprt}

% define used packages
\usepackage[left=4.0cm, right=2.0cm, top=3cm, bottom=3cm]{geometry}
\usepackage{bibgerm}
\usepackage[utf8]{inputenc}
\usepackage[T1]{fontenc}
\usepackage{graphicx}
\usepackage[ngerman]{babel}
\usepackage{lmodern}
\usepackage{color}
\usepackage{listings}
\usepackage[numbers]{natbib}
\usepackage{tabularx}
\usepackage{here}
\usepackage{ragged2e}
\usepackage{remreset}
\makeatletter
\@removefromreset{footnote}{chapter}
\makeatother

\bibliographystyle{alphadin}


\usepackage{lastpage}


\usepackage{array}


\usepackage{fancyhdr}


\usepackage{url}


\usepackage[colorlinks=true ,linkcolor=black,
			anchorcolor=black ,citecolor=black ,filecolor=black,
			menucolor=black ,urlcolor=black]{hyperref}

\usepackage{amsmath, amssymb}

\usepackage{subfigure}

\input{lststyles}

\pagestyle{empty}

\setlength{\parindent}{0pt}
\setlength{\parskip}{3pt}


\pageref{LastPage}}
\newcommand{\DATE}[0]{22.01.2013}

\newcommand{\low}[1]{\ensuremath{\mathrm{#1}}}


\begin{document}
\renewcommand{\bibname} {Literaturangaben} 
\renewcommand\abstractname{Abstract}


\pagenumbering{Roman}

\input{title}
\input{abstract}

\input{fancyRegisterPart}


\tableofcontents\newpage


\pagenumbering{arabic}

\input{fancyMainPart}


\input{chapter0}
\input{chapter1}
\input{chapter2}
\input{chapter3}
\input{chapter4}
\input{chapter5}
\input{chapter6}
\input{chapter7}
\input{chapter8}
\newpage
\input{fancyRegisterPart}
\input{titelvorschlaege}
\bibliography{quellen}
\input{declaration}
\listoffigures
\listoftables
\lstlistoflistings
\input{appendix.tex}
% end of the document
\end{document}

\documentclass{scrreprt} 
\usepackage{scrhack}
\usepackage{listings} 
\begin{document} 
\lstlistoflistings 
\chapter{Anhang MySQL} 
\begin{lstlisting}[language = SQL, title={Kein Eintrag ins Listingsverzeichnis}] 
  ... 
\end{lstlisting} 
\end{document}

\documentclass[12pt, bibliography=totoc, a4paper, abstracton, numbers=noenddot,liststotoc]{scrreprt}

\usepackage[left=4.0cm, right=2.0cm, top=3cm, bottom=3cm]{geometry}

\usepackage[utf8]{inputenc}
\usepackage{graphicx}
\usepackage[ngerman]{babel}
\usepackage{color}
\usepackage{listings}
\usepackage{fancyhdr}

\input{lststyles}


\newcommand{\HEADER}[0]{Fachhochschule Schmalkalden WS 2012/2013}
\newcommand{\PAGENUMBERS}[0]{Seite \pagemark}
\newcommand{\DATE}[0]{22.01.2013}

\newcommand{\AUTHOR}[0]{Vorname Name}

\begin{document}
\tableofcontents\newpage
\input{fancyMainPart}
\newpage
\input{fancyRegisterPart}
\lstlistoflistings
\input{appendix.tex}
\end{document}

\lstloadlanguages{Java,sh,bash,Haskell,HTML,PHP,XML}
\lstdefinelanguage{console}{
  morekeywords={},
  otherkeywords={warumgehtdasnicht>,\$}
}
\newcommand{\lstsetconsole}
{ \lstset{language=sh,
        lineskip=-2pt,
        breaklines=true,
        language=console,
        breaklines=true,
        commentstyle=\textit,
        keywordstyle=\bfseries,
        basicstyle=\ttfamily,
        stringstyle=\ttfamily,
        showstringspaces=false,
        frame=single,
        tabsize=2
  }
}


\lstdefinelanguage{scala}{
  morekeywords={abstract,case,catch,class,def,%
    do,else,extends,false,final,finally,%
    for,forSome,if,implicit,import,lazy,match,mixin,%
    new,null,object,override,package,%
    private,protected,requires,return,sealed,%
    super,this,throw,trait,true,try,%
    type,val,var,while,with,yield},
  otherkeywords={_,:,=,=>,<-,<\%,<:,>:,\#,@},
  sensitive=true,
  morecomment=[l]{//},
  morecomment=[n]{/*}{*/},
  morestring=[b]",
  morestring=[b]',
  morestring=[b]"""
}
\newcommand{\lstsetscala}{
 \lstset{language=scala,              
       basicstyle=\footnotesize,       
       numbers=left,                   
       numberstyle=\footnotesize,      
       stepnumber=1,                   
       numbersep=5pt,                 
       backgroundcolor=\color{white},  
       showspaces=false,              
       showstringspaces=false,         
       showtabs=false,                
       frame=single,          
       tabsize=2,          
       captionpos=t,       
       breaklines=true,        
       breakatwhitespace=false,    
       escapeinside={\%*}{*)}    
 }
 }
 
\newcommand{\lstsetsql}{
 \lstset{language=sql,              
       basicstyle=\footnotesize,       
       numbers=left,                   
       numberstyle=\footnotesize,      
       stepnumber=1,                   
       numbersep=5pt,                 
       backgroundcolor=\color{white},  
       showspaces=false,              
       showstringspaces=false,         
       showtabs=false,                
       frame=single,          
       tabsize=2,          
       captionpos=t,          
       breaklines=true,        
       breakatwhitespace=false,    
       escapeinside={\%*}{*)}
}
}

\appendix
\chapter{Anhang MySQL}
\section{Create Tables Script}
\label{sec:a1}
 \lstset{language = SQL, title=""}
  \begin{lstlisting} 
   ...
   \end{lstlisting}
   
\clearpage
\section{Insert Into Script}
\label{sec:a2}
\lstset{language = SQL, title=""}
  \begin{lstlisting} 
   ...
   \end{lstlisting}