質問編集履歴
3
追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -133,3 +133,5 @@
|
|
|
133
133
|
}
|
|
134
134
|
|
|
135
135
|
```
|
|
136
|
+
|
|
137
|
+
[参考リンク](http://www.task-notes.com/entry/20150414/1428980400)
|
2
追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -108,7 +108,7 @@
|
|
|
108
108
|
|
|
109
109
|
// MySQLに接続
|
|
110
110
|
|
|
111
|
-
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/
|
|
111
|
+
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/データベース名", "ID", "パスワード");
|
|
112
112
|
|
|
113
113
|
System.out.println("MySQLに接続できました。");
|
|
114
114
|
|
|
@@ -124,11 +124,11 @@
|
|
|
124
124
|
|
|
125
125
|
while(rs.next()){
|
|
126
126
|
|
|
127
|
-
int
|
|
127
|
+
int pass = rs.getInt("pass");
|
|
128
128
|
|
|
129
129
|
String name = rs.getString("name");
|
|
130
130
|
|
|
131
|
-
System.out.println("取得結果 -> " +
|
|
131
|
+
System.out.println("取得結果 -> " + pass + ":" + name);
|
|
132
132
|
|
|
133
133
|
}
|
|
134
134
|
|
1
追加
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -97,3 +97,39 @@
|
|
|
97
97
|
|
|
98
98
|
|
|
99
99
|
何卒よろしくお願いします。
|
|
100
|
+
|
|
101
|
+
|
|
102
|
+
|
|
103
|
+
```
|
|
104
|
+
|
|
105
|
+
// JDBCドライバのロード
|
|
106
|
+
|
|
107
|
+
Class.forName("com.mysql.jdbc.Driver").newInstance();
|
|
108
|
+
|
|
109
|
+
// MySQLに接続
|
|
110
|
+
|
|
111
|
+
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "");
|
|
112
|
+
|
|
113
|
+
System.out.println("MySQLに接続できました。");
|
|
114
|
+
|
|
115
|
+
|
|
116
|
+
|
|
117
|
+
Statement stm = con.createStatement();
|
|
118
|
+
|
|
119
|
+
String sql = "select * from programing";
|
|
120
|
+
|
|
121
|
+
ResultSet rs = stm.executeQuery(sql);
|
|
122
|
+
|
|
123
|
+
|
|
124
|
+
|
|
125
|
+
while(rs.next()){
|
|
126
|
+
|
|
127
|
+
int id = rs.getInt("id");
|
|
128
|
+
|
|
129
|
+
String name = rs.getString("name");
|
|
130
|
+
|
|
131
|
+
System.out.println("取得結果 -> " + id + ":" + name);
|
|
132
|
+
|
|
133
|
+
}
|
|
134
|
+
|
|
135
|
+
```
|