dbconnection.java

来自「该系统采用B/S架构设计的一个小型的通讯录系统」· Java 代码 · 共 35 行

package DAO;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBConnection {
	private static String url="jdbc:jtds:sqlserver://127.0.0.1:1433;databasename=tongxun";
	private static String password="sa";
	private static String username="sa";
	private static Connection con ;
	static{
		try {
			Class.forName("net.sourceforge.jtds.jdbc.Driver");
			con = DriverManager.getConnection(url, username, password);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	public static Connection getConnection(){
		return con;
	}
	public  void close(){
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	
}