当前位置: 代码迷 >> J2EE >> jdbc连接sql server
  详细解决方案

jdbc连接sql server

热度:559   发布时间:2013-11-10 00:46:12.0
package util; 
  
import java.sql.*; 
  
public class JdbcUtil 
{ 
    public static void close(Statement st, Connection con) 
    { 
        try
        { 
            st.close(); 
        }catch(Exception e) 
        { 
        } 
          
        try
        { 
            con.close(); 
        }catch(Exception e) 
        { 
        } 
    } 
      
    public static void close(ResultSet rs, Statement st, Connection con) 
    { 
        try
        { 
            rs.close(); 
        }catch(Exception e) 
        { 
        } 
        close(st, con); 
    } 
      
    public static Connection getConnection() throws Exception 
    { 
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 
        return DriverManager.getConnection("jdbc:microsoft:sqlserver://daimami.com:1433;DatabaseName=db", "sa", "54321"); 
  
    } 
}

  相关解决方案