conndb.java

简单的M2样式

package com.qs.model;

import java.sql.*;

public class ConnDB {
	
	private Connection ct=null;
	
	public Connection getConn(){
		
		try{
			
             //1.加载驱动
		     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		     //Class.forName("oracle.jdbc.driver.OracleDriver");
		     //2.得到连接
		     ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=qsdb1","sa","");
		     //ct=DriverManager.getConnection("jdbc:oracle:thin:@localhost:qiusheng","scott","qs123456");
			
		}
		catch(Exception e){
			
			e.printStackTrace();
		}
		return ct;
	}

}