JSP連結mysql @ 鏡花水月-什麼是真?什麼是假?

今天來記錄一下JSP如何連接mysql

首先，先下載spring-jdbc.jar 和mysql-connector.jar

若沒這2個jar檔，即使程式寫好也會錯誤..

以下附上下載網址:

spring-jdbc.jar: http://www.java2s.com/Code/Jar/s/Downloadspringjdbc324releasejar.htm

mysql-connector.jar: http://www.java2s.com/Code/Jar/m/Downloadmysqlconnectorjar.htm

接下來，開始寫程式囉

以下是db.jsp，負責單純連接mysql

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%> 
    <%! 
        String user = "root"; 
        String pass = "12345"; 
        String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8"; 
        Connection conn; 
        Statement stmt; 
    %> 
    <% 
        try{ 
            Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
                conn = DriverManager.getConnection(url,user,pass); 
               stmt = conn.createStatement();
                    
        }catch(SQLException sqlex){ 
            out.println("SQL Exception : " + sqlex); 
        } 
    %>

連結成功後，就可以新增資料到mysql了

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ include file = "db.jsp"%> 
<!DOCTYPE HTML>
<html>
<head> 
<title>JSP connect mysql</title> 
  <%
    if(request.getParameter("register") != null){
      String company = request.getParameter("company"); 
      String mail = request.getParameter("mail"); 
      String sql = "insert into log_in (company,mail)"
       + " values ('" + company + "','" +mail +"')"; 
            int a = stmt.executeUpdate(sql); 
             } 
  %>
        </head> 
        <body>
             <div class="container" > 
            <form action = "register.jsp" method = "post"> 
           company:<input type="text" id="company"  name="company">
             email:<input type="text" id="mail"  name="mail">  
         <button type="submit" name = "register" value = "signup">OK</button>
            </form> 
                </div>
        </body> 
    </html>