java 代码动态生成临时表
时间: 2024-04-14 14:09:56 浏览: 24
以下是 Java 代码动态生成临时表的示例:
```
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class TempTableExample {
public static void main(String[] args) throws Exception {
// Establish connection to database
String url = "jdbc:mysql://localhost:3306/mydatabase";
String username = "root";
String password = "password";
Connection conn = DriverManager.getConnection(url, username, password);
Statement stmt = conn.createStatement();
// Create temporary table
String sql = "CREATE TEMPORARY TABLE temp_table (id INT, name VARCHAR(50))";
stmt.executeUpdate(sql);
// Insert data into temporary table
sql = "INSERT INTO temp_table VALUES (1, 'John')";
stmt.executeUpdate(sql);
sql = "INSERT INTO temp_table VALUES (2, 'Mary')";
stmt.executeUpdate(sql);
// Query data from temporary table
sql = "SELECT * FROM temp_table";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
System.out.println("id: " + id + ", name: " + name);
}
// Drop temporary table
sql = "DROP TEMPORARY TABLE temp_table";
stmt.executeUpdate(sql);
// Close connection
rs.close();
stmt.close();
conn.close();
}
}
```
在这个示例中,我们通过 JDBC 连接到数据库并创建了一个临时表 `temp_table`。然后,我们向临时表中插入了两行数据,并从临时表中查询了所有数据并打印结果。最后,我们删除了临时表并关闭了连接。