glassfish不会与数据库一起部署

Question

应该连接到easyphp服务器上的phpmyadmin数据库，在users数据库上插入一条记录，所有这一切都通过glassfish服务器通过web服务进行，但这并没有发生

netbeans表示，glassfish之所以能够运行，是因为它只有一个停止、删除或重新启动服务器的选项，但“start”选项是灰色的

package Java;

import javax.jws.WebService;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.DriverManager;
/**
 *
 * @author Laplet Repair
 */
@WebService(serviceName = "AddUser")

public class AddUser {
    private Statement statement = null;
    private PreparedStatement preparedStatement = null;
    private ResultSet resultSet = null;
    private Connection connect = null;

     public void readDataBase() throws Exception {
    try {
      // This will load the MySQL driver, each DB has its own driver
      Class.forName("com.mysql.jdbc.Driver");
      // Setup the connection with the DB
      connect = DriverManager
          .getConnection("jdbc:mysql://localhost:3306/conquest_of_the_fates_user?zeroDateTimeBehavior=convertToNull"
              + "user=root&password=");

      // Statements allow to issue SQL queries to the database
      statement = connect.createStatement();

      // PreparedStatements can use variables and are more efficient
      preparedStatement = connect
          .prepareStatement("insert into  feedback.comments values (default, ?, ?, ?)");
      // "myuser, webpage, datum, summery, COMMENTS from feedback.comments");
      // Parameters start with 1
      preparedStatement.setString(1, "username");
      preparedStatement.setInt(2, 5);
      preparedStatement.setString(3, "password");
      preparedStatement.executeUpdate();

      resultSet = statement
      .executeQuery("select * from feedback.comments");      
    } catch (Exception e) {
      throw e;
    } finally {
      close();
    }

  }

  // You need to close the resultSet
  private void close() {
    try {
      if (resultSet != null) {
        resultSet.close();
      }

      if (statement != null) {
        statement.close();
      }

      if (connect != null) {
        connect.close();
      }
    } catch (Exception e) {

    }
  }
}

这是错误日志

java.lang.RuntimeException：java.io.ioException在com.sun.enterprise.v3.admin.admin.adminadapter.onmissingResource(adminadapter.java:266)在org.glassfish.grizzly.http.server.statichttpphandlerbase.service(statichttpphandlerbase.java:189)在com.sun.enterprise.v3.services.impl.containermapper在com.sun.enterprise.v3.services.impl.containermapper执行（defaultFilterChain.execute（defaultFilterChain.java:133)位于org.glassFish.grizzly.filterChain.defaultFilterChain.process（defaultFilterChain.java:112)位于org.glassFish.grizzly.processorrexecutor.execute（processorrexecutor.77)位于org.glassFish.grizzly.nio.transport.tcpniotransport.fireioevent（tcpniotransport.561)位于

Answer 1

您应该在glassfish管理控制台上为您的MySQL数据库配置“JDBC资源”+“JDBC连接池”如何在glassfish中设置JDBC连接

您可能需要在:glassfish-install-path\domains\domain-name\lib中部署一个MySQL jdbc实现库

并创建一个EJB单例来检索连接：

@Singleton
@LocalBean
public class DBConnections {

    @Resource(lookup = "resource JNDI name")
    private DataSource dataSource;

    public Connection getConnection() throws SQLException {
        return dataSource.getConnection();
    }
}