jsp tomcat sql 연동

<%
 String DB_URL = "jdbc:mysql://localhost/testdb";
 String DB_USER = "root";
 String DB_PASSWORD = "1111";
 Connection conn;
 Statement stmt;
 String query = "SELECT * FROM brain";
 ResultSet rs = null;
 try {
  Class.forName("org.gjt.mm.mysql.Driver");
  conn = DriverManager
    .getConnection(DB_URL, DB_USER, DB_PASSWORD);
  stmt = conn.createStatement();
  rs = stmt.executeQuery(query);
  while (rs.next()) {
   out.println("name : " + rs.getString("name"));
  }

  rs.close();
  conn.close();
  stmt.close();
  out.println("mysql jdbc test : connection ok!!");
 } catch (Exception e) {
  out.println("실패" + e.getMessage());
 }
%>


우홍홍 성공.
이제 컨트롤러로~ ㅋㅋ