weiweichen1985

★★★★★★★★★
★ ★
★ web程序 ★
★ ★
★★★★★★★★★



//==========================//
jsp页面编码：GBK/GB2312

//==========================//
过滤器及配置
package com.cw.util;
public class Filter implements javax.servlet.Filter {

public void destroy() {
// TODO Auto-generated method stub

}

public void doFilter(ServletRequest request, ServletResponse response,
FilterChain chain) throws IOException, ServletException {
request.setCharacterEncoding("gb2312");
chain.doFilter(request, response);

}

public void init(FilterConfig arg0) throws ServletException {


}

}
<filter>
<filter-name>filteEncoding</filter-name>
<filter-class>com.cw.util.Filter</filter-class>
</filter>
<filter-mapping>
<filter-name>filteEncoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>


//====================//
数据库设置
库及表的属性字符集都要设为GB2312
在MYSQL安装目录找到my.ini文件，打开后将default-character-set设为GB2312(两处)






★★★★★★★★★
★ ★
★ java程序 ★
★ ★
★★★★★★★★★

package com.cw.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Date;

public class Test {

/**
* @param args
*/
public static void main(String[] args) {

try {
Class.forName("com.mysql.jdbc.Driver");

//在URL中设置字符编码
String url = "jdbc:mysql://localhost:3306/test?user=root&password=mysql&useUnicode=true&characterEncoding=gb2312";
Connection conn = DriverManager.getConnection(url);
PreparedStatement pstm = conn
.prepareStatement("insert into stu(sname,stime) values(?,?)");


pstm.setString(1, "陈伟人的");
pstm.setDate(2, java.sql.Date.valueOf("2008-3-23"));

int count=pstm.executeUpdate();
if(count>0)
System.out.println("insert suc");
try {
//if(rs!=null)
// rs.close();
if(pstm!=null)
pstm.close();
if(conn!=null){
conn.close();
}
} catch (Exception e) {
// TODO: handle exception
}

} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}

}