import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.swing.JOptionPane;
public class DBModel {
static final String driver = "com.mysql.jdbc.Driver";
final static String url = "jdbc:mysql://localhost:3306/databasename";
private String username = "root";
private String password = "textpassword";
private static Connection conn = null;
private String user=null;
private String pwd=null;
public void dbModel() {
  try {
   Class.forName(driver);
   conn = DriverManager.getConnection(url, username, password);
   JOptionPane.showMessageDialog(null,"連接成功！");
  } catch (ClassNotFoundException e) {
   // TODO 自動生成 catch 塊
   e.printStackTrace();
  } catch (SQLException e) {
   // TODO 自動生成 catch 塊
   e.printStackTrace();
  } finally {
   if (conn == null) {
    try {
     getConn().close();
    } catch (SQLException e) {
     // TODO 自動生成 catch 塊
     e.printStackTrace();
    }
    conn = null;
   }
  }

}
public Connection getConn() {
  return conn;
}

public String getPassword() {
  return password;
}
public String getUser() {
  return username;
}
public String getPwd() {
  return pwd;
}
public void setPwd(String pwd) {
  this.pwd = pwd;
}
public void setUser(String user) {
  this.user = user;
}
}