package com.opensource.database;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class connectFactory
{
private final String Driver =
"com.microsoft.jdbc.sqlserver.SQLServerDriver";
private final String Url =
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=opensource";
private final String User = "sa";
private final String Password = ""; public Connection connect()
{
Connection connection = null;
try
{
Class.forName(Driver);
connection = DriverManager.getConnection(Url, User, Password);
}
catch (ClassNotFoundException cnfe)
{
cnfe.printStackTrace();
}
catch (SQLException sqle)
{
sqle.printStackTrace();
} return connection;
}
}
没什么可注释的,其实,如果真的在实际中应用的话,你可以配置Tomcat数据库连接池和数据源,这样访问效率高。
import java.sql.DriverManager;
import java.sql.SQLException;public class connectFactory
{
private final String Driver =
"com.microsoft.jdbc.sqlserver.SQLServerDriver";
private final String Url =
"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=opensource";
private final String User = "sa";
private final String Password = ""; public Connection connect()
{
Connection connection = null;
try
{
Class.forName(Driver);
connection = DriverManager.getConnection(Url, User, Password);
}
catch (ClassNotFoundException cnfe)
{
cnfe.printStackTrace();
}
catch (SQLException sqle)
{
sqle.printStackTrace();
} return connection;
}
}
没什么可注释的,其实,如果真的在实际中应用的话,你可以配置Tomcat数据库连接池和数据源,这样访问效率高。
88446783
大家叫个朋友
<Context path="" docBase="ROOT" reloadable="true" debug="0">
<Resource auth="Container" name="jdbc/pool" type="javax.sql.DataSource">
<ResourceParams name="jdbc/pool">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>user</name>
<value>sa</value> <!-- 用户名 -->
</parameter>
<parameter>
<name>password</name>
<value>uu</value> <!-- 密码 -->
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value> <!-- 驱动类 ->
</parameter>
<parameter>
<name>url</name>
<value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=opensource</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>20</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>1000</value>
</parameter>
</ResourceParams>
</Resource>
</Context>--web.xml----
<resource-ref>
<description>oracle Datasource example</description>
<res-ref-name>jdbc/pool</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>