org.apache.jasper.JasperException: An exception occurred processing JSP page /test_utf8.jsp at line 118: String url="jdbc:mysql://localhost/cass";
9: Connection conn=DriverManager.getConnection(url,"root","");
10: Statement stmt = conn.createStatement();
11: stmt.executeQuery("insert into sys_radi values(111, 23, 'abc'");
12: String sqlstr="select * from sys_radi";
13: ResultSet rs= stmt.executeQuery(sqlstr);
14:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)顺便说下,我的MySQL数据库用utf8编码,JSP网页本身也用UTF8编码存储。insert错误是否与此有关?应该怎么才能顺利插入数据呢?
9: Connection conn=DriverManager.getConnection(url,"root","");
10: Statement stmt = conn.createStatement();
11: stmt.executeQuery("insert into sys_radi values(111, 23, 'abc'");
12: String sqlstr="select * from sys_radi";
13: ResultSet rs= stmt.executeQuery(sqlstr);
14:
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)顺便说下,我的MySQL数据库用utf8编码,JSP网页本身也用UTF8编码存储。insert错误是否与此有关?应该怎么才能顺利插入数据呢?
解决方案 »
- jsp菜鸟求教数据库查询问题!
- 请教javascript从新读取页面时的问题
- 游标在JSP中应用
- 实现一个简易的的短信平台功能,请指教!
- 怎样设置邮件的群发.望大家给点建议(对邮件发送有所认识的人请进!)
- No action instance for path /login could be created?
- 如果用户误操作,怎么把提示语言放在本页
- 什么是上帝类啊?
- 百度社会化第三方登录的问题
- Myeclipse中SSH中Cannot resolve reference to bean 'sessionFactory' while setting be
- 这个链接数据库失败的错误信息?
- lib与standard怎么加载
stmt.executeUpdate("insert into sys_radi values(111, 23, 'abc'");
stmt.executeUpdate("insert into sys_radi values(111, 23, 'abc')");
改用batchExecute(先addbatch)或executeUpdate都可以。
mysql> create database cass DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> use cass;
mysql> create table sys_radi(ID int not null, bsbh int not null, bschar varchar(20) not null);
我的JSP网页内容如下:<%@ page contentType="text/html; charset=UTF-8" %>
<%@ page import="java.lang.*, java.io.*, java.sql.*, java.util.* "%>
<%request.setCharacterEncoding("UTF-8");%>
<html>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/cass";
Connection conn=DriverManager.getConnection(url,"root","");
Statement stmt = conn.createStatement();
stmt.executeUpdate("insert into sys_radi values(111, 23, 'abc')");
String sqlstr="select * from sys_radi";
ResultSet rs= stmt.executeQuery(sqlstr);while(rs.next()){
out.println(rs.getString(1));
out.println(" ");
out.println(rs.getString(2));
out.println(" ");
out.println(rs.getString(3));
out.println("<br>");
}
out.println("<br>");
out.print("恭喜~! 打开数据库操作成功!");
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
请高手看看为什么insert不出错了但还是没能够插入数据成功。我下一步应该怎么样修改代码呢?
stmt.executeUpdate("insert into sys_radi values(111, 23, 'abc')");
语句来插入了一条记录。
但是就是插入不到数据库中。