解决servlet中文数据传入到数据库乱码问题

来源：互联网发布：香港小鱼儿最近域名编辑：程序博客网时间：2024/05/16 09:41

我们先看servlet里面的方法

private void doAdd(HttpServletRequest request, HttpServletResponse response)
   throws IOException {
  response.setContentType("text/html;charset=utf-8");
  response.setCharacterEncoding("UTF-8");
  request.setCharacterEncoding("UTF-8");
  PrintWriter out = response.getWriter();
  String goodName = request.getParameter("goodName");
  goodName = new String(goodName.getBytes("ISO-8859-1"),"utf-8");//保证从页面上拿到的数据不乱码


  String goodPrice = request.getParameter("goodPrice");
  goodPrice = new String(goodPrice.getBytes("ISO-8859-1"),"utf-8");//保证从页面上拿到的数据不乱码

  String goodClass = request.getParameter("goodClass");
  goodClass = new String(goodClass.getBytes("ISO-8859-1"),"utf-8");//保证从页面上拿到的数据不乱码

  String goodIMG = request.getParameter("goodIMG");
  goodIMG = new String(goodIMG.getBytes("ISO-8859-1"),"utf-8");//保证从页面上拿到的数据不乱码

}

我们在看util里面的按方法

public class Util {
String name ="root";
String password = "123456";
String url = "jdbc:mysql://localhost:3306/bookstort?useUnicode=true&characterEncoding=UTF-8&"; // ?useUnicode=true&characterEncoding=UTF-8&"这个代码就是解决传入数据库中会乱码的核心

String jdbcName = "com.mysql.jdbc.Driver";

public Connection getCon() throws ClassNotFoundException, SQLException{
  Class.forName(jdbcName);
  Connection connection = DriverManager.getConnection(url, name, password);
  return connection;
}
public static void main(String[] args) {
  Util util = new Util();
  try {
   util.getCon();
   System.out.println("连接成功");
  } catch (ClassNotFoundException | SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
}

public static void closeCon(Connection connection){
  if(connection!=null){
   try {
    connection.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
}
public static void closeStatement(Statement st){
  if(st!=null){
   try {
    st.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
}

public static void closeResuleSet(ResultSet rs){
  if(rs!=null){
   try {
    rs.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  }
}

}

0 1