-
Notifications
You must be signed in to change notification settings - Fork 0
/
App.java
25 lines (24 loc) · 896 Bytes
/
App.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
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
class App {
public static void main(String ar[]){
try{
System.out.println("Database Tutorial");
Class.forName("com.mysql.cj.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sys", "root", "password123A$");
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet rs=st.executeQuery("select * from student");
System.out.println("Database Connected");
rs.first();
do {
System.out.println("ID is "+rs.getInt(1)+" Name is "+rs.getString(2));
} while (rs.next());
}
catch(Exception e)
{
System.out.println(e);
}
}
}