📄 createtableservlet.java

📁 J2ME MIDP_Example_Applications
💻 JAVA
字号:
// Copyright 2003 Nokia Corporation.
//
// THIS SOURCE CODE IS PROVIDED 'AS IS', WITH NO WARRANTIES WHATSOEVER,
// EXPRESS OR IMPLIED, INCLUDING ANY WARRANTY OF MERCHANTABILITY, FITNESS
// FOR ANY PARTICULAR PURPOSE, OR ARISING FROM A COURSE OF DEALING, USAGE
// OR TRADE PRACTICE, RELATING TO THE SOURCE CODE OR ANY WARRANTY OTHERWISE
// ARISING OUT OF ANY PROPOSAL, SPECIFICATION, OR SAMPLE AND WITH NO
// OBLIGATION OF NOKIA TO PROVIDE THE LICENSEE WITH ANY MAINTENANCE OR
// SUPPORT. FURTHERMORE, NOKIA MAKES NO WARRANTY THAT EXERCISE OF THE
// RIGHTS GRANTED HEREUNDER DOES NOT INFRINGE OR MAY NOT CAUSE INFRINGEMENT
// OF ANY PATENT OR OTHER INTELLECTUAL PROPERTY RIGHTS OWNED OR CONTROLLED
// BY THIRD PARTIES
//
// Furthermore, information provided in this source code is preliminary,
// and may be changed substantially prior to final release. Nokia Corporation
// retains the right to make changes to this source code at
// any time, without notice. This source code is provided for informational
// purposes only.
//
// Nokia and Nokia Connecting People are registered trademarks of Nokia
// Corporation.
// Java and all Java-based marks are trademarks or registered trademarks of
// Sun Microsystems, Inc.
// Other product and company names mentioned herein may be trademarks or
// trade names of their respective owners.
//
// A non-exclusive, non-transferable, worldwide, limited license is hereby
// granted to the Licensee to download, print, reproduce and modify the
// source code. The licensee has the right to market, sell, distribute and
// make available the source code in original or modified form only when
// incorporated into the programs developed by the Licensee. No other
// license, express or implied, by estoppel or otherwise, to any other
// intellectual property rights is granted herein.
package databaseproxy;

import java.io.*;
import java.net.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class CreateTableServlet
  extends HttpServlet
{
  String jdbcDriver = null;
  String jdbcUrl = null;
  String jdbcUsername = null;
  String jdbcPassword = null;


  public void init()
  {
    jdbcDriver = getInitParameter("jdbc.driver");
    jdbcUrl = getInitParameter("jdbc.url");
    jdbcUsername = getInitParameter("jdbc.username");
    jdbcPassword = getInitParameter("jdbc.password");
    Connection c = null;
    if (jdbcDriver != null)
    {
      try
      {
        Class driverClass = Class.forName(jdbcDriver);
        if (driverClass.isAssignableFrom(Driver.class))
        {
          DriverManager.registerDriver((Driver)driverClass.newInstance());
        }
      }
      catch (ClassNotFoundException e)
      {
        System.err.println("Driver " + jdbcDriver +
                           " not found ");
      }
      catch (ClassCastException e)
      {
        System.err.println("Driver class " + jdbcDriver +
                           " not a valid driver ");
      }
      catch (InstantiationException e)
      {
        System.err.println("Driver class " + jdbcDriver +
                           " could not be created ");
      }
      catch (IllegalAccessException e)
      {
        System.err.println("Driver class " + jdbcDriver +
                           " could not be created ");
      }
      catch (SQLException e)
      {
        System.err.println("Exception when initializing driver "
                           + e.getMessage());
      }
    }
  }


  protected void doPost(HttpServletRequest req,
                        HttpServletResponse resp)
    throws ServletException, java.io.IOException
  {
    ServletOutputStream out = resp.getOutputStream();
    resp.setContentType("text/html");
    out.println("<HTML><BODY>");
    try {
      // Try to create a sample table
      Connection c = DriverManager.getConnection(jdbcUrl,
        jdbcUsername,
        jdbcPassword);
      Statement s = c.createStatement();
      s.execute("create table user(familyname VARCHAR, " +
        "firstname VARCHAR, phonenumber VARCHAR, " +
        "email VARCHAR, age INTEGER)");
      s.close();
      s = c.createStatement();
      s.execute("insert into user values('smith', 'john'," +
        "'+2945950342', 'john.smith@ahost.com', 25)");
      s.close();
      s = c.createStatement();
      s.execute("insert into user values('perez', 'juan'," +
        "'+2345456502'," +
        " 'juan.perez@ahost2.com', 22)");
      s.close();
      s = c.createStatement();
      s.execute("insert into user values('nevalainen', " +
        "'antti', '+3453653245'," +
        "'antti.nevalainen@ahost3.com', 35)");
      s.close();
      c.close();
      out.println("<p>Table user created and populated</p>");
    } catch (SQLException e) {
      out.println("<p>An exception ocurred " + e.getMessage() + "</p>");
      e.printStackTrace(new PrintStream(out));
    }

    out.println("</BODY></HTML>");
    out.flush();
  }

}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -