为什么插入不了中文

zjxt1010 2004-11-12 05:03:36
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../../Connections/ok.jsp" %>
<%
// *** Edit Operations: declare variables

// set the form action variable
String MM_editAction = request.getRequestURI();
if (request.getQueryString() != null && request.getQueryString().length() > 0) {
String queryString = request.getQueryString();
String tempStr = "";
for (int i=0; i < queryString.length(); i++) {
if (queryString.charAt(i) == '<') tempStr = tempStr + "<";
else if (queryString.charAt(i) == '>') tempStr = tempStr + ">";
else if (queryString.charAt(i) == '"') tempStr = tempStr + """;
else tempStr = tempStr + queryString.charAt(i);
}
MM_editAction += "?" + tempStr;
}

// connection information
String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null;

// redirect information
String MM_editRedirectUrl = null;

// query string to execute
StringBuffer MM_editQuery = null;

// boolean to abort record edit
boolean MM_abortEdit = false;

// table information
String MM_editTable = null, MM_editColumn = null, MM_recordId = null;

// form field information
String[] MM_fields = null, MM_columns = null;
%>
<%
// *** Insert Record: set variables

if (request.getParameter("MM_insert") != null && request.getParameter("MM_insert").toString().equals("form1")) {

MM_editDriver = MM_ok_DRIVER;
MM_editConnection = MM_ok_STRING;
MM_editUserName = MM_ok_USERNAME;
MM_editPassword = MM_ok_PASSWORD;
MM_editTable = "dbo.guanleming";
MM_editRedirectUrl = "succe.jsp";
String MM_fieldsStr = "textfield|value|textfield2|value|textfield3|value|textfield4|value|textfield5|value|textfield6|value";
String MM_columnsStr = "liebie|',none,''|num|',none,''|col|',none,''|danwei|',none,''|price|none,none,NULL|imfo|',none,''";

// create the MM_fields and MM_columns arrays
java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_fieldsStr,"|");
MM_fields = new String[tokens.countTokens()];
for (int i=0; tokens.hasMoreTokens(); i++) MM_fields[i] = tokens.nextToken();

tokens = new java.util.StringTokenizer(MM_columnsStr,"|");
MM_columns = new String[tokens.countTokens()];
for (int i=0; tokens.hasMoreTokens(); i++) MM_columns[i] = tokens.nextToken();

// set the form values
for (int i=0; i+1 < MM_fields.length; i+=2) {
MM_fields[i+1] = ((request.getParameter(MM_fields[i])!=null)?(String)request.getParameter(MM_fields[i]):"");
}

// append the query string to the redirect URL
if (MM_editRedirectUrl.length() != 0 && request.getQueryString() != null) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + request.getQueryString();
}
}
%>
<%
// *** Insert Record: construct a sql insert statement and execute it

if (request.getParameter("MM_insert") != null) {

// create the insert sql statement
StringBuffer MM_tableValues = new StringBuffer(), MM_dbValues = new StringBuffer();
for (int i=0; i+1 < MM_fields.length; i+=2) {
String formVal = MM_fields[i+1];
String elem;
java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_columns[i+1],",");
String delim = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
String altVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
String emptyVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
if (formVal.length() == 0) {
formVal = emptyVal;
} else {
if (altVal.length() != 0) {
formVal = altVal;
} else if (delim.compareTo("'") == 0) { // escape quotes
StringBuffer escQuotes = new StringBuffer(formVal);
for (int j=0; j < escQuotes.length(); j++)
if (escQuotes.charAt(j) == '\'') escQuotes.insert(j++,'\'');
formVal = "'" + escQuotes + "'";
} else {
formVal = delim + formVal + delim;
}
}
MM_tableValues.append((i!=0)?",":"").append(MM_columns[i]);
MM_dbValues.append((i!=0)?",":"").append(formVal);
}
MM_editQuery = new StringBuffer("insert into " + MM_editTable);
MM_editQuery.append(" (").append(MM_tableValues.toString()).append(") values (");
MM_editQuery.append(MM_dbValues.toString()).append(")");

if (!MM_abortEdit) {
// finish the sql and execute it
Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance();
Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword);
PreparedStatement MM_editStatement = MM_connection.prepareStatement(MM_editQuery.toString());
MM_editStatement.executeUpdate();
MM_connection.close();

// redirect with URL parameters
if (MM_editRedirectUrl.length() != 0) {
response.sendRedirect(response.encodeRedirectURL(MM_editRedirectUrl));
return;
}
}
}
%>
<%
Driver DriverRecordset1 = (Driver)Class.forName(MM_ok_DRIVER).newInstance();
Connection ConnRecordset1 = DriverManager.getConnection(MM_ok_STRING,MM_ok_USERNAME,MM_ok_PASSWORD);
PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM dbo.guanleming");
ResultSet Recordset1 = StatementRecordset1.executeQuery();
boolean Recordset1_isEmpty = !Recordset1.next();
boolean Recordset1_hasData = !Recordset1_isEmpty;
Object Recordset1_data;
int Recordset1_numRows = 0;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
color: #FFFFFF;
font-weight: bold;
}
.style1 { color: #FFFFFF;
font-weight: bold;
}
-->
</style></head>

<body>
<form name="form1" method="POST" action="<%=MM_editAction%>">
<table width="83%" border="0" align="center">
<tr>
<td bgcolor="#0099FF"><span class="style1">产品添加 </span>>> 关靳铭有限公司 </td>
</tr>
</table>
<table width="83%" border="0" align="center">
<tr>
<td bgcolor="#0099FF"> </td>
</tr>
</table>
<table width="83%" border="0" align="center" bgcolor="#0099FF">
<tr>
<td width="25%">类别</td>
<td width="75%"><input type="text" name="textfield"></td>
</tr>
<tr>
<td>产品代号</td>
<td><input type="text" name="textfield2"></td>
</tr>
<tr>
<td>产品名</td>
<td><input type="text" name="textfield3"></td>
</tr>
<tr>
<td>价格</td>
<td><input type="text" name="textfield4"></td>
</tr>
<tr>
<td>型号</td>
<td><input type="text" name="textfield5"></td>
</tr>
<tr>
<td>功能</td>
<td><input type="text" name="textfield6"></td>
</tr>
</table>
<table width="83%" border="0" align="center" bgcolor="#0099FF">
<tr>
<td> </td>
</tr>
<tr>
<td><div align="center">
<input type="submit" name="Submit" value="提交">    
<input type="reset" name="Submit2" value="重置">
</div></td>
</tr>
</table>

<input type="hidden" name="MM_insert" value="form1">
</form>
</body>
</html>
<%
Recordset1.close();
StatementRecordset1.close();
ConnRecordset1.close();
%>
...全文
147 13 打赏 收藏 转发到动态 举报
写回复
用AI写文章
13 条回复
切换为时间正序
请发表友善的回复…
发表回复
moke33 2004-11-12
  • 打赏
  • 举报
 回复
加入一个filter即可，详情参看类似情况：
http://moke.blogchina.com/blog/article_48326.251664.html
cqlym 2004-11-12
  • 打赏
  • 举报
 回复
我晕，这也太长了吧！！

楼主，你写精简点，谁看的完呀。
yangsm 2004-11-12
  • 打赏
  • 举报
 回复
太长了！
chenjiabopi 2004-11-12
  • 打赏
  • 举报
 回复
<%@ page contentType="text/html; charset=gb2312"%>
加上这个就行了
zjxt1010 2004-11-12
  • 打赏
  • 举报
 回复
import="java.sql.*" errorPage="" %>
<%@ include file="../../Connections/ok.jsp" %>
<%
// *** Edit Operations: declare variables

// set the form action variable
String MM_editAction = request.getRequestURI();
if (request.getQueryString() != null && request.getQueryString().length() > 0) {
String queryString = request.getQueryString();
String tempStr = "";
for (int i=0; i < queryString.length(); i++) {
if (queryString.charAt(i) == '<') tempStr = tempStr + "<";
else if (queryString.charAt(i) == '>') tempStr = tempStr + ">";
else if (queryString.charAt(i) == '"') tempStr = tempStr + """;
else tempStr = tempStr + queryString.charAt(i);
}
MM_editAction += "?" + tempStr;
}

// connection information
String MM_editDriver = null, MM_editConnection = null, MM_editUserName = null, MM_editPassword = null;

// redirect information
String MM_editRedirectUrl = null;

// query string to execute
StringBuffer MM_editQuery = null;

// boolean to abort record edit
boolean MM_abortEdit = false;

// table information
String MM_editTable = null, MM_editColumn = null, MM_recordId = null;

// form field information
String[] MM_fields = null, MM_columns = null;
%>
<%
// *** Insert Record: set variables

if (request.getParameter("MM_insert") != null && request.getParameter("MM_insert").toString().equals("form1")) {

MM_editDriver = MM_ok_DRIVER;
MM_editConnection = MM_ok_STRING;
MM_editUserName = MM_ok_USERNAME;
MM_editPassword = MM_ok_PASSWORD;
MM_editTable = "dbo.guanleming";
MM_editRedirectUrl = "succe.jsp";
String MM_fieldsStr = "textfield|value|textfield2|value|textfield3|value|textfield4|value|textfield5|value|textfield6|value";
String MM_columnsStr = "liebie|',none,''|num|',none,''|col|',none,''|danwei|',none,''|price|none,none,NULL|imfo|',none,''";

// create the MM_fields and MM_columns arrays
java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_fieldsStr,"|");
MM_fields = new String[tokens.countTokens()];
for (int i=0; tokens.hasMoreTokens(); i++) MM_fields[i] = tokens.nextToken();

tokens = new java.util.StringTokenizer(MM_columnsStr,"|");
MM_columns = new String[tokens.countTokens()];
for (int i=0; tokens.hasMoreTokens(); i++) MM_columns[i] = tokens.nextToken();

// set the form values
for (int i=0; i+1 < MM_fields.length; i+=2) {
MM_fields[i+1] = ((request.getParameter(MM_fields[i])!=null)?(String)request.getParameter(MM_fields[i]):"");
}

// append the query string to the redirect URL
if (MM_editRedirectUrl.length() != 0 && request.getQueryString() != null) {
MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + request.getQueryString();
}
}
%>
<%
// *** Insert Record: construct a sql insert statement and execute it

if (request.getParameter("MM_insert") != null) {

// create the insert sql statement
StringBuffer MM_tableValues = new StringBuffer(), MM_dbValues = new StringBuffer();
for (int i=0; i+1 < MM_fields.length; i+=2) {
String formVal = MM_fields[i+1];
String elem;
java.util.StringTokenizer tokens = new java.util.StringTokenizer(MM_columns[i+1],",");
String delim = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
String altVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
String emptyVal = ((elem = (String)tokens.nextToken()) != null && elem.compareTo("none")!=0)?elem:"";
if (formVal.length() == 0) {
formVal = emptyVal;
} else {
if (altVal.length() != 0) {
formVal = altVal;
} else if (delim.compareTo("'") == 0) { // escape quotes
StringBuffer escQuotes = new StringBuffer(formVal);
for (int j=0; j < escQuotes.length(); j++)
if (escQuotes.charAt(j) == '\'') escQuotes.insert(j++,'\'');
formVal = "'" + escQuotes + "'";
} else {
formVal = delim + formVal + delim;
}
}
MM_tableValues.append((i!=0)?",":"").append(MM_columns[i]);
MM_dbValues.append((i!=0)?",":"").append(formVal);
}
MM_editQuery = new StringBuffer("insert into " + MM_editTable);
MM_editQuery.append(" (").append(MM_tableValues.toString()).append(") values (");
MM_editQuery.append(MM_dbValues.toString()).append(")");

if (!MM_abortEdit) {
// finish the sql and execute it
Driver MM_driver = (Driver)Class.forName(MM_editDriver).newInstance();
Connection MM_connection = DriverManager.getConnection(MM_editConnection,MM_editUserName,MM_editPassword);
PreparedStatement MM_editStatement = MM_connection.prepareStatement(MM_editQuery.toString());
MM_editStatement.executeUpdate();
MM_connection.close();

// redirect with URL parameters
if (MM_editRedirectUrl.length() != 0) {
response.sendRedirect(response.encodeRedirectURL(MM_editRedirectUrl));
return;
}
}
}
%>
<%
Driver DriverRecordset1 = (Driver)Class.forName(MM_ok_DRIVER).newInstance();
Connection ConnRecordset1 = DriverManager.getConnection(MM_ok_STRING,MM_ok_USERNAME,MM_ok_PASSWORD);
PreparedStatement StatementRecordset1 = ConnRecordset1.prepareStatement("SELECT * FROM dbo.guanleming");
ResultSet Recordset1 = StatementRecordset1.executeQuery();
boolean Recordset1_isEmpty = !Recordset1.next();
boolean Recordset1_hasData = !Recordset1_isEmpty;
Object Recordset1_data;
int Recordset1_numRows = 0;
%>
zjxt1010 2004-11-12
  • 打赏
  • 举报
 回复
英文的好使呀
数字好使,中文不好使,是不是这个DW是外国人做的不支持中文呀
???
我现在都哭
caiyi0903 2004-11-12
  • 打赏
  • 举报
 回复
太长了
jFresH_MaN 2004-11-12
  • 打赏
  • 举报
 回复
呵呵。楼上的方法好
tomuno 2004-11-12
  • 打赏
  • 举报
 回复
中文不好使
那试试英文呢
要是也不好使
那就是别的问题
skyboy0720 2004-11-12
  • 打赏
  • 举报
 回复
总结你的问题，帖出相关代码即可！
Avampire 2004-11-12
  • 打赏
  • 举报
 回复
狂晕 精简问题！
Bruce2008 2004-11-12
  • 打赏
  • 举报
 回复
你这样太杂了，谁有耐心看啊！
简化一点，说明问题即可
zjxt1010 2004-11-12
  • 打赏
  • 举报
 回复
说的具体一点呀
mysql无法向表中插入中文：修改编码格式
报错： 首次创建好table后，向表中插入汉字内容时会提示：ERROR 1366 (HY000): ...其中默认的Latin1格式就是导致无法正确插入汉字的原因，需要将其修改为utf8，只需要在配置文件中修改对应的字段即可。 解决方案： 修
完美解决SQL server2005中插入汉字变成问号的问题
以下是对在SQL server2005中插入汉字变成问号的解决办法进行了分析介绍。需要的朋友可以过来参考下
mysql汉字插不进去_Mysql下插入汉字失败
1、问题：mysql 遇到某些中文插入异常最近有同学反馈了这样一个问题：上述语句在脚本中 load 入库的时候会 hang 住，web 前端、命令行操作则要么抛出Incorrect string value: '\xF0\xA1\x8B\xBE\xE5\xA2...' for ...
mysql不可以插入汉字_Mysql不能插入中文(彻底解决)
在debian环境下，彻底解决mysql无法插入和显示中文的问题上篇(Mysql不能插入中文)提到了用临时方法更改数据库的字符集设置，显示中文，但是后来发现在有的系统下并不能成功，比如我用的debian 7.0，找了好久终于找到...
为什么python用不了中文_为什么即使使用编码，也不能用python显示汉字？
①中的字节(Python中名为str)可以是可打印的字符串或其他(二进制数据)。如果它是一个可打印字符串，它也可以是一个编码版本(如UTF-8，拉丁语-1或类似)的Unicode字符字符串。然后几个字节可以表示一个字符。在您的...
Web 开发

81,091

社区成员

341,718

社区内容

发帖
与我相关
我的任务
社区描述
Java Web 开发
社区管理员
  • Web 开发社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章