
常用软件类: |
|杀毒安全 | |联络聊天 | |网络软件 | |多媒体类 | |系统工具 | |图形图像 | |系统工具 | |应用软件 | |行业软件 |
开发设计类: |
|动画制作 | |图像处理 | |3D设计 | |操作系统 | |站长学院 | |网络相关 | |WEB设计 | |数据库类 | |程序开发 |
| 以下是引用片段: <%@page contentType="text/html; charset=UTF-8"%>而不是%@page contentType="text/html; charset=UTF-8"% |
| 以下是引用片段: <web-app> ... <filter> <filter-name>Set Character Encoding</filter-name> <filter-class>com.redv.projects.eduadmin.util.filters.SetCharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>UTF-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>Set Character Encoding</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> ... </web-app> |
| 以下是引用片段: package com.redv.projects.eduadmin.util.filters; import java.io.IOException; import javax.servlet.Filter; import javax.servlet.FilterChain; import javax.servlet.FilterConfig; import javax.servlet.ServletException; import javax.servlet.ServletRequest; import javax.servlet.ServletResponse; import javax.servlet.UnavailableException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class SetCharacterEncodingFilter implements Filter { protected String encoding = null; protected FilterConfig filterConfig = null; protected boolean ignore = true; public void destroy() { this.encoding = null; this.filterConfig = null; } public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException { // Conditionally select and set the character encoding to be used if (ignore || (request.getCharacterEncoding() == null)) { String encoding = selectEncoding(request); if (encoding != null) { request.setCharacterEncoding(encoding); // Overrides the name of the character encoding used in the body of this request. This method must be called prior to reading request parameters or reading input using getReader(). } } // Pass control on to the next filter chain.doFilter(request, response); } public void init(FilterConfig filterConfig) throws ServletException { this.filterConfig = filterConfig; this.encoding = filterConfig.getInitParameter("encoding"); String value = filterConfig.getInitParameter("ignore"); if (value == null) { this.ignore = true; } else if (value.equalsIgnoreCase("true")) { this.ignore = true; } else if (value.equalsIgnoreCase("yes")) { this.ignore = true; } else { this.ignore = false; } } protected String selectEncoding(ServletRequest request) { return (this.encoding); } } |
| 以下是引用片段: import java.sql.*; Class.forName("org.gjt.mm.mysql.Driver"); Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; try { con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", ""); pstmt = con.prepareStatement("SELECT f3, f4 FROM tbl1 WHERE f1 = ? AND f2 = ?"); pstmt.setString(1, new String(f1.getBytes("GBK"), "ISO-8859-1"); pstmt.setString(2, new String(f2.getBytes("GBK"), "ISO-8859-1"); rs = pstmt.executeQuery(); String f3, f4; while(rs.next()) { f3 = new String(rs.getString(1).getBytes("ISO-8859-1"), "GBK"); f4 = new String(rs.getString(2).getBytes("ISO-8859-1"), "GBK"); } } finally { //close resouces ... } |
| 以下是引用片段: import java.sql.*; import com.redv.sql.encoding.*; Class.forName("org.gjt.mm.mysql.Driver"); Connection con = null; PreparedStatement pstmt = null; ResultSet rs = null; try { con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", ""); //接管数据库连接实例 boolean coding = true; EncodingConnection codingConnection = new EncodingConnection(con, coding, "ISO-8859-1", "GBK"); //获得接管后的数据库连接实例,以后直接使用con已经是经过EncodingConnection重新包装过的实例 con = codingConnection.getConnection(); pstmt = con.prepareStatement("SELECT f3, f4 FROM tbl1 WHERE f1 = ? AND f2 = ?"); pstmt.setString(1, f1); pstmt.setString(2, f2); rs = pstmt.executeQuery(); String f3, f4; while(rs.next()) { f3 = rs.getString(1); f4 = rs.getString(2); } } finally { //close resouces ... } |