mysql创建如下数据库：
create database ibatis;--创建数据库
use ibatis;--使用数据库,以下表在该数据库中
create table person(username varchar(20),password varchar(20));--创建person表
mysqlindex.jsp：
<%@ page contentType="text/html;charset=GB2312" %>
<html>
<body>
<form action="sqlregister.jsp" method="post">
username:<input type="text" name="name"/>
password:<input type="password" name="password"/>
<input type="submit" value="提交"/>
</form>
</body>
</html>
sqlregister.jsp：
<%@ page contentType="text/html;charser=GB2312" %>
<%@ page import="java.sql.*"%>
<body>
<center>
<%
request.setCharacterEncoding("GBK");
String uname=request.getParameter("name");
String pwd=request.getParameter("password");
String mysql=uname+","+pwd;
String sql="insert into person (usename,password) values("+mysql+")";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
%>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
conn=java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/ibatis?user=root&password=sa");
stmt=conn.createStatement();
stmt.execute(sql);
rs=stmt.executeQuery("select * from person");
if(rs!=null){
while(rs.next())
String username=rs.getString(1);
String password=rs.getString(2);
%>
<table>
<tr>
<td><%=username %></td>
<td><%=password %></td>
</tr>
</table>
<%
}
rs.close();
stmt.close();
conn.close();
%>
</center>
</body>
