<%
Class.forName("com.mysql.jdbc.Driver").newInstance();
String dsn="jdbc:mysql://localhost:3306/test_db?user=root&password=sa";
Connection conn=DriverManager.getConnection(dsn);
Statement cmd=conn.createStatement();
//新增数据
String sql = "select max(id) as num from employee";
ResultSet numRs = cmd.executeQuery(sql);
numRs.next();
int id = numRs.getInt(1) + 1;
request.setCharacterEncoding("GB2312");
String last_name = request.getParameter("last_name");
String first_name = request.getParameter("first_name");
out.println(last_name + "--" + first_name);
sql = "insert into employee(id,last_name,first_name,birth,sex,email) values(?,?,?,?,?,?)";
PreparedStatement stmt = conn.prepareStatement(sql);
stmt.setInt(1,id);
stmt.setString(2,last_name);
stmt.setString(3,first_name);
stmt.setString(4,"1982-11-16");
stmt.setString(5,"M");
stmt.setString(6,"liucy@qq.com.cn");
stmt.executeUpdate();
//cmd.executeUpdate(sql);
//查询数据
ResultSet rs=cmd.executeQuery("select * from employee");
while(rs.next())
{
out.println(rs.getString(1) + "--" + rs.getString(2) + "--" + rs.getString(3)+ "--" + rs.getString(4)+ "--" + rs.getString(5)+ "--" + rs.getString(6));
out.println("<br/>");
}
cmd.close();
rs.close();
conn.close();
%>
连接不加参数&useUnicode=True&characterEncoding=GB2312,数据库写入中文,加入参数写入乱码。