tomcat7.04+MySql的連接配接
1.首先在tomcat下的config/context.xml中的<context></context>中加入下面的resource
<Resource name="jdbc/MySQLDB" auth="Container" type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
maxActive="10" maxIdle="5" maxWait="10000"
username="ruan" password="123456"
url="jdbc:mysql://localhost:3306/blog" />
2.在web.xml中的<web-app></web-app>中加入以下配置
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/MySQLDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
3.程式中擷取Connection
public Connetcion getConnection() {
try {
Context ctx = new InitialContext();
DataSource ds = (DataSource)ctx.lookup("java:/comp/env/jdbc/MySQLDB");
Connection conn = ds.getConnection();
System.out.println(conn);
return conn;
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
連接配接Sql資料庫隻需要更改 driverClassName/url
SQL server2005
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
url="jdbc:sqlserver://localhost:1433;databaseName=selectcourse";
SQL server2000
driver = "net.sourceforge.jtds.jdbc.Driver";
url = "jdbc:jtds:sqlserver://127.0.0.1:1433/selectcourse";
Oracle資料庫
driverClassName="oracle.jdbc.driver.oracledriver"
url="jdbc:oracle:thin:@localhost:1521:yourdbname"