//package 생략
//import 생략
public class Main {

public static void main(String[] args){
String name=request.getParameter("name");

try{
String jdbcDriver = "jdbc:mysql://localhost";
String dbuser = "dbuser";
String dbpw = "pw";
conn = DriverManager.getConnection(jdbcDriver, dbuser,dbpw);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select count(*) as cnt from member where name='"+name+"'");
}catch(SQLException ex){

}

}

protected void doGet(HttpServletRequest request, HttpServletResponse){
printWriter.println("<!document>");
printWriter.println("<html>");
printWriter.println("<head>");
printWriter.println("<head>");
printWriter.println("<body>");
printWriter.println("<div>");
printWriter.println(" <p>");
printWriter.println("동명이인"+(rs.getString("cnt")) + "명");
printWriter.println(" </p>");
printWriter.println("</div>");
printWriter.println("<!document>");
printWriter.println("</body>");
printWriter.println("</html>");
}
}


웹을 굴리기 위한 자바서블릿


<?php
include_once('dbinfo.php');
$name = $_REQUEST['name'];
$executeQuery = "select count(*) as cnt from member where name = ${name}";
$conn = mysqli_connect($host, $dbid, $dbpw, $dbname);
$stmt = mysqli_query($conn, $executeQuery);
$result = mysqli_fetch_assoc($stmt);
$cnt = $result['cnt'];

?>
<!DOCTYPE html>
<html>
<head>
</head>
<body>
<div>
<p>
동명이인 <?php $cnt ?> 명
</p>
</div>
</body>
</html>


요즘 누가 자바서블릿을 바로 쓰냐

다들 프레임워크 쓰지



근데 쉬워서 문제였던php

저 시절에 머무른 php 아조씨들 많음

프레임워크좀 쓰자..