package com.ConnectionSQL;
import java.sql.*;
public class Demo1
{
Connection ct = null;
PreparedStatement ps= null;
ResultSet rs = null;
static final String JDBC_Driver = "com.mysql.jdbc.Driver";
static final String Database_URL ="jdbc:mysql://localhost:3306/mayan";
static final String user = "root";
static final String Password = "mayan1992";
public static void main(String[] args)
{
// TODO Auto-generated method stub
Demo1 d = new Demo1();
d.connectedSQl();
}
public void connectedSQl()
{
try
{
Class.forName(JDBC_Driver);
ct = DriverManager.getConnection(Database_URL,user,Password);
String sql = "Select * from websites";
ps = ct.prepareStatement(sql);
rs = ps.executeQuery();
while(rs.next())
{
int id = rs.getInt(1);
String name = rs.getString(2);
String url = rs.getString(3);
int alex = rs.getInt(4);
String country = rs.getString(5);
System.out.println(" id: "+id +" , "+" name: "+name+" , "+" url: "+url+" , "+" alex: " + alex + " , "+" country: "+country );
}
}
catch (Exception e)
{
// TODO: handle exception
}
finally
{
this.close();
}
}
public void close()
{
if(rs!=null)
try
{
if(rs != null) rs.close();
if(ps != null) ps.close();
if(ct != null) ct.close();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}