我用insert into 语句插入,并用select语句查询却发现这样的乱码:
[B@3e5a91
[B@1991de1
[B@a1d7b
[B@b113c7
[B@e391c4
源码是这样的:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/first?user=root&password=123&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="insert into about(name) values('"+request.getParameter("content1").getBytes("iso-8859-1")+"')";
stmt.executeUpdate(query);
String query1="select * from about";
ResultSet rs1=stmt.executeQuery(query1);
while(rs1.next())
{
String s=rs1.getString(1);//不知是不是这里的问题?out.print(s+"<br>");
}
[B@3e5a91
[B@1991de1
[B@a1d7b
[B@b113c7
[B@e391c4
源码是这样的:
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/first?user=root&password=123&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="insert into about(name) values('"+request.getParameter("content1").getBytes("iso-8859-1")+"')";
stmt.executeUpdate(query);
String query1="select * from about";
ResultSet rs1=stmt.executeQuery(query1);
while(rs1.next())
{
String s=rs1.getString(1);//不知是不是这里的问题?out.print(s+"<br>");
}
解决方案 »
- 小弟和同学的作品大家给评价评价 《交警移动警务》-awaken团队 济南职业学院 2012齐鲁软件设计大赛作品,http://v.youku.com/v_sh
- 自认为还行的 请进来!!!!! 麻烦帮忙看看这个问题 很急!!
- tomcat中的路径怎么回事啊
- 谁有MYSQL+TOMCAT+JSP+SERVLET的试用或免费服务器
- java里如何用asc码的16 进制 数表示一个字符
- 紧急求救,jsp页面中,Bean中为什么子类不能调用父类的方法??
- tomcat5.0.14怎样建立jsp工作的虚拟目录
- [求助]大家帮我看看这个异常是怎么回事啊
- 如何一次性清除SELECT中的所有OPTION
- 用RESIN做服务, 会出现有些表格背景不能显示的问题,请问这个如何解决?
- 重新载入的问题
- 重新载入的问题
javax.servlet.ServletException: Incorrect string value: '\xB1\xBE\xD1\xF9\xCA\xBD...' for column 'name' at row 1
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:498)
at org.apache.jsp.submit_jsp._jspService(submit_jsp.java:77)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:92)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:162)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:240)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:200)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:146)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:144)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2358)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:133)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:594)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:127)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:596)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:433)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:948)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)