java当中JDBC当中请给出一个SQLServer DataSource and SingleTon例子

最新推荐文章于 2024-09-27 13:41:31 发布

原创最新推荐文章于 2024-09-27 13:41:31 发布 · 186 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#SQLServer 单态数据源例子 #java #马克java社区 #马克-to-win #DataSource SingleTon 单态数据源例子

java 专栏收录该内容

229 篇文章

订阅专栏

本文介绍了一种使用JDBC驱动实现SQL Server单例数据源的方法，通过Singleton模式确保了在整个应用程序中数据源的唯一性，提高了资源利用效率。文章提供了完整的代码示例，包括数据源的初始化和获取连接的过程，并通过测试程序验证了单例模式的有效性。

5.SQLServer DataSource and SingleTon：

import net.sourceforge.jtds.jdbcx.*;
import java.sql.*;
import javax.sql.*;

public class SqlserverSingletonDataSource {
static private JtdsDataSource ds;
private Connection con;
private SqlserverSingletonDataSource() {

try {
ds = new JtdsDataSource();
ds.setServerName("localhost");
ds.setDatabaseName("pubs");
ds.setUser("sa");
ds.setPassword("");
}
catch (Exception e) {
}
}

public static Connection getConnection() throws Exception {
if (ds == null) {
new SqlserverSingletonDataSource();
}
Connection con =null;
try {
con = ds.getConnection();
} catch (SQLException ex) {
}

return con;
}
}

测试程序：

/*when you use single step to debug the program, you can find that Singleton only
is executed once.*/
import java.sql.*;
import javax.sql.*;

public class testSqlserverSingletonDataSource {

public static void main(String args[]) {
Connection con;

try {
con = SqlserverSingletonDataSource.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from authors");
while (rs.next()) {
System.out.print(rs.getString("au_id") + " ");
System.out.println(rs.getString("au_lname"));
}

}
catch (Exception e) {
}

System.out.println("the following is the second time ");

try {
con = SqlserverSingletonDataSource.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from authors");
while (rs.next()) {
System.out.print(rs.getString("au_id") + " ");
System.out.println(rs.getString("au_lname"));
}

}
catch (Exception e) {
}

}

}