Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit15ffcff

Browse files
committed
JDBC
1 parent5fc2551 commit15ffcff

File tree

8 files changed

+393
-0
lines changed

8 files changed

+393
-0
lines changed

‎JDBC/1_Program.java‎

Lines changed: 28 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,28 @@
1+
importjava.sql.*;
2+
3+
classJDBCDemo {
4+
5+
publicstaticvoidmain(String[]args)throwsClassNotFoundException {
6+
7+
Stringurl ="jdbc:mysql://localhost:3306/College";
8+
Stringusr ="root";
9+
Stringpwd ="Dhiraj@7465";
10+
11+
try {
12+
13+
//Class.forName("com.mysql.cj.jdbc.Driver");
14+
Connectioncon =DriverManager.getConnection(url,usr,pwd);
15+
16+
if(con.isClosed()) {
17+
18+
System.out.println("Connection is Closed");
19+
}else {
20+
21+
System.out.println("Connection is Created");
22+
}
23+
}catch(SQLExceptions) {
24+
25+
s.printStackTrace();
26+
}
27+
}
28+
}

‎JDBC/2_CreateTable.java‎

Lines changed: 32 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,32 @@
1+
importjava.sql.*;
2+
3+
classCreateTable {
4+
5+
publicstaticvoidmain(String[]args) {
6+
7+
Stringurl ="jdbc:mysql://localhost:3306/College";
8+
Stringusr ="root";
9+
Stringpwd ="Dhiraj@7465";
10+
11+
try {
12+
13+
Class.forName("com.mysql.cj.jdbc.Driver");
14+
15+
Connectioncon =DriverManager.getConnection(url,usr,pwd);
16+
17+
Statementsmt =con.createStatement();
18+
Stringquery ="Create Table Student(Roll_No int(4) not null, Name varchar(100) not null, marks float not null, city varchar(50), grade varchar(2))";
19+
20+
smt.executeUpdate(query);
21+
System.out.println("Table Created...");
22+
23+
con.close();
24+
}catch(ClassNotFoundExceptioncnf) {
25+
26+
System.out.println("Class Not Found...");
27+
}catch(Exceptionse) {
28+
29+
se.toString();
30+
}
31+
}
32+
}

‎JDBC/3_InsertValueInTable.java‎

Lines changed: 79 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,79 @@
1+
2+
importjava.io.*;
3+
importjava.sql.*;
4+
5+
classInsertValue {
6+
7+
voidaddData(Connectioncon) {
8+
9+
BufferedReaderbr =newBufferedReader(newInputStreamReader(System.in));
10+
11+
introllno =0;
12+
Stringname =null;
13+
floatmarks =0.0f;
14+
Stringcity =null;
15+
Stringgrade =null;
16+
try {
17+
System.out.print("Enter Roll No : ");
18+
rollno =Integer.parseInt(br.readLine());
19+
20+
System.out.print("Enter Name : ");
21+
name =br.readLine();
22+
23+
System.out.print("Enter Marks : ");
24+
marks =Float.parseFloat(br.readLine());
25+
26+
System.out.print("Enter City : ");
27+
city =br.readLine();
28+
29+
System.out.print("Enter Grade : ");
30+
grade =br.readLine();
31+
32+
}catch(IOExceptionioe) {
33+
34+
ioe.printStackTrace();
35+
}
36+
try {
37+
Stringq ="Insert into Student (Name, marks, city, grade) value (?, ?, ?, ?)";
38+
39+
PreparedStatementpsmt =con.prepareStatement(q);
40+
41+
//psmt.setInt(1, rollno);
42+
psmt.setString(1,name);
43+
psmt.setFloat(2,marks);
44+
psmt.setString(3,city);
45+
psmt.setString(4,grade);
46+
47+
intnum =psmt.executeUpdate();
48+
49+
System.out.println("No row Affected : " +num);
50+
con.close();
51+
}catch(SQLIntegrityConstraintViolationExceptione) {
52+
53+
System.out.println("Enter Different Roll no : ");
54+
}catch(Exceptione) {
55+
56+
e.printStackTrace();
57+
}
58+
59+
}
60+
publicstaticvoidmain(String[]args) {
61+
62+
InsertValueiv =newInsertValue();
63+
Stringurl ="jdbc:mysql://localhost:3306/College";
64+
Stringusr ="root";
65+
Stringpwd ="Dhiraj@7465";
66+
67+
try {
68+
69+
Class.forName("com.mysql.cj.jdbc.Driver");
70+
Connectioncon =DriverManager.getConnection(url,usr,pwd);
71+
72+
iv.addData(con);
73+
con.close();
74+
}catch(Exceptione) {
75+
76+
e.printStackTrace();
77+
}
78+
}
79+
}

‎JDBC/4_ImageInsert.java‎

Lines changed: 31 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,31 @@
1+
importjava.sql.*;
2+
importjava.io.*;
3+
classImageInsert {
4+
5+
publicstaticvoidmain(String[]args) {
6+
7+
Stringurl ="jdbc:mysql://localhost:3306/College";
8+
Stringusr ="root";
9+
Stringpwd ="Dhiraj@7465";
10+
try {
11+
12+
Class.forName("com.mysql.cj.jdbc.Driver");
13+
14+
Connectioncon =DriverManager.getConnection(url,usr,pwd);
15+
16+
Stringq ="Insert into StudentImage (image) value(?)";
17+
18+
PreparedStatementpsmt =con.prepareStatement(q);
19+
20+
FileInputStreamfile =newFileInputStream("profile.jpeg");
21+
22+
psmt.setBinaryStream(1,file,file.available());
23+
24+
intnum =psmt.executeUpdate();
25+
System.out.println(num);
26+
con.close();
27+
}catch(Exceptione) {
28+
29+
}
30+
}
31+
}

‎JDBC/5_UpdateQuery.java‎

Lines changed: 38 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,38 @@
1+
importjava.io.*;
2+
importjava.sql.*;
3+
4+
classUpdateData {
5+
6+
publicstaticvoidmain(String[]args)throwsIOException {
7+
8+
BufferedReaderbr =newBufferedReader(newInputStreamReader(System.in));
9+
Stringurl ="jdbc:mysql://localhost:3306/College";
10+
Stringusr ="root";
11+
Stringpwd ="Dhiraj@7465";
12+
try {
13+
Class.forName("com.mysql.cj.jdbc.Driver");
14+
Connectioncon =DriverManager.getConnection(url,usr,pwd);
15+
16+
Stringq ="Update Student Set grade = ? where Roll_No = ?";
17+
18+
PreparedStatementpsmt =con.prepareStatement(q);
19+
20+
System.out.println("Enter New Grade : ");
21+
Stringgrade =br.readLine();
22+
23+
System.out.println("Enter Roll_No : ");
24+
intRoll_No =Integer.parseInt(br.readLine());
25+
26+
psmt.setString(1,grade);
27+
psmt.setInt(2,Roll_No);
28+
29+
intnum =psmt.executeUpdate();
30+
31+
System.out.println(num);
32+
33+
con.close();
34+
}catch(Exceptione) {
35+
36+
}
37+
}
38+
}

‎JDBC/6_SelectQuery.java‎

Lines changed: 29 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,29 @@
1+
importjava.sql.*;
2+
3+
classSelectQuery {
4+
5+
publicstaticvoidmain(String[]args) {
6+
7+
Stringurl ="jdbc:mysql://localhost:3306/College";
8+
Stringusr ="root";
9+
Stringpwd ="Dhiraj@7465";
10+
11+
try {
12+
13+
Class.forName("com.mysql.cj.jdbc.Driver");
14+
Connectioncon =DriverManager.getConnection(url,usr,pwd);
15+
16+
Statementstmt =con.createStatement();
17+
ResultSetset =stmt.executeQuery("Select * from Student");
18+
19+
while(set.next()) {
20+
21+
System.out.println(set.getInt(1) +" : " +set.getString(2) +" : " +set.getFloat(3) +" : " +set.getString(4) +" : " +set.getString(5));
22+
}
23+
con.close();
24+
}catch(Exceptionobj) {
25+
26+
27+
}
28+
}
29+
}

‎JDBC/7_AggregateFunctions.java‎

Lines changed: 156 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,156 @@
1+
importjava.sql.*;
2+
importjava.io.*;
3+
classAggregateFunction {
4+
5+
privatestaticConnectioncon;
6+
7+
inttotalStudents() {
8+
9+
Stringq ="Select count(Name) from Student";
10+
try {
11+
Statementstmt =con.createStatement();
12+
13+
ResultSetset =stmt.executeQuery(q);
14+
if(set.next()) {
15+
16+
returnset.getInt(1);
17+
}
18+
}catch(Exceptione) {
19+
20+
e.printStackTrace();
21+
}
22+
return -1;
23+
}
24+
floatavgMarks() {
25+
26+
Stringq ="Select avg(marks) from Student";
27+
try {
28+
Statementstmt =con.createStatement();
29+
30+
ResultSetset =stmt.executeQuery(q);
31+
if(set.next()) {
32+
33+
returnset.getFloat(1);
34+
}
35+
}catch(Exceptione) {
36+
37+
e.printStackTrace();
38+
}
39+
return0.0f;
40+
}
41+
voidmaxMarksDetails() {
42+
43+
44+
Stringq ="Select * from Student where marks = (Select max(marks) from Student)";
45+
try {
46+
Statementstmt =con.createStatement();
47+
48+
ResultSetset =stmt.executeQuery(q);
49+
if(set.next()) {
50+
51+
System.out.println("Roll No : " +set.getInt(1));
52+
System.out.println("Name : " +set.getString(2));
53+
System.out.println("Marks : " +set.getFloat(3));
54+
System.out.println("City : " +set.getString(4));
55+
System.out.println("Grade : " +set.getString(5));
56+
}else {
57+
58+
System.out.println("Student Not Found....!");
59+
}
60+
}catch(Exceptione) {
61+
62+
e.printStackTrace();
63+
}
64+
}
65+
voidminMarksDetails() {
66+
67+
Stringq ="Select * from Student where marks = (Select min(marks) from Student)";
68+
try {
69+
Statementstmt =con.createStatement();
70+
71+
ResultSetset =stmt.executeQuery(q);
72+
if(set.next()) {
73+
74+
System.out.println("Roll No : " +set.getInt(1));
75+
System.out.println("Name : " +set.getString(2));
76+
System.out.println("Marks : " +set.getFloat(3));
77+
System.out.println("City : " +set.getString(4));
78+
System.out.println("Grade : " +set.getString(5));
79+
}else {
80+
81+
System.out.println("Student Not Found....!");
82+
}
83+
}catch(Exceptione) {
84+
85+
e.printStackTrace();
86+
}
87+
}
88+
floatsumMarks() {
89+
90+
Stringq ="Select sum(marks) from Student";
91+
try {
92+
Statementstmt =con.createStatement();
93+
94+
ResultSetset =stmt.executeQuery(q);
95+
if(set.next()) {
96+
97+
returnset.getFloat(1);
98+
}
99+
}catch(Exceptione) {
100+
101+
e.printStackTrace();
102+
}
103+
return0.0f;
104+
}
105+
publicstaticvoidmain(String[]args)throwsIOException{
106+
107+
BufferedReaderbr =newBufferedReader(newInputStreamReader(System.in));
108+
AggregateFunctionobj =newAggregateFunction();
109+
110+
Stringurl ="jdbc:mysql://localhost:3306/College";
111+
Stringusr ="root";
112+
Stringpwd ="Dhiraj@7465";
113+
try {
114+
115+
con =DriverManager.getConnection(url,usr,pwd);
116+
charch;
117+
do {
118+
119+
System.out.println("1. Count of Total Students : ");
120+
System.out.println("2. Average of Student Marks : ");
121+
System.out.println("3. Max Marks Student Details : ");
122+
System.out.println("4. Min Marks Student Details : ");
123+
System.out.println("5. Sum of Student Marks :\n");
124+
125+
System.out.println("Enter your Choice : ");
126+
intchoice =Integer.parseInt(br.readLine());
127+
128+
switch(choice) {
129+
130+
case1 :
131+
System.out.println("Total Student Count : " +obj.totalStudents() +"\n");
132+
break;
133+
case2 :
134+
System.out.println("Average of Student Marks: " +obj.avgMarks() +"\n");
135+
break;
136+
case3 :
137+
obj.maxMarksDetails();
138+
break;
139+
case4 :
140+
obj.minMarksDetails();
141+
break;
142+
case5 :
143+
System.out.println("Sum of Student Marks : " +obj.sumMarks() +"\n");
144+
break;
145+
default :
146+
System.out.println("Wrong Choice");
147+
}
148+
System.out.println("Do want Continue : ");
149+
ch = (char)br.readLine().charAt(0);
150+
}while(ch =='Y' ||ch =='y');
151+
}catch(Exceptione) {
152+
153+
e.printStackTrace();
154+
}
155+
}
156+
}

‎JDBC/profile.jpeg‎

17.6 KB
Loading

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp