String sql="update "+mysql_information.get_mysql_table()+" set "+new_map+" where "+old_map;
//old_map里面只能有一個(gè)鍵值對(duì)，這個(gè)鍵值對(duì)是對(duì)數(shù)據(jù)的關(guān)鍵鍵
//new_mpa里面是修改的數(shù)據(jù)鍵值對(duì)，每個(gè)數(shù)據(jù)要用逗號(hào)隔開
//不管是old_map還是new_map參數(shù)的格式為：key='value'

import mysql.mysql_information;

import javax.naming.spi.DirectoryManager;
import javax.servlet.annotation.WebServlet;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;

public class Modification {

    public void Modification_sql(Map<String, String> old_date, Map<String, String> new_date) {
        try {
            Class.forName("com.mysql.jdbc.Driver");

            mysql_information mysql_information = new mysql_information();

            Connection conn = DriverManager.getConnection(mysql_information.get_mysql_dir(), mysql_information.get_username(), mysql_information.get_password());

            Statement st = conn.createStatement();

            Iterator<String> it = old_date.keySet().iterator();

            StringBuilder old_map= new StringBuilder();
            String key ;
            String value ;

            while (it.hasNext()) {

                key = it.next();
                value = old_date.get(key);

                if(key.equals("name")||key.equals("id")){
                    old_map.append(key).append("='").append(value).append("'");
                    break;
                }


            }

            it = new_date.keySet().iterator();
            StringBuilder new_map = new StringBuilder();

            while (it.hasNext()) {
                key = it.next();
                value = new_date.get(key);
                if(!it.hasNext()){
                    new_map.append(key).append("='").append(value).append("'");
                }else{
                    new_map.append(key).append("='").append(value).append("',");
                }
            }

            String sql = "update " + mysql_information.get_mysql_table() + " set " + new_map + " where " + old_map;
            System.out.println(sql);
            try {
                st.executeUpdate(sql);
            } catch (Exception e) {
                System.out.println("數(shù)據(jù)更新失敗");
            }

            conn.close();
            st.close();


        } catch (ClassNotFoundException | SQLException ex) {
            System.out.println("數(shù)據(jù)庫(kù)連接失敗");
        }
    }

}