向数据库中插入中文字符的问题 把你这些address = new String(ename.getBytes("iso8859-1"),"gb2312");都println出来看是否转码正确再说??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 [Microsoft][ODBC SQL Server Driver][SQL Server]在此上下文中不允许使用 'huazhouji'。此处只允许使用常量、表达式或变量。不允许使用列名。 huazhouji 111 拧电动机 打发法看见机 我println了 结果出错 可以试着把address = new String(ename.getBytes("iso8859-1"),"gb2312");都去掉,然后插入,有时候不转换,就可以了 我改了改程序:<%@ page contentType="text/html;charset=GB2312" %><%@ page import="java.util.*,java.sql.*" %><%@ include file="common.jsp" %> <% String strEname=request.getParameter("ename"); String strMima=request.getParameter("mima").trim(); String strWhat=request.getParameter("what").trim(); String strReply=request.getParameter("reply").trim(); String strCnname=request.getParameter("cnname").trim(); String strCode=request.getParameter("code").trim(); String strPostcode=request.getParameter("postcode"); String strTel=request.getParameter("tel"); String strAddress=request.getParameter("address").trim(); String strEmail=request.getParameter("email"); try { String url= "jdbc:odbc:eshop"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn= DriverManager.getConnection(url); java.sql.Statement stmt; stmt= conn.createStatement(); String insertMessage = "INSERT INTO register(ename,mima,what,reply,cnname,code,postcode,tel,address,email) VALUES("+strEname+","+strMima+","+strWhat+","+strReply+","+strCnname+","+strCode+","+strPostcode+","+strTel+","+strAddress+","+strEmail+")"; stmt.executeUpdate(insertMessage); stmt.close(); conn.close(); }catch(Exception e){ out.println(e.getMessage()); } %> <html><head></head> <body> <%= strEname %> <%= strMima %> <%= strWhat %> <%= strAddress %> </body> </html>出错啊:[Microsoft][ODBC SQL Server Driver][SQL Server]在此上下文中不允许使用 'aaa'。此处只允许使用常量、表达式或变量。不允许使用列名。 aaa aaa aaa aa 是不是跟数据库中的列属性的设置有关 我都设成char型的 我已经弄清楚了 应该是String insertMessage = "INSERT INTO register(ename,mima,what,reply,cnname,code,postcode,tel,address,email) VALUES('"+strEname+"','"+strMima+"','"+strWhat+"','"+strReply+"','"+strCnname+"','"+strCode+"','"+strPostcode+"','"+strTel+"','"+strAddress+"','"+strEmail+"')";谢谢大家 关于操作日志记录的问题 求助XML解析DRIVER(在线等) 帮帮忙,myeclipse 引入Jquery.js文件 问题? 怎么找出这个问题所在? 请高手指点字符串包含问题,多谢! 我写了如下一个方法,但是用起来有问题,帮我看看!! 关于<jsp:include>的问题! 请问java2中的 javax.swing.tabbedpane活动页在java1中有实现相同功能的类似的控件吗?在线等待,急!!!!!!!! 【紧急求救】tomcat 无限占用内存问题!!! jsp与DB2的问题? 用TOMCAT可以浏览PHP程序吗? 安装jdk的问题?帮帮忙
我println了
结果出错
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.util.*,java.sql.*" %>
<%@ include file="common.jsp" %> <%
String strEname=request.getParameter("ename");
String strMima=request.getParameter("mima").trim();
String strWhat=request.getParameter("what").trim();
String strReply=request.getParameter("reply").trim();
String strCnname=request.getParameter("cnname").trim();
String strCode=request.getParameter("code").trim();
String strPostcode=request.getParameter("postcode");
String strTel=request.getParameter("tel");
String strAddress=request.getParameter("address").trim();
String strEmail=request.getParameter("email");
try
{
String url= "jdbc:odbc:eshop";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn= DriverManager.getConnection(url);
java.sql.Statement stmt;
stmt= conn.createStatement();
String insertMessage = "INSERT INTO register(ename,mima,what,reply,cnname,code,postcode,tel,address,email) VALUES("+strEname+","+strMima+","+strWhat+","+strReply+","+strCnname+","+strCode+","+strPostcode+","+strTel+","+strAddress+","+strEmail+")";
stmt.executeUpdate(insertMessage);
stmt.close();
conn.close();
}catch(Exception e){
out.println(e.getMessage());
}
%> <html><head></head>
<body>
<%= strEname %>
<%= strMima %>
<%= strWhat %>
<%= strAddress %>
</body>
</html>
出错啊:
[Microsoft][ODBC SQL Server Driver][SQL Server]在此上下文中不允许使用 'aaa'。此处只允许使用常量、表达式或变量。不允许使用列名。 aaa aaa aaa aa
应该是
String insertMessage = "INSERT INTO register(ename,mima,what,reply,cnname,code,postcode,tel,address,email) VALUES('"+strEname+"','"+strMima+"','"+strWhat+"','"+strReply+"','"+strCnname+"','"+strCode+"','"+strPostcode+"','"+strTel+"','"+strAddress+"','"+strEmail+"')";
谢谢大家