package main;

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

public final class DataBase {
private static Connection conn;
private static String user;

public static Connection connection() { return conn ; }
public static String getUser() { return user; }

public static boolean goConnect(String Server, String Port, String _user, String pass, String DBName) {
String url = "jdbc:sqlserver://" + Server + ":" + Port + ";database ="+DBName+";";

user = _user;

Properties props = new Properties();
props.setProperty("user", user);
props.setProperty("password", pass);

try {
conn = DriverManager.getConnection(url, props);
return true; 
} catch (SQLException ex) {
System.out.println(ex);
// вывести сообщение об ошибке 
return false; 
}
}

public void finalize(){
try{
conn.close(); 
}
catch (SQLException ex) {
System.out.println(ex);
}
}

public ResultSet resultSetQuery(String query){
try{
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery(query); 
return rs; 
}
catch (SQLException ex) {
System.out.println(ex);
}
return null;
}

public void sqlQuery(String query){
try{
Statement stmt=conn.createStatement();
stmt.executeUpdate(query); 
}
catch (SQLException ex) {
System.out.println(ex);
}
}
} 

package main;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.swing.table.AbstractTableModel;

public class UsersTableModel extends AbstractTableModel{

private int columncount=10;
private ArrayList<String[]>dataArrayList;


public UsersTableModel(){
dataArrayList=new ArrayList<String[]>();
for(int i=0;i<dataArrayList.size();i++)
dataArrayList.add(new String[getColumnCount()]);

}
@Override
public int getRowCount() {
return dataArrayList.size();
}

@Override
public int getColumnCount() {
return columncount;
}

@Override
public String getColumnName(int Columnindex){
switch(Columnindex){
case 0:return"код";
case 1:return"Фамилия";
case 2:return"Имя";
case 3:return"Отчество"; 
}
return "";
}

@Override
public Object getValueAt(int rowIndex, int columnIndex) {
String[]rows= dataArrayList.get(rowIndex); 
return rows[columnIndex];
}
public void addDate(String[]row){
String [] rowTable = new String[getColumnCount()];
rowTable=row;
dataArrayList.add(rowTable); 
}
public void addUser(DataBase conn){
ResultSet result = conn.resultSetQuery("SELECT * FROM users");
try{
while(result.next()){
String [] row={
result.getString("id"),
result.getString("Fam"),
result.getString("Imya"),
result.getString("Otch"), 
};
addDate(row); 
}

}catch(SQLException ex){
System.out.println(ex);
}
}
}

import java.sql.CallableStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;
import java.util.Vector;
import javax.swing.DefaultCellEditor;
import javax.swing.JComboBox;
import javax.swing.JOptionPane;
import javax.swing.table.DefaultTableModel;

public class UsersManager extends javax.swing.JInternalFrame {

private void formInternalFrameOpened(javax.swing.event.InternalFrameEvent evt) { 
UsersTableModel utb = new UsersTableModel();

UserTable1.setModel(utb);
UserTable.setModel(utb);
utb.addUser(DataBase.goConnect("localhost", "1433", "sa", "111", "DataBase"));//ошибка
}