ant

build.xml:

<?xml version="1.0" encoding="UTF-8"?><project name="车险承保" default="upload"><property file="build.properties"></property><property environment="env"></property><property name="web.dir" location="WebRoot"></property><property name="web.name" value="CXCB"></property><property name="web.WEB-INF.dir" location="${web.dir}/WEB-INF"></property><property name="lib.dir" location="${web.WEB-INF.dir}/lib"></property><property name="build.dir" location="build"></property><property name="build.dir.src" location="${build.dir}/src"></property><property name="build.dir.classes" location="${build.dir}/classes"></property><property name="build.dir.war" location="${build.dir}/war"></property><path id="compile-path"><fileset dir="${lib.dir}" includes="**/*.jar"></fileset><fileset dir="${env.CATALINA_HOME}/lib" includes="**/*.jar"></fileset></path><target name="clean"><delete dir="${build.dir}"></delete></target><target name="init" depends="clean"><mkdir dir="${build.dir}" /><mkdir dir="${build.dir.src}" /><mkdir dir="${build.dir.classes}" /><mkdir dir="${build.dir.war}" /></target><target name="copy" depends="init"><copydir dest="${build.dir.src}" src="src"></copydir></target><target name="compile" depends="copy"><javac destdir="${build.dir.classes}" srcdir="${build.dir.src}" includeantruntime="true" classpathref="compile-path" encoding="utf-8"></javac><copy todir="${build.dir.classes}"><fileset dir="${build.dir.src}" excludes="**/*.java"></fileset></copy></target><target name="war" depends="compile"><war destfile="${build.dir.war}/${web.name}.war" webxml="${web.WEB-INF.dir}/web.xml"><fileset dir="${web.dir}"><include name="*.jsp" /></fileset><lib dir="${lib.dir}"></lib><classes dir="${build.dir.classes}" /></war></target><target name="deleteWar" description="删除服务器上的war" depends="war"><delete dir="${env.CATALINA_HOME}/webapps/${web.name}" /><delete file="${env.CATALINA_HOME}/webapps/${web.name}.war"></delete></target><target name="deploy" depends="war, deleteWar" description="发布"><copy file="${build.dir.war}/${web.name}.war" todir="${env.CATALINA_HOME}/webapps"></copy></target><target name="clear-log-destdir"><sshexec host="10.2.19.184" username="root" password="ht" command="cd /jboss/tomcat-gxcb/bin;cd /jboss/tomcat-gxcb/webapps;rm -rf CXCB;cd /jboss/tomcat-gxcb/logs; rm -rf *;cd /jboss/destdir;rm -rf *;" trust="true" /></target><target name="upload" depends="deploy, clear-log-destdir"><scp todir="jboss@10.2.19.22:/jboss/tomcat-gxcb/webapps" password="jboss" trust="true" file="D:\tomcat\webapps\CXCB.war"></scp></target><target name="clear-database"><sql classpath="${lib.dir}\ojdbc14.jar" userid="${username}" password="${password}" url="${oracle.url}" driver="${oracle.databaseDriver}"><transaction src="test.sql"></transaction></sql></target></project>

build.properties:

oracle.databaseDriver = oracle.jdbc.driver.OracleDriver
username = test
password = test
oracle.url = jdbc:oracle:thin:@(description=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.2.22.22)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = racl)))

test.sql:

delete from mig_cb