dbconnect.java~1~

基于JB的网络数据库系统开发

package studentmanage;

import java.sql.*;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class DbConnect {
  public static  void  loadClass(){
    try{
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    }catch(ClassNotFoundException e1){
    System.out.println("加载JDBC数据库驱动程序出错");    }
  }
  public static  Connection makeConnect(String ip,String dbname,String user,String pwd){
    String url="jdbc:microsoft:sqlserver://"+ip+":1433;DatabaseName="+dbname;
    Connection con=null;
    try{
      con=DriverManager.getConnection(url,user,pwd);
    }catch(SQLException e2){
        System.out.println("建立Connection对象出错");
    }
    return con;
  }
  public static Statement makeStatement(Connection con){
    Statement stmt=null;
    try{
      stmt=con.createStatement();
    }catch(SQLException e3){
      System.out.println("建立Statement对象出错");
    }
    return stmt;
  }
  public static  ResultSet makeResultSet(Statement stmt,String sql){
    ResultSet rs=null;
    try{
      rs = stmt.executeQuery(sql);
  }catch(SQLException e2){
    System.out.println("读取数据出错");
  }
  return rs;

  }

  public static void  close(ResultSet rs){
    try{
      rs.close();
    }catch(SQLException e4){
      System.out.println("关闭ResultSet对象出错");
    }
  }
  public static void  close(Statement stmt){
    try{
      stmt.close();
    }catch(SQLException e4){
      System.out.println("关闭Statement对象出错");
    }
  }
  public static void  close(Connection con){
    try{
      con.close();
    }catch(SQLException e4){
      System.out.println("Connection对象出错");
    }
  }

}