connectionolts.java

连接测试系统

package com.cnu.cie.olts.server;

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

/**
*
* @author  Daley
*/

public class ConnectionOLTS {
	static String SQLdriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";   
    static String dbname="OLTS";//数据库名字           
    static String dbloginame="admin";
    static String dbpassword="admin";
    static String url="jdbc:microsoft:sqlserver://localhost:1433;databasename="+dbname;
    
    Statement   stmt;
    Connection  con;
    
    public ConnectionOLTS() throws Exception{
    	//装在SQL数据库驱动
		Class.forName(SQLdriver);   
		//连接数据库
		con=DriverManager.getConnection(url,dbloginame,dbpassword);  
        stmt= con.createStatement();
    }
    public Connection getConnection(){
	    return con;
	}
    
    public Statement getStatement(){
	    return stmt;
	}
	
	public static void  closeConn(Connection conn) throws SQLException{
        if (conn != null && !conn.isClosed())
        {
            conn.close();
        }
	}
	public static void  closeStatement(Statement stmt) throws SQLException{
        if (stmt != null )
        {
            stmt.close();
        }
	}
	public static void closeResultSet(ResultSet rs) throws SQLException
	{
	  if (rs != null)
	    {
	          rs.close();
	    }
	}
    
    
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}
}