-
Notifications
You must be signed in to change notification settings - Fork 103
Expand file tree
/
Copy pathUpdateData.java
More file actions
50 lines (41 loc) · 1.78 KB
/
UpdateData.java
File metadata and controls
50 lines (41 loc) · 1.78 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
import java.sql.*;
import java.lang.*;
public class UpdateData {
public static void main(String args[]) {
try {
Connection conn = null;
Statement stmt = null;
String DB_URL = "jdbc:sqlite:/tempfs/db";
System.setProperty("org.sqlite.tmpdir", "/tempfs");
String query="";
// Open a connection
conn = DriverManager.getConnection(DB_URL);
stmt = conn.createStatement();
// The statement containing SQL command to create table "players"
String CREATE_TABLE_SQL="CREATE TABLE players (UID INT, First_Name VARCHAR(45), Last_Name VARCHAR(45), Age INT);";
// Execute the statement containing SQL command
stmt.executeUpdate(CREATE_TABLE_SQL);
query = " insert into PLAYERS (UID, first_name, last_name, age)" + " values (?, ?, ?, ?)";
PreparedStatement preparedStmt = conn.prepareStatement(query);
preparedStmt.setInt (1, 1);
preparedStmt.setString (2, "Ram");
preparedStmt.setString (3, "Gopal");
preparedStmt.setInt(4, 26);
preparedStmt.execute();
preparedStmt.setInt (1, 2);
preparedStmt.setString (2, "John");
preparedStmt.setString (3, "Mayer");
preparedStmt.setInt(4, 22);
preparedStmt.execute();
// write SQL command to update table data
query = " UPDATE Players SET First_name ='Rama',Last_name = 'Gopala', Age = 24 WHERE UID=1;";
// Execute the SQL command to update the table data
stmt.executeUpdate(query);
ResultSet rs = stmt.executeQuery("SELECT * FROM players;");
while(rs.next())
System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4));
conn.close();
}
catch(Exception e){ System.out.println(e);}
}
}