Java ?????? ??? ??? ??? ??????? ?????? ?? ?? ??? ?????. ???? ???? ?? DAO? ?? ??, ??? ?? ? ??? ???? ??? ??? ???. Google Cloud SQL ?? Amazon RDS? ?? ???? ?????? ???? ???? Java ??????? ??? ???? ???? ? ????. ???? ?????? ???? ????? ?? JDBC ???? ?? ???? ???? ???? ??????? ???? ?? ???? ???. ?? ????? JDBC ?? ORM ?????? ???? Java ??????? ???? CRUD ??? ???? ??? ?????.

Java ?????? ??? ??? ??? ???? ?????? ???? ????? ???????.

??? ??? ??(DAO)? ??? ????? ?????? ?? ?? ??? ???? ??? ???. Java ??????? ??? ??? ??? ??? ???? ?? ??????? ??? ??????? ???? ?? ??? ???? ? ?????. Google Cloud SQL ? Amazon RDS? ?? ???? ?????? ???? Java ??????? ??? ???? ?? ???? ? ?? ?? ??? ??? ?????? ???? ?????.

DAO ??? ??

• ?? ?? ??: ? DAO? ?? ?????? ?? ?? ?? ?? ??? ???? ???.
• ??? ??: DAO? ?? ?? ??????? ? ??? ?? ?????? ??(?: SQL ?? NoSQL)?? ????? ???.
• ??? ???: DAO? ???????? ?? ??? ???? ?? ?? ???? ??? ???.

???? ?????? ???? ??

?? ?? ??? Java ??????? Google Cloud SQL ??????? ???? ??? ?????.

// Import the Google Cloud SQL JDBC Socket Factory and Connector/J classes.
import com.google.cloud.sql.jdbc.SocketFactory;
import com.google.cloud.sql.jdbc.SQLDataSource;

// Create a new SQLDataSource object.
SQLDataSource dataSource = new SQLDataSource();
// Set the database connection properties.
dataSource.setHost(host);
dataSource.setPort(3306);
dataSource.setDatabase(dbName);
dataSource.setUser(user);
dataSource.setPassword(password);
// Retrieve the Cloud SQL JDBC socket factory.
SocketFactory socketFactory = SocketFactory.getDefaultInstance();
// Assign the socket factory to the data source.
dataSource.setSocketFactory(socketFactory);

// Obtain a connection to the database.
Connection conn = dataSource.getConnection();

????? ?? ??? Amazon RDS ??????? ???? ??? ?????.

// Import the Amazon RDS JDBC Driver classes.
import com.amazonaws.auth.BasicAWSCredentials;
import com.amazonaws.services.rds.AmazonRDSClient;
import com.amazonaws.services.rds.model.DBInstance;
import com.amazonaws.services.rds.model.Endpoint;
import javax.sql.DataSource;

// Create a new Amazon RDS client.
AmazonRDSClient rdsClient = new AmazonRDSClient();
// Retrieve the endpoint for the specified DB instance.
String dbHost = rdsClient.describeDBInstances(new DescribeDBInstancesRequest().withDBInstanceIdentifier(dbInstanceId)).getDBInstances().get(0).getEndpoint().getAddress();
String dbPort = rdsClient.describeDBInstances(new DescribeDBInstancesRequest().withDBInstanceIdentifier(dbInstanceId)).getDBInstances().get(0).getEndpoint().getPort().toString();

// Initialize the basic AWS credentials.
BasicAWSCredentials awsCreds = new BasicAWSCredentials(accessKey, secretKey);
// Configure the JDBC connection properties.
RdsConnectOptions rdsConnectOptions = new RdsConnectOptions();
rdsConnectOptions.setBasicCredentials(awsCreds);

// Get the RdsDataSource.
RdsDataSource rdsDataSource = new RdsDataSource(jdbcUrl, rdsConnectOptions);

// Obtain a connection to the database.
Connection conn = rdsDataSource.getConnection();

?? ??

Product的 Java 實體類，它映射到數(shù)據(jù)庫中的products??? ???? ??? ??? ?????. ?? DAO ??? Java ??????? ???? CRUD ??? ???? ??? ?????.

public interface ProductDao {
    List<Product> getAll();
    Product getById(long id);
    void insert(Product product);
    void update(Product product);
    void delete(long id);
}

JDBC ?? Hibernate ?? Spring Data JPA? ?? ORM ?????? ???? ? DAO? ??? ? ????. ??? ?????? ??????? ?? ?? ? ??? ???? ???? ??? ??? ?? ??? ??????.

? ??? Java ?????? ??? ??? ?? ?? ? ???? ?????? ????? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!