-
Notifications
You must be signed in to change notification settings - Fork 1
/
Jdbc11.java
76 lines (55 loc) · 2.03 KB
/
Jdbc11.java
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
package edu.shu.nlt.twitter.database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* Currently unused class
*
* @author shu
*
*/
public class Jdbc11 {
static final String mySqlServerLocation = "127.0.0.1:3306";
static final String mySqlUserName = "root";
static final String mySqlUserPwd = "direwolf";
private static Connection GetConnection(String path) throws SQLException {
return DriverManager.getConnection("jdbc:mysql://" + mySqlServerLocation + "/" + path, "root", "direwolf");
}
public static void CreateDB(String dbName) {
try {
Connection con = GetConnection("mysql");
Statement stmt = con.createStatement();
stmt.executeUpdate("CREATE DATABASE " + dbName);
con.close();
} catch (SQLException e) {
}
}
public static void DoSomethingNew(String dbName) {
Connection con;
try {
con = GetConnection("JunkDB");
Statement stmt = con.createStatement();
try {
stmt.executeUpdate("DROP TABLE myTable");
} catch (SQLException e) {
System.out.println("No existing table to delete");
}
stmt.executeUpdate("CREATE TABLE myTable(test_id int," + "test_val char(15) not null)");
stmt.executeUpdate("INSERT INTO myTable(test_id, " + "test_val) VALUES(1,'One')");
stmt.executeUpdate("INSERT INTO myTable(test_id, " + "test_val) VALUES(2,'Two')");
stmt.executeUpdate("INSERT INTO myTable(test_id, " + "test_val) VALUES(3,'Three')");
stmt.executeUpdate("INSERT INTO myTable(test_id, " + "test_val) VALUES(4,'Four')");
stmt.executeUpdate("INSERT INTO myTable(test_id, " + "test_val) VALUES(5,'Five')");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
} catch (SQLException e1) {
e1.printStackTrace();
}
}
public static void main(String args[]) throws Exception {
Class.forName("com.mysql.jdbc.Driver");
CreateDB("JunkDB");
DoSomethingNew("JunkDB");
}
}