Java链接sql server并对它进行查询、增删改

import java.sql.*;


import javax.swing.JOptionPane;


public class SqlManager {
String sql;
private static Connection conn = null;
private static PreparedStatement pstm = null;
private static ResultSet rs = null;
private static int count = 0;//计算SQL一共取出多少数据
 
     public static void openConnection(){
    String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// 数据库驱动
         String url = "jdbc:sqlserver://localhost:1433;databaseName=Bank";
         String userName = "sa";
         String passWord = "1234";
         try{
             Class.forName(driverName);
             conn= DriverManager.getConnection(url, userName, passWord);
    }catch(ClassNotFoundException cnfe){
        JOptionPane.showMessageDialog(null,"数据源错误","错误",JOptionPane.ERROR_MESSAGE);
    }catch(SQLException sql){
        JOptionPane.showMessageDialog(null,"数据操作错误","错误",JOptionPane.ERROR_MESSAGE);
    } 
     }
     public static void closeConnection(){
    try {  
    conn.close();  
    } catch (Exception e) {  
    e.printStackTrace();  
    } 
     }
     public static String[] executeQuery(String sql){//执行SQL语句，并将查询结果放到result里
    try{
    pstm = conn.prepareStatement(sql);
    rs = pstm.executeQuery();
    count = 0;//计算一共取出多少数据
    while(rs.next()){
    count++;
    }
    rs = pstm.executeQuery();
    String[] result = new String[count];//将取出的数据存放到字符串数组里
    //将取出的数据存放到result里
    int i=0;
    while(rs.next()){
    result[i] = rs.getString(1);
    i++;
    } 
    return result;
     }catch(Exception e){  
    e.printStackTrace();  
    throw new RuntimeException(e.getMessage());  
     }
     }
     public int getCount(){
    return count;
     }
     public static void update(String sql){
    try {  
      pstm = conn.prepareStatement(sql);  
          pstm.executeQuery();  
          pstm.executeUpdate(); 
    } catch (Exception e) {  
        e.printStackTrace();  
    }  
     }
}