myconn.java

此压缩文件解压后为eclipse的一个工程需要导入使用

package com.monitor.dao;

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

public class MyConn {
	private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private static final String URL="jdbc:sqlserver://localhost:1433;database=mydb;username=sa;password=123";
	private Connection conn=null;
	
	public MyConn() throws ClassNotFoundException, SQLException{
		Class.forName(DRIVER);
		conn=DriverManager.getConnection(URL);
		System.out.println("数据库已经连接！！！");
	}
	
	public ResultSet executeAllQuery(String sql) throws SQLException{
		return conn.createStatement().executeQuery(sql);
	}
	
	public void closeConn() throws SQLException{
		if(conn!=null){
			if(!conn.isClosed()){
				conn.close();
				System.out.println("数据库关闭！！！");
			}
		}
	}
	public static void main(String[] args) {
		try {
			MyConn conn=new MyConn();
		} catch (Exception e) {
			// TODO Auto-generated catch block
			System.out.println("连接失败！！！");
		}
	}
}