如何将原生JDBC连接数据库的操作改写为一个长尾词？

本文共计175个文字，预计阅读时间需要1分钟。

javaimport java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;

public class JdbcConn { public static void main(String[] args) { try { Class.forName(com.mysql.jdbc.Driver); Connection conn=DriverManager.getConnection(jdbc:mysql://localhost:3306/database_name, username, password); PreparedStatement statement=conn.prepareStatement(SELECT * FROM table_name); ResultSet resultSet=statement.executeQuery();

while (resultSet.next()) { // Process the result set }

resultSet.close(); statement.close(); conn.close(); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } }}

JDBC.java

import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class JdbcConn { public static void main(String[] args) throws ClassNotFoundException, SQLException { Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.111.11.111:1557/ecidb", "ECIS", "ECIS"); String sql = ""; PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, "0001"); ResultSet rs = pstmt.executeQuery(""); while (rs.next()) { System.out.println(rs.getInt(1) + "-" + rs.getString(2)); } rs.close(); pstmt.close(); conn.close(); } }