<%@ page import="java.sql.*" %>

<%
String DB_URL = "jdbc:mysql://localhost/test";
String DB_USER = "";
String DB_PASSWORD= "";

Connection conn;
Statement stmt;

String query = "insert into createtest values('kenu', '017-111-1111')";
// name varchar(10), tel varchar(15)

// try {
Class.forName("org.gjt.mm.mysql.Driver");

conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);

stmt = conn.createStatement();

stmt.executeUpdate(query);

conn.commit();

out.println("data inserted!!");

stmt.close();

conn.close();

// } catch(Exception e){e.printStackTrace();}
%>