乱码!!!! str = new String(str.getBytes("ISO-8859-1"),"GBK") ; ^^^^^^^^^^ 你用的什么发布器,操作系统是什么? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <% include file="a.jsp"%>String addSql="";addSql=addSql+GBKConverter(request.getParameter("txtNewsTitle);out.print(addSql); 我们用的一样,给你个例子研究一下吧<%@ page contentType="text/html;charset=gb2312"%><html><head><meta http-equiv="content-Type" content="text/html;charset=gb2312"><title>注册确认</title><link rel=stylesheet href="bbs.css" type="text/css"></head> <body><Br><br><br><center><%@ page import="java.util.*"%><%@ page import="java.text.*"%><%@ page import="java.lang.*"%><%@ page import="java.io.*"%><%@ page import="java.sql.*"%> <% Class.forName("org.gjt.mm.mysql.Driver").newInstance(); String url ="jdbc:mysql://192.168.1.61/AddrBook_database?user=heyi&password=123&useUnicode=true&characterEncoding=gb2312"; Connection conn= DriverManager.getConnection(url); //取值 String username=request.getParameter("username"); username= new String(username.getBytes("ISO8859-1"),"GBK"); session.putValue("username",username); String status=request.getParameter("status"); String password=request.getParameter("password"); //已经声明的变量不能再声明,取时间 long miliSeconds = Calendar.getInstance().getTimeInMillis(); long nowtime=miliSeconds/1000; Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql1="select max(UserID) from IM_Users"; out.println(sql1); ResultSet rs1=stmt.executeQuery(sql1); int UserID1; int UserID; int rownum; rs1.last();//记录集指针放到最后一行 rownum=rs1.getRow();//取记录数if (rownum==0){//rs1如果为空不能取东西,不然有错 UserID1=1;}else{ UserID=rs1.getInt(1); UserID1=UserID+1;} String sql="insert into IM_Users(UserID,UserName,Password,HA1,Status,SipUrl,CreateTime) values('"+UserID1+"','"+username+"','"+password+"','"+password+"','"+status+"','"+username+"','"+nowtime+"')"; out.println(sql); stmt1.executeUpdate(sql); //rs.close(); stmt1.close(); rs1.close(); stmt.close(); conn.close(); response.sendRedirect("regok.jsp?username="+username+"");%> try{aaa=new String(info.getBytes("iso8859_1"),"gb2312");}catch(Exception e){} tomcat 与MyEelipse 8.5 连接时运行报错 求助:JSP变量定义问题 JS的问题,大家给帮助下!谢谢了 请问在ACTION里如何取得页面下拉框(select)的所有值 局域网调用ejb的问题??? 求教如何判断url是否可用 小弟做了一JSP应放在哪个目录下? 哪里有sun.JDBC.odbc.JdbcOdbcDriver这个驱动下载? 各位兄弟,天上掉馅饼了,不捡个吗? 上传文件时又向数据库中插入数据,如何处理其中一个不成功时的操作呢 基于b/s结构的电子白板的实现? 怎么解决文章的分行和分段问题.
String addSql="";
addSql=addSql+GBKConverter(request.getParameter("txtNewsTitle);
out.print(addSql);
<html>
<head>
<meta http-equiv="content-Type" content="text/html;charset=gb2312">
<title>注册确认</title>
<link rel=stylesheet href="bbs.css" type="text/css">
</head>
<body>
<Br><br><br>
<center>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<%@ page import="java.lang.*"%>
<%@ page import="java.io.*"%>
<%@ page import="java.sql.*"%>
<% Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://192.168.1.61/AddrBook_database?user=heyi&password=123&useUnicode=true&characterEncoding=gb2312";
Connection conn= DriverManager.getConnection(url);
//取值
String username=request.getParameter("username");
username= new String(username.getBytes("ISO8859-1"),"GBK");
session.putValue("username",username);
String status=request.getParameter("status");
String password=request.getParameter("password");
//已经声明的变量不能再声明,取时间
long miliSeconds = Calendar.getInstance().getTimeInMillis();
long nowtime=miliSeconds/1000;
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql1="select max(UserID) from IM_Users";
out.println(sql1);
ResultSet rs1=stmt.executeQuery(sql1);
int UserID1;
int UserID;
int rownum;
rs1.last();//记录集指针放到最后一行
rownum=rs1.getRow();//取记录数
if (rownum==0){//rs1如果为空不能取东西,不然有错
UserID1=1;
}else{
UserID=rs1.getInt(1);
UserID1=UserID+1;
}
String sql="insert into IM_Users(UserID,UserName,Password,HA1,Status,SipUrl,CreateTime) values('"+UserID1+"','"+username+"','"+password+"','"+password+"','"+status+"','"+username+"','"+nowtime+"')";
out.println(sql);
stmt1.executeUpdate(sql);
//rs.close();
stmt1.close();
rs1.close();
stmt.close();
conn.close();
response.sendRedirect("regok.jsp?username="+username+"");
%>