mysql 기본 셋팅이 됐음을 간주하고 설명.

1. jsp와 mysql과 통신할 user 생성

  /home>mysql -u root -p   -- mysql접속

  mysql> use mysql;            -- mysql db 접속

  mysql> insert into user (host,user,password,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,

reload_priv,shutdown_priv,process_priv,file_priv) values ('localhost','lora',password('lora'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');  -- 유저생성

  mysql> flush privileges;

2. 환경구성

    a. network 으로 접근시(Oracle로 따지면 thin Driver 역할이라 할수있습니다)

        mysql>grant all privileges on dbname.* to usr@'%' identified by 'passwd';

    b. local로 접근시

        mysql>grant all privileges on dbname.* to usr@localhost identified by 'passwd';

3. jsp 페이지 작성

----------------------------------------------------------------------------------------

<%@ page contentType="text/html; charset=euc-kr" %>
<%@ page import="java.sql.*" %>
<% 
Connection conn = null;       
Statement stmt = null; 
ResultSet rs = null;  
String dbURL = "jdbc:mysql://localhost/접속할디비명?autoReconnect=true&useUnicode=true&characterEncoding=euc-kr";
String dbUser = "유저아이디"; 
String dbPass = "유저패스워드";

try{  // JDBC 드라이버 로딩  
  Class.forName("org.gjt.mm.mysql.Driver");   
  conn = DriverManager.getConnection(dbURL, dbUser, dbPass); 
  stmt = conn.createStatement();  
  rs = stmt.executeQuery("Select * from MEMBER");  

  if(rs.next()){   
   out.print(rs.getString("name") + "&nbsp;&nbsp;");   

  } else {
   out.println("회원정보가 없습니다");
  }

 }catch(ClassNotFoundException e){  
   out.println("ClassNotFoundException");
  e.printStackTrace(); 
 }catch(SQLException e){  
  e.printStackTrace(); 
 }finally{  
  try{   
   if(conn != null){    
    conn.close();
   }  
  }catch(Exception e){   
   e.printStackTrace();  
  } 
 }
%>

----------------------------------------------------------------------------------------

웹브라우저에 확인