forked from AndrewProgramming/JavaTutorialCode
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathJDBCMysqlDemo.java
More file actions
49 lines (36 loc) · 1.5 KB
/
JDBCMysqlDemo.java
File metadata and controls
49 lines (36 loc) · 1.5 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
package database;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;
public class JDBCMysqlDemo {
public static void main(String[] args) throws SQLException {
String SQL_SELECT = "select * from Course";
Connection conn = DriverManager.
getConnection("jdbc:mysql://127.0.0.1:3306/jdbc_demo", "root", "my-secret-pw");
if (conn != null) {
System.out.println("Connected to the database!");
} else {
System.out.println("Failed to make connection!");
}
PreparedStatement preparedStatement = conn.prepareStatement(SQL_SELECT);
ResultSet resultSet = preparedStatement.executeQuery();
//POJO
List<Course> courseList = new ArrayList<>();
while (resultSet.next()) {
String courseId = resultSet.getString("courseId");
String subjectId = resultSet.getString("subjectId");
String courseNumber = resultSet.getString("courseNumber");
String title = resultSet.getString("title");
String numOfCredits = resultSet.getString("numOfCredits");
Course instance = new Course();
instance.setCourseId(courseId);
instance.setSubjectId(subjectId);
instance.setCourseNumber(courseNumber);
instance.setTitle(title);
instance.setNumOfCredits(numOfCredits);
courseList.add(instance);
}
System.out.println(courseList);
conn.close();
}
}