我们如何使用达梦数据库的访问接口进行标准的程序设计呢?通过该接口,我们可以实现与达梦数据库的连接、查询、插入、更新和删除等操作。本文提供了以下几个代码案例,涵盖了常见的数据库操作,可以帮助开发者快速上手达梦数据库的编程。
连接数据库 首先,我们需要导入达梦数据库的访问接口包,并建立与数据库的连接。以下是连接数据库的示例代码:
import com.dameng.jdbc.DmConnection; import com.dameng.jdbc.DmDriver; public class DatabaseConnectionExample { public static void main(String[] args) { try { Class.forName("dm.jdbc.driver.DmDriver"); String url = "jdbc:dm://localhost:5236/mydatabase"; String username = "username"; String password = "password"; DmConnection connection = (DmConnection) DmDriver.getConnection(url, username, password); System.out.println("Connected to database."); connection.close(); } catch (Exception e) { e.printStackTrace(); } } }
执行查询 接下来,我们可以使用访问接口执行查询操作。以下是一个简单的查询示例:
import com.dameng.jdbc.DmConnection; import com.dameng.jdbc.DmDriver; import com.dameng.jdbc.DmStatement; import java.sql.ResultSet; public class DatabaseQueryExample { public static void main(String[] args) { try { Class.forName("dm.jdbc.driver.DmDriver"); String url = "jdbc:dm://localhost:5236/mydatabase"; String username = "username"; String password = "password"; DmConnection connection = (DmConnection) DmDriver.getConnection(url, username, password); DmStatement statement = (DmStatement) connection.createStatement(); ResultSet resultSet = statement.executeQuery("SELECT * FROM employees"); while (resultSet.next()) { String name = resultSet.getString("name"); int age = resultSet.getInt("age"); System.out.println("Name: " + name + ", Age: " + age); } resultSet.close(); statement.close(); connection.close(); } catch (Exception e) { e.printStackTrace(); } } }
执行插入 我们还可以使用访问接口执行插入操作。以下是一个简单的插入示例:
import com.dameng.jdbc.DmConnection; import com.dameng.jdbc.DmDriver; import com.dameng.jdbc.DmStatement; public class DatabaseInsertExample { public static void main(String[] args) { try { Class.forName("dm.jdbc.driver.DmDriver"); String url = "jdbc:dm://localhost:5236/mydatabase"; String username = "username"; String password = "password"; DmConnection connection = (DmConnection) DmDriver.getConnection(url, username, password); DmStatement statement = (DmStatement) connection.createStatement(); int rowsAffected = statement.executeUpdate("INSERT INTO employees (name, age) VALUES ('John', 30)"); System.out.println("Rows affected: " + rowsAffected); statement.close(); connection.close(); } catch (Exception e) { e.printStackTrace(); } } }
执行更新 我们还可以使用访问接口执行更新操作。以下是一个简单的更新示例:
import com.dameng.jdbc.DmConnection; import com.dameng.jdbc.DmDriver; import com.dameng.jdbc.DmStatement; public class DatabaseUpdateExample { public static void main(String[] args) { try { Class.forName("dm.jdbc.driver.DmDriver"); String url = "jdbc:dm://localhost:5236/mydatabase"; String username = "username"; String password = "password"; DmConnection connection = (DmConnection) DmDriver.getConnection(url, username, password); DmStatement statement = (DmStatement) connection.createStatement(); int rowsAffected = statement.executeUpdate("UPDATE employees SET age = 35 WHERE name = 'John'"); System.out.println("Rows affected: " + rowsAffected); statement.close(); connection.close(); } catch (Exception e) { e.printStackTrace(); } } }
执行删除 最后,我们还可以使用访问接口执行删除操作。以下是一个简单的删除示例:
import com.dameng.jdbc.DmConnection; import com.dameng.jdbc.DmDriver; import com.dameng.jdbc.DmStatement; public class DatabaseDeleteExample { public static void main(String[] args) { try { Class.forName("dm.jdbc.driver.DmDriver"); String url = "jdbc:dm://localhost:5236/mydatabase"; String username = "username"; String password = "password"; DmConnection connection = (DmConnection) DmDriver.getConnection(url, username, password); DmStatement statement = (DmStatement) connection.createStatement(); int rowsAffected = statement.executeUpdate("DELETE FROM employees WHERE name = 'John'"); System.out.println("Rows affected: " + rowsAffected); statement.close(); connection.close(); } catch (Exception e) { e.printStackTrace(); } } }
通过本文的示例代码,我们可以看到如何使用达梦数据库的访问接口进行标准的程序