这是我CODE,JDBC,ODBC封装在JAVABEAN里,应该没有问题,刚才发现,数据是更新了,但在库里是乱码,怎么办!
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import = "sbgl.execute"%>
<jsp:useBean id="execute" scope="session" class="sbgl.execute" />
<%!
public String getStr(String str)
{
try
{
String temp_p = str;
byte[] temp_t = temp_p.getBytes("GBK");
String temp = new String(temp_t,"ISO8859_1");
return temp;
}catch(Exception e)
{ }
return "null";
}
%>
<%
String mingc,guoj,yiqbh,xingh,changj,xissbh,jiszb,zhizh,fenlh,zuofbj;
String jingfkm,xiaodjh,beiz,chucrq,gouzrq,danj,zengjz;mingc=getStr(request.getParameter("text1"));
guoj=getStr(request.getParameter("text2"));
yiqbh=request.getParameter("text3");
xingh=request.getParameter("text4");
changj=request.getParameter("text5");
xissbh=request.getParameter("text6");
jiszb=request.getParameter("text7");
zhizh=request.getParameter("text8");
fenlh=request.getParameter("text9");
chucrq=request.getParameter("text10");
gouzrq=request.getParameter("text11");
jingfkm=request.getParameter("text12");
danj=request.getParameter("text13");
zengjz=request.getParameter("text14");
xiaodjh=request.getParameter("text15");
beiz=request.getParameter("text16");
zuofbj=request.getParameter("text17");String sql = "update tshebjbxx set cmingc = '"+mingc+"' where cyiqbh = '"+yiqbh+"'"; execute.executeUpdate(sql); out.println(sql);%>
<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%@ page import = "sbgl.execute"%>
<jsp:useBean id="execute" scope="session" class="sbgl.execute" />
<%!
public String getStr(String str)
{
try
{
String temp_p = str;
byte[] temp_t = temp_p.getBytes("GBK");
String temp = new String(temp_t,"ISO8859_1");
return temp;
}catch(Exception e)
{ }
return "null";
}
%>
<%
String mingc,guoj,yiqbh,xingh,changj,xissbh,jiszb,zhizh,fenlh,zuofbj;
String jingfkm,xiaodjh,beiz,chucrq,gouzrq,danj,zengjz;mingc=getStr(request.getParameter("text1"));
guoj=getStr(request.getParameter("text2"));
yiqbh=request.getParameter("text3");
xingh=request.getParameter("text4");
changj=request.getParameter("text5");
xissbh=request.getParameter("text6");
jiszb=request.getParameter("text7");
zhizh=request.getParameter("text8");
fenlh=request.getParameter("text9");
chucrq=request.getParameter("text10");
gouzrq=request.getParameter("text11");
jingfkm=request.getParameter("text12");
danj=request.getParameter("text13");
zengjz=request.getParameter("text14");
xiaodjh=request.getParameter("text15");
beiz=request.getParameter("text16");
zuofbj=request.getParameter("text17");String sql = "update tshebjbxx set cmingc = '"+mingc+"' where cyiqbh = '"+yiqbh+"'"; execute.executeUpdate(sql); out.println(sql);%>
解决方案 »
- 页面底部有一行联系人信息,如何支持修改功能但不存入数据库?
- 新手求救--关于TOMCAT 集成 SOAP 使用 远程调用的问题
- struts+hibernate整合老是解决不了的问题
- 急问一个字符串截取的问题!
- 请问一个在web.xml中关于servlet定义的问题
- 我知道这个问题很低级,但是我给的分多啊,跪求大哥们帮忙,20分必给
- 请教一下关于JSP标准动作<jsp:useBean>中class配置的问题
- 求spring MVC 使用treeiew,listview的示例代码
- JspStudy (JSP环境集成包) +phpStudy (php环境集成包) 求测试
- 在linux下jsp连接mysql的问题
- 昨天发现自己已经是三个三角了,呵呵,放分.
- 请问tomcat 能不能发布ejb.??知道就回答,谢谢!!
把sql里的字段长度设置长一些