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