Getting Started with SQLite"INSERT INTO Person(first_name, last_name, birth_date) VALUES (?, ?, ?)"; try (PreparedStatement pstmt = conn.prepareStatement(sql)) { pstmt.setString(1, "Bob"); are not hardcoding any value, but can change the value at runtime. Line 7 We instantiate a PreparedStatement, which is needed to execute the parameterized SQL. By passing the SQL string as an argument "INSERT INTO Person(first_name, last_name, birth_date) VALUES (?, ?, ?)"; try (PreparedStatement pstmt = conn.prepareStatement(sql)) { pstmt.setString(parameterIndex: 1, x: "Bob");0 码力 | 43 页 | 1.03 MB | 2 年前3- TiDB v6.1 Documentation```java import com.mysql.cj.jdbc.MysqlDataSource; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.*; /** * Main Connection connection = null; PreparedStatement preparedStatement = null; try { connection = ds.getConnection(); preparedStatement = connection.prepareStatement("INSERT players) { preparedStatement.setString(1, player.getId()); preparedStatement.setInt(2, player.getCoins()); preparedStatement.setInt(3, player.getGoods());0 码力 | 4487 页 | 84.44 MB | 2 年前3
- TiDB v7.5 DocumentationgetConnection()) { PreparedStatement preparedStatement = connection.prepareStatement( "INSERT INTO player (id, coins, goods) VALUES (?, ?, ?)"); preparedStatement.setString(1, player player.getId()); preparedStatement.setInt(2, player.getCoins()); preparedStatement.setInt(3, player.getGoods()); ```  ```java preparedStatement.execute(); } } ``` For more information, refer to Insert data. Query data ```java public void getPlayer(String id) throws SQLException {0 码力 | 6020 页 | 106.82 MB | 2 年前3
- TiDB v8.2 DocumentationgetConnection()) { PreparedStatement preparedStatement = connection.prepareStatement( "INSERT INTO player (id, coins, goods) VALUES (?, ?, ?)"); preparedStatement.setString(1, player player.getId()); preparedStatement.setInt(2, player.getCoins()); preparedStatement.setInt(3, player.getGoods()); preparedStatement.execute(); } } For more information getConnection()) { PreparedStatement preparedStatement = connection.prepareStatement( "SELECT * FROM player WHERE id = ?"); preparedStatement.setString(1, id);0 码力 | 6549 页 | 108.77 MB | 1 年前3
- TiDB v8.1 DocumentationgetConnection()) { PreparedStatement preparedStatement = connection.prepareStatement( "INSERT INTO player (id, coins, goods) VALUES (?, ?, ?)"); preparedStatement.setString(1, player player.getId()); preparedStatement.setInt(2, player.getCoins()); preparedStatement.setInt(3, player.getGoods()); ```  ```java preparedStatement.execute(); } } ``` For more information, refer to Insert data. Query data ```java public void getPlayer(String id) throws SQLException {0 码力 | 6321 页 | 107.46 MB | 2 年前3
- TiDB v6.5 DocumentationgetConnection()) { PreparedStatement preparedStatement = connection.prepareStatement( "INSERT INTO player (id, coins, goods) VALUES (?, ?, ?)"); preparedStatement.setString(1, player player.getId()); preparedStatement.setInt(2, player.getCoins()); preparedStatement.setInt(3, player.getGoods()); preparedStatement.execute(); } } ``` For more information getConnection()) { PreparedStatement preparedStatement = connection.prepareStatement( "→ SELECT * FROM player WHERE id = ?"); preparedStatement.setString(1, id);0 码力 | 5282 页 | 99.69 MB | 2 年前3
- TiDB v7.6 DocumentationgetConnection()) { PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO player (id, coins, goods) VALUES (?, ?, ?)"); preparedStatement.setString(1, player.getId()); getId()); preparedStatement.setInt(2, player.getCoins()); preparedStatement.setInt(3, player.getGoods()); preparedStatement.execute(); } } For more information, refer PreparedStatement preparedStatement = connection.prepareStatement("SELECT * FROM player WHERE id = ?"); preparedStatement.setString(1, id); preparedStatement.execute();0 码力 | 6123 页 | 107.24 MB | 2 年前3
- TiDB v8.1 DocumentationgetConnection()) { PreparedStatement preparedStatement = connection.prepareStatement( "INSERT INTO player (id, coins, goods) VALUES (?, ?, ?)"); preparedStatement.setString(1, player player.getId()); preparedStatement.setInt(2, player.getCoins()); preparedStatement.setInt(3, player.getGoods()); preparedStatement.execute(); } } For more information getConnection()) { PreparedStatement preparedStatement = connection.prepareStatement( "→ SELECT * FROM player WHERE id = ?"); preparedStatement.setString(1, id);0 码力 | 6479 页 | 108.61 MB | 1 年前3
- TiDB v6.1 中文手册pingcap; import com.mysql.cj.jdbc.MysqlDataSource; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.*; /** * Main Connection connection = null; PreparedStatement preparedStatement = null; try { connection = ds.getConnection(); preparedStatement = connection.prepareStatement("INSERT player : players) { preparedStatement.setString(1, player.getId()); preparedStatement.setInt(2, player.getCoins()); preparedStatement.setInt(3, player.getGoods());0 码力 | 3572 页 | 84.36 MB | 2 年前3
- TiDB v7.1 DocumentationgetConnection()) { PreparedStatement preparedStatement = connection.prepareStatement( "INSERT INTO player (id, coins, goods) VALUES (?, ?, ?)"); preparedStatement.setString(1, player player.getId()); preparedStatement.setInt(2, player.getCoins()); preparedStatement.setInt(3, player.getGoods()); ```  ```java preparedStatement.execute(); } } ``` For more information, refer to Insert data. Query data ```java public void getPlayer(String id) throws SQLException {0 码力 | 5716 页 | 104.74 MB | 2 年前3
共 120 条
- 1
- 2
- 3
- 4
- 5
- 6
- 12