mysql unexpected if_各位大神！！帮忙看看呗！谢谢myeclipse连接mysql 出现500：错误The server encountered an unexpected con...

利用PreparedStatement对象添加一条记录页面

String userName="root";

String userPwd="184896";

String dbName="students";

String url1="jdbc:mysql://localhost:3306/"+dbName;

String url2="?user="+userName+"&password="+userPwd;

String url3="&userUnicode=true&characterEncoding=UTF-8";

String url=url1+url2+url3;

Class.forName(driverName);

Connection conn=DriverManager.getConnection(url);

String sql="Insert into stu_info(id,name,sex,age,weight,height)values(?,?,?,?,?,?)";

PreparedStatement pstmt=conn.prepareStatement(sql);

pstmt.setInt(1,16);

pstmt.setString(2,"张三");

pstmt.setString(3,"男");

pstmt.setInt(4,20);

pstmt.setFloat(5,70);

pstmt.setFloat(6,175);

int n=pstmt.executeUpdate();

if(n==1){%>数据插入操作成功！

else{%>数据插入操作失败！

if(pstmt!=null){pstmt.close();}

if(conn!=null){conn.close();}%>