沒想到連個資料庫這麼難搞，在KEY了一堆程式碼以後，終於終於可以成功的把最陽春版的寫出來了，我要把這些程式碼搞懂= ˇ = ，這樣我的程式功力一定就可以再度的提升不少
<%@ page language="java" contentType="text/html; charset=BIG5" pageEncoding="BIG5"%>
<%@ page import ="java.sql.*" %>
<html>
<head>
<meXXXXXta http-equiv="Content-Type" content="text/html; charset=BIG5">
<title>MySQL.jsp</title>
</head>
<body>
<h2>將資料寫入MySQL</h2>
<%
Connection con = null; //java.sql.Connection
Statement stmt = null; //java.sql.Statement
Statement stmt1= null; //java.sql.statement
ResultSet rs = null; //java.sql.ResultSet;
request.setCharacterEncoding("Big5");
String employee_id = null;
String last_name = request.getParameter("last_name");
String first_name = request.getParameter("first_name");
String birth = "1978/12/11";
String sex= "F";
String email="aaa@asdf.com";
String new_last_name="";
String new_first_name="";
%>
從mysql.html接收到的資料如下:<br>
姓:<%=last_name %>
名:<%=first_name %><br><br>
<%
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/sample_db?user=root&password=XXXXXX&useUnicode=true&characterEncoding=Big5");
stmt = con.createStatement();
String upd ="Insert into employee(employee_id,last_name,first_name,"+"birth,sex,email)values("+employee_id+",'"+last_name+"','"+first_name+"','"+birth+"','"+sex+"','"+email+"')";
stmt.executeUpdate(upd);
stmt1 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String query = "select * from employee";
rs = stmt1.executeQuery(query);
rs.last();
new_last_name=rs.getString("last_name");
new_first_name=rs.getString("first_name");
stmt.close();
stmt1.close();
con.close();
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
finally
{
try
{
if(con!=null)
{
con.close();
}
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
}
%>
從employee取出最新新增的姓名:<br>
新增姓名:<%=new_last_name + new_first_name %><br>
</body>
</html>
