Форум программистов [Powered by Invision Power Board]

Код

      public class GuestBookServlet extends HttpServlet {
              private static PreparedStatement prepstmt = null;
      ...............................................
              public static DataSource setupDataSource(String dbDriver, String dbURL) {
                      BasicDataSource ds = new BasicDataSource();
                      ds.setDriverClassName(dbDriver);
                      ds.setUrl(dbURL);
                      ds.setUsername("root");
                      ds.setPassword("1111");
                      return ds;
              }
              public void doPost(HttpServletRequest req, HttpServletResponse res){
                      try {
                              dataSource = setupDataSource(dbDriver, dbURL);
                              con = dataSource.getConnection();
                              String queryString = "INSERT INTO message(name) VALUES(?)";
                              prepstmt = (PreparedStatement) con.prepareStatement(queryString);
                              prepstmt.setString(1, "Вася");
                              prepstmt.executeUpdate();
                              prepstmt.close();
                      } catch (Exception e) {
                              System.err.println("Exception: " + e.getMessage());
                      }
              }
      }