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

我们先看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();
   }
  }
 }

}