package mysqlcnx;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;

public class Connexion {

	public static void main(String[] args) {
		Connection connect=null;
		Statement statement=null;
		PreparedStatement preparedStatement=null;
		ResultSet resultSet=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			connect=DriverManager.getConnection("jdbc:mysql://localhost/myinfo?"+"user=root&password=12345");
			statement=connect.createStatement();
			// add to db
			connect.prepareStatement("insert into user(name,email) values('mohamed','yassine@hotmail.fr')").executeUpdate();
			// read from db
			resultSet=statement.executeQuery("select * from user");
			while(resultSet.next()) {
				String name=resultSet.getString("name");
				String email=resultSet.getString("email");
				System.out.println("name :"+name+"  email :"+email);
			}
		}catch(Exception ex) {
			ex.printStackTrace();
		}

	}

}