终于搞好了jsp+JavaBean+mysql4.0 但是显示中文乱码
dbconn.java
package angelj2ee;import java.sql.*;
public class dbconn {
public dbconn() {
}
//declare variable
private Connection conn = null;
ResultSet rs = null;
private String server = "192.168.1.94";
private String port = "3306";
private String db = "testPoolMan";
private String user = "root";
private String pass = "";
private String drivername="com.mysql.jdbc.Driver";
private String GBK="GBK";
private String URL="jdbc:mysql://"+server+":"+port+"/"+db+"?user="+user+"&password="+pass;
public Connection getConn(){//get database connection
try{
Class.forName(drivername).newInstance();
conn = DriverManager.getConnection(URL);
}
catch(Exception e){
e.printStackTrace();
}
return this.conn ;
}
public void setServer(String str) {//set server name
server=str;
}
public void setPort(String str) {//set server port
port = str;
}
public void setDB(String str) {//set db name
db = str;
}
public void setUser(String str) {//set user name
user = str;
}
public void setPass(String str) {//set user name
pass = str;
}
public ResultSet executeSQL(String str) {
try{
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(str);
}
catch(Exception e){
e.printStackTrace();
}
return this.rs;
}
}xindex.jsp
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>
newMySql
</title>
</head>
<jsp:useBean id="NinGoo" scope="session" class="angelj2ee.dbconn" />
<jsp:setProperty name="NinGoo" property="*" />
<body bgcolor="#ffffff">
<h1>
新连接mysql数据库
</h1>
<%ResultSet rs = null;
Connection conn = null;
NinGoo.setServer("192.168.1.94"); //设置MySQL的服务器名或者IP
NinGoo.setPort("3306"); //设置MySQL的监听端口
NinGoo.setDB("testPoolMan"); //设置MySQL的数据库名
NinGoo.setUser("root"); //设置连接MySQL的用户名
NinGoo.setPass(""); //设置连接MySQL的密码
conn = NinGoo.getConn() ;
rs = NinGoo.executeSQL("select * from news");
while(rs.next()) {
%>
Row:<%=rs.getString(2)%>
<%=new String(rs.getString("title").getBytes("iso8859-1"),"GBK")%>
<br>
<%}%>
<%out.print("Successful!\n");%>
<%
rs.close();
conn.close();</body>
</html>
dbconn.java
package angelj2ee;import java.sql.*;
public class dbconn {
public dbconn() {
}
//declare variable
private Connection conn = null;
ResultSet rs = null;
private String server = "192.168.1.94";
private String port = "3306";
private String db = "testPoolMan";
private String user = "root";
private String pass = "";
private String drivername="com.mysql.jdbc.Driver";
private String GBK="GBK";
private String URL="jdbc:mysql://"+server+":"+port+"/"+db+"?user="+user+"&password="+pass;
public Connection getConn(){//get database connection
try{
Class.forName(drivername).newInstance();
conn = DriverManager.getConnection(URL);
}
catch(Exception e){
e.printStackTrace();
}
return this.conn ;
}
public void setServer(String str) {//set server name
server=str;
}
public void setPort(String str) {//set server port
port = str;
}
public void setDB(String str) {//set db name
db = str;
}
public void setUser(String str) {//set user name
user = str;
}
public void setPass(String str) {//set user name
pass = str;
}
public ResultSet executeSQL(String str) {
try{
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(str);
}
catch(Exception e){
e.printStackTrace();
}
return this.rs;
}
}xindex.jsp
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>
newMySql
</title>
</head>
<jsp:useBean id="NinGoo" scope="session" class="angelj2ee.dbconn" />
<jsp:setProperty name="NinGoo" property="*" />
<body bgcolor="#ffffff">
<h1>
新连接mysql数据库
</h1>
<%ResultSet rs = null;
Connection conn = null;
NinGoo.setServer("192.168.1.94"); //设置MySQL的服务器名或者IP
NinGoo.setPort("3306"); //设置MySQL的监听端口
NinGoo.setDB("testPoolMan"); //设置MySQL的数据库名
NinGoo.setUser("root"); //设置连接MySQL的用户名
NinGoo.setPass(""); //设置连接MySQL的密码
conn = NinGoo.getConn() ;
rs = NinGoo.executeSQL("select * from news");
while(rs.next()) {
%>
Row:<%=rs.getString(2)%>
<%=new String(rs.getString("title").getBytes("iso8859-1"),"GBK")%>
<br>
<%}%>
<%out.print("Successful!\n");%>
<%
rs.close();
conn.close();</body>
</html>
解决方案 »
- jquery ajax 服务端响应的是空
- struts标签 logic:iterate问题
- varchar(length)跟datetime哪种更占空间
- 不同的角色看到不同的menu 界面上具体怎么实现
- 求在JSTL里的FOREACH里面怎么知道当前访问的是FOREACH里面的第几个值?在线等
- jsp中关于参数为中文的转向问题及怎样使float型小数点后只两位
- 跪求IE按钮控件的开发方法
- 我的JavaBean获取的时间是12小时制式的,但我想获取的时间是24小时制式的,该如何制作,请高手帮忙
- 将一个class类反编译以后,我进行了修改,当我编译它的时候出错,我该如何解决
- struts2 多个jsp页面传值到action后返回当前对应页面
- url传值问题(急)
- 一个简单 Iterator 的问题
后面这段指定字符集很必要
与"&useUnicode=true&characterEncoding=GBK"可是冲突的哦!
[mysqld]
basedir=D:/mysql
datadir=D:/mysql/data
default-character-set=gb2312
<% request.setCharacterEncoding("gb2312");%>放在第三行,我曾经出现过和你一样的问题,我加入这个就不是乱码了!
你试试