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; } }