stmt.executeUpdate(strSQL);出现如下错误:
unroported exception java.sql.SQLException; must be cauch or declared to be thrown<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="lixuedeng.ISOtoGb2312"%>
<%@ page import = "java.sql.*"%>
<%@ page language="java"%>
<%@ include file="con_h.jsp"%><html>
<head>
<title>添加处理</title>
</head><body bgcolor="#ffffff"><%String strSQL;
//添加处理
strSQL = "INSERT INTO stu(username,userpassword,reuserpassword,usersex,useryear,usermonth,userday,useremail,useraddress) "
+ " values ('" +
ISOtoGb2312.convert(request.getParameter("addusername")) + "','" +
ISOtoGb2312.convert(request.getParameter("adduserpassword")) + "','" +
ISOtoGb2312.convert(request.getParameter("addreuserpassword")) + "','" +
ISOtoGb2312.convert(request.getParameter("addusersex")) + "','" +
ISOtoGb2312.convert(request.getParameter("adduseryear")) + "','" +
ISOtoGb2312.convert(request.getParameter("addusermonth")) + "','" +
ISOtoGb2312.convert(request.getParameter("adduserday")) + "','" +
ISOtoGb2312.convert(request.getParameter("adduseremail")) + "','" +
ISOtoGb2312.convert(request.getParameter("adduseraddress")) + "')";stmt.executeUpdate(strSQL);response.sendRedirect("03.jsp");//跳转语句
%></body>
</html>[con_h.jsp:]<%@ page import="java.sql.*" %>
<%!
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
public void jspInit()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:stu"); stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY); }
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
public void jspDestroy()
{
try
{
stmt.close();
con.close();
rs.close();
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
%>
unroported exception java.sql.SQLException; must be cauch or declared to be thrown<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="lixuedeng.ISOtoGb2312"%>
<%@ page import = "java.sql.*"%>
<%@ page language="java"%>
<%@ include file="con_h.jsp"%><html>
<head>
<title>添加处理</title>
</head><body bgcolor="#ffffff"><%String strSQL;
//添加处理
strSQL = "INSERT INTO stu(username,userpassword,reuserpassword,usersex,useryear,usermonth,userday,useremail,useraddress) "
+ " values ('" +
ISOtoGb2312.convert(request.getParameter("addusername")) + "','" +
ISOtoGb2312.convert(request.getParameter("adduserpassword")) + "','" +
ISOtoGb2312.convert(request.getParameter("addreuserpassword")) + "','" +
ISOtoGb2312.convert(request.getParameter("addusersex")) + "','" +
ISOtoGb2312.convert(request.getParameter("adduseryear")) + "','" +
ISOtoGb2312.convert(request.getParameter("addusermonth")) + "','" +
ISOtoGb2312.convert(request.getParameter("adduserday")) + "','" +
ISOtoGb2312.convert(request.getParameter("adduseremail")) + "','" +
ISOtoGb2312.convert(request.getParameter("adduseraddress")) + "')";stmt.executeUpdate(strSQL);response.sendRedirect("03.jsp");//跳转语句
%></body>
</html>[con_h.jsp:]<%@ page import="java.sql.*" %>
<%!
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
public void jspInit()
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); con = DriverManager.getConnection("jdbc:odbc:stu"); stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY); }
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
public void jspDestroy()
{
try
{
stmt.close();
con.close();
rs.close();
}
catch(Exception ex)
{
System.out.println(ex.toString());
}
}
%>
解决方案 »
- 一个观念上的问题
- 对HTML代码解析的问题
- myEclipse 中写的JSP页面运行后报出---注册连接出现错误:[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 'sa' 登录失败。原因: 未与信任 SQL Server 连接相关联。
- 关于hibernate?获取bean的方法
- 用jasperreport做报表时,如何将形成的pdf文件另存?
- javamail的问题
- 什么错误?
- ★大量JSP源代码高速下载!大量JSP技术文档在线查询!JSP程序员的好帮手!欢迎光临★www.csdn.com.cn再次改版
- JS能不能在客户端里开一个监听端口,让服务器主动连???
- 关于javabean的简单问题
- 是否可以不学标签???
- 送分啦~~快点。。呵呵!!~
stmt.executeUpdate(strSQL);
}catch(SQLException sqle){
sqle.pringStackTrace();
}你的错误应该是个编译错误吧?
stmt.executeUpdate(strSQL);
} catch(SQLException sqlExp) {
//to do something
}