Advertisement
sagunsh

Java-jdbc

Jul 11th, 2017
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.79 KB | None | 0 0
  1. import java.sql.*;
  2. public class DatabaseDemo {
  3.    
  4.     public static void main(String[] args) throws SQLException, ClassNotFoundException {
  5.         /* Creating connection*/
  6.         Class.forName("com.mysql.jdbc.Driver");
  7.         Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/java","root","pass");
  8.        
  9.     /* Creating statement */
  10.         Statement stm = conn.createStatement();
  11.        
  12.     /* Executing queries */
  13.         String sql1 = "SELECT * FROM STUDENT WHERE DISTRICT = 'KATHMANDU' ";
  14.         ResultSet rs = stm.executeQuery(sql1);
  15.        
  16.     /* Processing resultset */
  17.         while(rs.next()){
  18.             String name = rs.getString("name");
  19.             System.out.println("Name  : " + name);
  20.         }
  21.    
  22.     /* Closing connection */
  23.     stm.close();
  24.     }
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement