-
Notifications
You must be signed in to change notification settings - Fork 2
/
Books.java
95 lines (85 loc) · 2.91 KB
/
Books.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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
import java.util.Scanner;
import java.sql.*;
public class Books
{
public static void main(String args[])
{
System.out.println("\nEnter 1 - to create the database\n2 - search author\n3 - order information");
Scanner input=new Scanner(System.in);
int s=input.nextInt();
switch(s)
{
case 1 :
System.out.println("\nCreating the books database");
//createdb();
break;
case 2:
searchauthor();
break;
case 3:
orderinformation();
break;
default :
System.out.println("Invalid INPUT");
}
}
private static void orderinformation()
{
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:8080/books","root","myroot");
Statement stmt=con.createStatement();
String sql="SELECT FirstName,Title,Edition,Copyright FROM author INNER JOIN authorisbn ON author.ID = authorisbn.ID INNER JOIN title ON authorisbn.isbn = title.isbn order by Firstname";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4));
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
private static void searchauthor()
{
Scanner input=new Scanner(System.in);
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:8080/books","root","myroot");
Statement stmt=con.createStatement();
System.out.println("Enter the name of the author:");
String authorname=input.nextLine();
String sql="SELECT FirstName,Title,Edition,Copyright FROM author INNER JOIN authorisbn ON author.ID = authorisbn.ID INNER JOIN title ON authorisbn.isbn = title.isbn where FirstName='"+authorname+"'";
//System.out.println(sql);-
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4));
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
private static void createdb()
{
System.out.println("Creating the database..");
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:8080/books","root","myroot");
Statement stmt=con.createStatement();
int rs=stmt.executeUpdate("create table author ( ID int NOT NULL AUTO_INCREMENT,Firstname varchar(255) NOT NULL,Lastname varchar(255),PRIMARY KEY(ID));");
stmt.executeUpdate(" create table Title (ISBN int NOT NULL,Title varchar(255),Edition varchar(255),Copyright varchar(255),PRIMARY KEY (ISBN));");
stmt.executeUpdate("create table Authorisbn (ID int,ISBN int, FOREIGN KEY (ID) REFERENCES author(ID),FOREIGN KEY(ISBN) REFERENCES title(ISBN));");
con.close();
System.out.println("Database successfully created");
}
catch(Exception e)
{
System.out.println(e);
}
}
}