JDBC MSSQL

Question

Hi, I have written a small Java programm and I want to use Microsoft SQL instead of h2 database, what would I have to change in order for it to work?

here's some code of it:
try {
Connection con = DriverManager.getConnection("jdbc:h2:~/Weather", "sa", "");
} catch (SQLException e) {
e.printStackTrace();
}

try {
Statement st = this.con.createStatement();
st.execute("INSERT INTO Weather VALUES "+id+",'"+s+"',"+d+")");

        st.close();
    } catch (SQLException e) {
        e.printStackTrace();
    }

try {
Statement st = this.con.createStatement();
ResultSet rs = st.executeQuery("select * from WEATHER");

            while (rs.next()) // Cursor eins vor
                if (rs.getString(2).equals(name)){
                    anz++;
                    sum += rs.getInt(3);
                }

            rs.close();
            st.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }

// CREATE TABLE Weather( //so sieht die datenbank aus
// id int not null,
// station varchar(255) not null,
// temp double
// );

Answer 1

Servlet

@WebServlet(name = "timeOfEmployeeServlet", value = "/timeOfEmployeeServlet")
public class TimeOfEmployeeServlet extends HttpServlet {
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
Employee emp=(Employee) req.getServletContext().getAttribute("selectedEmployee");
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm");

    try {  
        Date startDate = formatter.parse(req.getParameter("start"));  
        Date endDate = formatter.parse(req.getParameter("end"));  
        ClientService.getEntriesByEmp(emp.getId(),startDate,endDate);  

        emp.setLogbookEntries(ClientService.getEntriesByEmp(emp.getId(),startDate,endDate));  
        req.getServletContext().setAttribute("selectedEmployee",emp);  
        System.out.println("Entries: "+emp.getLogbookEntries().size());  
        RequestDispatcher dispatcher=req.getRequestDispatcher("TimeOfEmployee.jsp");  
        dispatcher.forward(req,resp);  
    } catch (ParseException e) {  
        e.printStackTrace();  
    }  


}  

}

Answer 2

RESSOURCE

public class EmployeeResource implements IEmployeeResource {
EmployeeStore employeeStore= EmployeeStore.getInstance();

@Override  
public HashSet<Employee> getEmployees() {  
    System.out.println("GET Employees");  
    return employeeStore.getEmployees();  
}  

@Override  
public Employee addEmployee(Employee employee) {  
    employeeStore.addEmployee(employee);  
    Employee ret=new Employee();  
    boolean first=true;  
    for(Employee emp:employeeStore.getEmployees()){  
        if(!first){  
            if(emp.getId()>ret.getId()){  
                ret=emp;  
            }  
        }else{  
            ret=emp;  
        }  
    }  
    return ret;  
}  

@Override  
public Employee editEmployee(int id, Employee employee) {  
    return employeeStore.editEmployee(id,employee);  
}

Answer 3

DATASTORE

public class EmployeeStore {
private static EmployeeStore instance;
private HashSet<Employee> employees=new HashSet<>();

public EmployeeStore(HashSet<Employee> employees) {  
    this.employees = employees;  
}  

public static EmployeeStore getInstance() {  
    if (instance == null) {  
        instance = new EmployeeStore();  
    }  
    return instance;  
}  

public EmployeeStore() {  
    fillData();  
}  

public Employee getEmployeeById(int id){  
    for(Employee e:employees){  
        if(e.getId()==id){  
            return e;  
        }  
    }  
    return null;  
}  

public void fillData() {  
    for (int i = 0; i < 10; i++) {  
        Employee emp=new Employee(employees.size(), generateRandomName(), generateRandomName(), LocalDate.now());  
        emp.addEntry(new LogbookEntry("Sport", LocalDateTime.now(),LocalDateTime.now()));  
        emp.addEntry(new LogbookEntry("Lernen", LocalDateTime.now(),LocalDateTime.now()));  

        employees.add(emp);  
    }  
}  

public String generateRandomName() {//erzeugt random Namen aus den Buchstaben  
    String characters = "ABCDEFGHIJKLMNOPQRSTUVW";  
    String randomString = "";  
    int length = 5;  

    Random rand = new Random();  

    char[] text = new char[length];  

    for (int i = 0; i < length; i++) {  
        text[i] = characters.charAt(rand.nextInt(characters.length()));  
    }  
    for (int i = 0; i < text.length; i++) {  
        randomString += text[i];  

    }  
    return randomString;  
}  

public Employee editEmployee(int id, Employee emp) {  
    for (Employee employee : employees) {  
        if (employee.getId() == id) {  
            employees.remove(employee);  
            employee = new Employee(employee.getId(), emp.getFirstName(), emp.getLastName(), emp.getDateOfBirth());  
            employees.add(employee);  
            return employee;  
        }  
    }  
    return null;  
}  

public void addEmployee(Employee emp){  
    employees.add( new Employee(employees.size(), emp.getFirstName(), emp.getLastName(), emp.getDateOfBirth()));  
}  

public HashSet<Employee> getEmployees() {  
    return employees;  
}  

public void setEmployees(HashSet<Employee> employees) {  
    this.employees = employees;  
}  

}