/** * Handles the HTTP <code>GET</code> method. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Connection con = null; Statement st = null; ResultSet rs = null; String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; String url = "jdbc:sqlserver://y0i0qxm7zw.database.windows.net:1433;database=tartan;user=tartan@y0i0qxm7zw;password=Z3nfuzVfq77vo497IwC0;encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;"; System.out.println(request.getHeaderNames()); Cookie[] s = request.getCookies(); /*for(int i=0;i<s.length;i++){ System.out.println(s.) }*/ // request.getHeaderNames() try { // Class.forName(driver).newInstance(); Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(url); st = con.createStatement(); rs = st.executeQuery("SELECT VERSION()"); if (rs.next()) { System.out.println("Version:" + rs.getString(1)); } } catch (SQLException ex) { // Logger lgr = Logger.getLogger(); // lgr.log(Level.SEVERE, ex.getMessage(), ex); ex.printStackTrace(); } catch (Exception e) { e.printStackTrace(); } finally { try { if (rs != null) { rs.close(); } if (st != null) { st.close(); } if (con != null) { con.close(); } } catch (SQLException ex) { // Logger lgr = Logger.getLogger(Version.class.getName()); // lgr.log(Level.WARNING, ex.getMessage(), ex); ex.printStackTrace(); } } processRequest(request, response); }
/** * Handles the HTTP <code>POST</code> method. * * @param request servlet request * @param response servlet response * @throws ServletException if a servlet-specific error occurs * @throws IOException if an I/O error occurs */ @Override protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { processRequest(request, response); }