jsp mysql insert失败_异常处理：jsp页面向mysql插入数据。求各位看看哪里出错！！！...

这是我的代码：

登陆操作

---

这是我的代码：

登陆操作

---

public static final String DBDRIVER = "org.gjt.mm.mysql.Driver" ;

public static final String DBURL = "jdbc:mysql://localhost:3306/web" ;

public static final String DBUSER = "root" ;

public static final String DBPASS = "000000" ;

%>

Connection conn = null ;// 数据库连接

Statement stmt = null ;// 数据库预处理操作

%>

String houseid=request.getParameter("houseid");//内置对象

String keeperid=request.getParameter("keeperid");

int housesize=Integer.parseInt(request.getParameter("housesize"));

int firstyear=Integer.parseInt(request.getParameter("firstyear"));

String picture=request.getParameter("picture");

System.out.println("iiiii");

%>

try{

%>

Class.forName(DBDRIVER) ;

conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS) ;

String sql="insert into house (houseid,keeperid,housesize,firstyear) values ('"+houseid+"','"+keeperid+"',"+housesize+","+firstyear+",'"+picture+"')";

stmt=conn.createStatement();

int i = stmt.executeUpdate(sql);

if(i>0){

%>

;

}else{

%>

}

%>

}catch(Exception e){

e.printStackTrace() ;

}

finally{

try{

stmt.close() ;

conn.close() ;

} catch(Exception e){}

}

%>

报错：

org.apache.jasper.JasperException: /update.jsp(42,44) Expecting "jsp:param" standard action with "name" and "value" attributes

展开