dbmanage.java

dwr和spring集成简单例子,包括整个工程的代码

package com.jw.db;

import java.sql.*;

public class Dbmanage {
	private Connection con;

	private static Dbmanage db = new Dbmanage();

	public Connection getcon() {
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

			con = DriverManager
					.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=pubs","sa","");
			return con;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return con;
	}

	public static Dbmanage getDb() {
		return db;
	}
}