import java.sql.*;

public class InquireDB {

  public static int getLehrUmfangVonProfessor(String profName) {
    
    int sumsws    = 0;  
    String url    = "jdbc:microsoft:sqlserver://maestro:1433";
    String user   = "erika";
    String pwd    = "mustermann";

    try {

      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      Connection con =      DriverManager.getConnection(url, user, pwd);      

      PreparedStatement stmt = con.prepareStatement(
        "SELECT SUM(v.SWS) AS SUMSWS " +
        "FROM Vorlesungen v, Professoren p " +
        "WHERE v.gelesenVon = p.PersNr " +
        "AND p.Name = ?");

      stmt.setString(1, profName);                  
      ResultSet rset =      stmt.executeQuery();
      rset.next();                              
      sumsws = java.lang.Integer.parseInt(rset.getString("SUMSWS"));
      rset.close();
      stmt.close();
      con.close();
    } catch (Exception e) {e.printStackTrace();}

    return sumsws;

  }
}