public static void connect() { try { DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver()); link = DriverManager.getConnection(myURL); } catch (SQLException e) { System.out.println("Echec de la connexion : " + e.getMessage()); } }
@Override public void doPost(HttpServletRequest req, HttpServletResponse resp) throws IOException { System.out.println("Clearing changes"); Connection c = null; try { DriverManager.registerDriver(new AppEngineDriver()); c = DriverManager.getConnection("jdbc:google:rdbms://trmrphdn:veebirakendused/andmebaas"); String statement = "delete from kandidaat where nimi = 'Tandi Kaat'"; PreparedStatement stmt = c.prepareStatement(statement); stmt.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } }
public void service(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { try { Driver driver = new com.mysql.jdbc.Driver(); DriverManager.registerDriver(driver); Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1/school", "root", "password"); PreparedStatement preparedStatement = connection.prepareStatement("update student set name=?, per=? where roll=?"); preparedStatement.setString(1, request.getParameter("name")); preparedStatement.setFloat(2, Float.parseFloat(request.getParameter("per"))); preparedStatement.setInt(3, Integer.parseInt(request.getParameter("roll"))); preparedStatement.execute(); preparedStatement.close(); connection.close(); } catch (SQLException e) { e.printStackTrace(); } RequestDispatcher requestDispatcher = request.getRequestDispatcher("/Display"); requestDispatcher.forward(request, response); }
public void doGet(HttpServletRequest req, HttpServletResponse resp) throws IOException { String fName = req.getParameter("fName"); String lName = req.getParameter("lName"); String party = req.getParameter("party"); String area = req.getParameter("area"); Connection c = null; try { DriverManager.registerDriver(new AppEngineDriver()); c = DriverManager.getConnection( "jdbc:google:rdbms://netivalimised2013:netivalimised/evalimised"); String statement; if ((fName.equals("") || fName == null) && (lName.equals("") || lName == null) && (party.equals("") || party == null) && (area.equals("") || area == null)) { System.out.println("Getting all candidates"); statement = "SELECT Person.FirstName, Person.LastName, Party.PartyName, Area.AreaName " + "FROM Person JOIN Party ON Person.PartyID = Party.Party_Id JOIN Area ON Person.AreaID = Area.Area_Id"; } else statement = createQuery(fName, lName, party, area); PreparedStatement stmt = c.prepareStatement(statement); ResultSet rs = stmt.executeQuery(); String jsonData = createJSON(rs, party, area); resp.setContentType("application/json"); resp.setCharacterEncoding("UTF-8"); resp.getWriter().write(jsonData); } catch (SQLException e) { e.printStackTrace(); } finally { if (c != null) { try { c.close(); } catch (SQLException ignore) { } } } // resp.setHeader("Refresh","3; url=/evalimised.jsp"); }
// To connect to the specified database. private static Connection getConnected( String drivername, String dbstring, String username, String password) throws Exception { Class drvClass = Class.forName(drivername); DriverManager.registerDriver((Driver) drvClass.newInstance()); return (DriverManager.getConnection(dbstring, username, password)); }