Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package dbms_basic;
- import java.sql.*;
- public class Dbms_Basic {
- public static void main(String[] args) {
- // TODO code application logic here
- Connection con=null;
- Statement stmt=null;
- String url="jdbc:mysql://localhost:3306/student";
- String user="root";
- String pass="system";
- try {
- Class.forName("com.mysql.jdbc.Driver");
- System.out.println("Now connecting to databse...n");
- con=DriverManager.getConnection(url,user,pass);
- System.out.println("Connected !!!n");
- stmt=con.createStatement();
- System.out.println("Asking for query...n");
- ResultSet rs=stmt.executeQuery("select * from cse");
- System.out.println("we got it !!!n");
- System.out.println("Time to display it...n");
- while(rs.next())
- {
- System.out.println(rs.getInt(1)+" "+rs.getString(2));
- }
- System.out.println("ok it's done !!!n");
- stmt.close();
- con.close();
- System.out.println("connection close !!!n");
- } catch (ClassNotFoundException | SQLException e) {System.out.println(e);}
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement