關(guān)于maven項(xiàng)目遠(yuǎn)程部署以及用tomcat配置數(shù)據(jù)庫(kù)連接的方法

<plugin>
  <groupId>org.apache.tomcat.maven</groupId>
  <artifactId>tomcat7-maven-plugin</artifactId>
  <version>2.2</version>
  <configuration>
    <username>admin</username>
    <password>123456</password>
    <url>http://47.102.123.186:8095/manager/text</url>
    <server>tomcatServer</server> //要與server中的id保持一致
    <update>true</update>
    <path>/zw</path>//項(xiàng)目名
  </configuration>
</plugin> 

<role rolename="admin-gui"/> 
<role rolename="manager-gui"/> // 允許訪問(wèn)html接口(即URL路徑為/manager/html/*)<role rolename="manager-script"/>// 允許訪問(wèn)純文本接口(即URL路徑為/manager/text/*)
<user username="admin" password="123456" roles="admin-gui,manager-gui,manager-script"/>
//注意！可以給該用戶添加多個(gè)角色，為了遠(yuǎn)程部署，至少需要這個(gè)角色：manager-script,也可以開啟manager-gui用于可視化管理

<server>		
<id>tomcatServer</id>
<username>admin</username>
<password>123456</password>
</server>

`<Resource name="jdbc/DataSource" auth="Container"
type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"		
url="jdbc:sqlserver://192.168.0.1;databaseName=xydi"		username="sa" 
password="sa" 
maxActive="20" //最大連接數(shù)
maxIdle="10"
maxWait="-1"/>`//最長(zhǎng)的等待時(shí)間

<ResourceLink name="jdbc/DataSource" global="jdbc/DataSource" 
type="javax.sql.DataSource"/>// 引入server.xml的配置信息

<resource-ref>
<res-ref-name>jdbc/DataSource</res-ref-name>//與resource的name保持一致   
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>` 

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
  <property name="jndiName" value="java:comp/env/jdbc/DataSource"/>
  <property name="expectedType" value="javax.sql.DataSource"/>
</bean>

Connection con = null;
Context c = new InitialContext();
DataSource ds = (DataSource) c.lookup("java:/comp/env/jdbc/DataSource");//項(xiàng)目名要與context.xml里面的對(duì)應(yīng)		
con = ds.getConnection();