-
Notifications
You must be signed in to change notification settings - Fork 52
Expand file tree
/
Copy pathVaccineReport.java
More file actions
38 lines (30 loc) · 1.24 KB
/
VaccineReport.java
File metadata and controls
38 lines (30 loc) · 1.24 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
// Importing required classes
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class VaccineReport {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//Read user input
Scanner sc = new Scanner(System.in);
System.out.println("Enter vaccine name to see data");
String vacName = sc.nextLine();
System.out.println("You choose " + vacName + " vaccine! Available vaccine centers are: ");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/vaccineDB", "root", "anushkaraj@11");
//Create a statement
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from data where vacName ='" + vacName + "' ");
while (rs.next()) {
String vaccineCenterName = rs.getString("vacCtName");
System.out.println(vaccineCenterName);
}
con.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}