Advertisement
Guest User

Database akhtersir

a guest
Feb 6th, 2017
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. package nn;
  2.  
  3. import java.sql.*;
  4.  
  5. public class newa {
  6. public static void main(String[] args) throws Exception {
  7.  
  8.  
  9. String driver="com.mysql.jdbc.Driver";
  10. String dburl = "jdbc:mysql://localhost:3306/student";
  11. String user= "root";
  12. String pass="";
  13. Connection con;
  14.  
  15. Statement stmt;
  16. ResultSet rs;
  17. String sql = "Select * from student_info";
  18.  
  19. Class.forName(driver);
  20.  
  21. con = DriverManager.getConnection(dburl,user,pass);
  22.  
  23. if(con!=null)
  24. System.out.println("ok");
  25.  
  26. else
  27. System.out.println("not ok");
  28.  
  29. stmt =con.createStatement();
  30. rs =stmt.executeQuery(sql);
  31. System.out.println("ID name cgpa");
  32. while(rs.next()){
  33. System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getFloat(3));
  34. }
  35.  
  36. }
  37.  
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement