-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathJDBC.java
More file actions
125 lines (108 loc) · 5.44 KB
/
JDBC.java
File metadata and controls
125 lines (108 loc) · 5.44 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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
import java.sql.*;
public class JDBC{
public static MySQL(){
// Log in information
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:3306/mysql";
String user = "root";
String password = "";
try{
// Building connections...
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password);
if (!conn.isClosed()) System.out.println("Succeeded connecting to the Database!");
Statement statement = conn.createStatement();
String sql = "select * from db limit 10 ";
ResultSet rs = statement.executeQuery(sql);
while (rs.next()){
String name = rs.getString("Host");
System.out.println(rs.getString("DB") + "\t" + name);
}
rs.close();
conn.close();
}catch(ClassNotFoundException e){
System.out.println("Sorry,can`t find the Driver!");
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}
}
public static JavaDB(){
// Log in information
String driver="org.apache.derby.jdbc.ClientDriver";
String url="jdbc:derby://localhost:1527/sample";
String user="app";
String passwd="app";
try{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, passwd);
if (!conn.isClosed()) System.out.println("Succeeded connecting to the Database!");
Statement stat = conn.createStatement();
ResultSet rs = stat.executeQuery("select * from CUSTOMER");
while (rs.next()) {
System.out.println("name = " + rs.getString("NAME"));
System.out.println("email = " + rs.getString("EMAIL"));
}
rs.close();
conn.close();
} catch(ClassNotFoundException e) {
System.out.println("Sorry,can`t find the Driver!");
e.printStackTrace();
} catch(SQLException e) {
e.printStackTrace();
} catch(Exception e) {
e.printStackTrace();
}
public static SQLServer(){
String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=TestDB;user=sa;password=xxxxxxxx";
try{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url);
if (!conn.isClosed()) System.out.println("Succeeded connecting to the Database!");
Statement statement = conn.createStatement();
String sql = "select * from Book";
ResultSet rs = statement.executeQuery(sql);
while (rs.next()) {
String name = rs.getString("ISBN");
System.out.println(rs.getString(2) + "\t" + name);
}
rs.close();
conn.close();
} catch(ClassNotFoundException e) {
System.out.println("Sorry,can`t find the Driver!");
e.printStackTrace();
} catch(SQLException e) {
e.printStackTrace();
} catch(Exception e) {
e.printStackTrace();
}
}
public static Sqlite(){
String driver="org.sqlite.JDBC";
String url="jdbc:sqlite:d:/test3.db";
Class.forName(driver);
Connection conn = DriverManager.getConnection(url);
Statement stat = conn.createStatement();
// Updates
stat.executeUpdate("create table if not exists people (id char(10), name char(20), age int, gender bit ) ;");
stat.executeUpdate("insert into people values ('001', 'Tom', 18, 1);");
stat.executeUpdate("insert into people values ('002', 'Marry', 20, 0);");
stat.executeUpdate("insert into people values ('003', 'Peter', 25, 1);");
stat.executeUpdate("update people set age=age+1 whre id='003';");
conn.commit();
// Query
String sql = "select * from people;";
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String name = rs.getString("name");
int age = rs.getString("age");
boolean gender = rs.getBoolean(4);
System.out.printf("name = %s; occupation = %s\n", name, occupation);
}
rs.close();
conn.close();
}
}