Java web使用JDBC连接MySQL进行插入操作时中文显示乱码

FfanWang 2018-03-25 10:29:04

在学习struts2框架，在使用insert语句插入MySQL数据库时中文显示为乱码？？？。常见的解决方法都试过了。

这是注册界面的jsp代码，规定了utf-8编码

<%@ page language="java" contentType="text/html; charset=UTF-8"

    pageEncoding="UTF-8"%>



<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<title>注册页面</title>

</head>

<body>

    <form  action="registeraction" method="post">

	    账号：<input type="text" name="userID"/><br />

	    用户名：<input type="text" name="username"/><br />

	    密码：<input type="password" name="password"/><br />

	 用户类别：<input type="text" name="level"/><br />

    <input type="submit" value="注册"/>

    </form>

</body>

</html>

这是相应的java代码，已经在连接数据库时加入了useUnicode=true&characterEncoding=utf-8语句

package com.user.regiseraction;



import java.sql.*;



public class registeraction {

		private String userID = new String();

		private String username = new String();

		private String password = new String();

		private String level = new String();

		public String execute() throws ClassNotFoundException, SQLException{

			ResultSet rs1 = null,rs2 = null ;

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

		    System.out.println("Success loading Mysql Driver!");

		    

		    String searchStr1 = null,searchStr2 = null;

		    System.out.println("for searchStr1,userID=" + userID);

		    searchStr1 = "select * from user where userID=\"" + userID + "\";";

		    switch (level){

		    case "1"://student

		    	searchStr1 = "select * from student where studentID=\"" + userID + "\";";

		    	break;

		    case "2"://teacher

		    	searchStr1 = "select * from teacher where teacherID=\"" + userID +"\";";

		    	break;

		    case "3"://assistant

		    	searchStr1 = "select * from assistant where assistantID=\"" + userID +"\";";

		    	break;

		    }

		    System.out.println(searchStr1);

		    

		    Connection connect;

			try {

				connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/stufigure?useUnicode=true&characterEncoding=utf-8","root","fanfun");

				Statement stmt = connect.createStatement();

			    rs1 = (ResultSet) stmt.executeQuery(searchStr1);

			} catch (SQLException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}	

			

			searchStr2 = "select * from user where userID=\"" + userID + "\";";

			try {

				connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/stufigure?useUnicode=true&characterEncoding=utf-8","root","fanfun");

				Statement stmt = connect.createStatement();

			    rs2 = (ResultSet) stmt.executeQuery(searchStr2);

			} catch (SQLException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}	

			if (rs1.next() && !rs2.next()){

				connect = DriverManager.getConnection("jdbc:mysql://localhost:3306/stufigure","root","fanfun");

				Statement stmt = connect.createStatement();

				String str = "insert into user values(\"" + userID +  "\",\"" + username + "\",\"" + password + "\"," + level + ");";

				System.out.println(str);

				stmt.executeUpdate(str);

				return "success";

			}

		    else

		    	return "fail";

		}

		public String getUserID() {

			return userID;

		}

		public void setUserID(String userID) {

			this.userID = userID;

		}

		public String getUsername() {

			return username;

		}

		public void setUsername(String username) {

			this.username = username;

		}

		public String getPassword() {

			return password;

		}

		public void setPassword(String password) {

			this.password = password;

		}

		public String getLevel() {

			return level;

		}

		public void setLevel(String level) {

			this.level = level;

		}

}

这是相应的web.xml文件，也是使用的utf-8编码

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0">

  <display-name>library</display-name>

  <welcome-file-list>

  <!-- 设置起始欢迎界面 -->

    <welcome-file>index.jsp</welcome-file>

  </welcome-file-list>

   <filter>    

   		<!-- 定义核心filter名称 -->

        <filter-name>struts2</filter-name> 

		<!-- 定义核心filter实现类 -->  

        <filter-class>    

            org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter    

        </filter-class>    

    </filter>    

    <filter-mapping>   

    	<!-- 核心filter名称 --> 

        <filter-name>struts2</filter-name>   

        <!-- 使用该核心filter接受所有的WEB请求 --> 

        <url-pattern>/*</url-pattern>    

</filter-mapping>  

</web-app>