java - 更改用户 JDBC 连接

Question

我正在尝试更改连接到我的数据库的用户，但它不起作用，我坚持使用第一个。我怎么做 ？

public class Model {
    private String user;
    private String passwd;
    private String url;
    private String matricule;
    private static Model model;
    private Connection connect; 
    private DoctorsModel doctorsModel;
    private ConnexionModel connexionModel;
    private MedicineModel medicineModel;
    private VisitorsModel visitorsModel;
    private ReportModel reportModel;
    private NewReportModel newReportModel;

    private Model(String user, String passwd){
        this.user = user;
        this.passwd = passwd;
        url="myurl";

        try {
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("Driver OK");

            this.connect = DriverManager.getConnection(url, user, passwd);
            this.connexionModel = new ConnexionModel(connect,url,user,passwd);
            this.doctorsModel = new DoctorsModel(connect);
            this.medicineModel = new MedicineModel(connect);
            this.visitorsModel = new VisitorsModel(connect);
            this.reportModel = new ReportModel(connect);
            this.newReportModel = new NewReportModel(connect,matricule);
        }

        catch (Exception e){
            Alert error = new Alert(Alert.AlertType.WARNING);
            error.setTitle("Erreur");
            error.setHeaderText(null);
            error.setContentText("Une erreur a été rencontrée, veuillez réessayer plus tard.");
            error.showAndWait();
            System.exit(0);
            e.printStackTrace();
        }
    }
    public static Model getInstance()
    {
        if (model==null)
        {
            model = new Model("firstuser","passwd");
        }
        return model;
    }

    public ConnexionModel getConnexionModel()
    {
        return connexionModel;
    }

    public DoctorsModel getDoctorsModel()
    {
        return doctorsModel;
    }

    public MedicineModel getMedicineModel()
    {
        return medicineModel;
    }

    public VisitorsModel getVisitorsModel()
    {
        return visitorsModel;
    }

    public ReportModel getReportModel()
    {
        return reportModel;
    }

    public NewReportModel getNewReportModel()
    {
        return newReportModel;
    }

    public void setUser(String user)
    {
        this.user = user;
    }

    public void setPasswd(String passwd)
    {
        this.passwd = passwd;
    }
    public void setConnection()
    {
        try
        {
            connect = DriverManager.getConnection(url,user,passwd);
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
    }
    public void getConnection()
    {
        System.out.println(connect);
    }

    public void setMatricule(String matricule)
    {
        this.matricule = matricule;
    }

    public String getMatricule(String matricule)
    {
        return matricule;
    }}

我打电话setConnection()给我ConnectionController，没什么特别的，我打印了Connection之前和之后，打印出用户，密码，一切都正确改变了......我尝试在再次设置之前关闭连接，它只是告诉我连接已关闭而且我再也无法访问了。

标签： javajdbcconnection