import java.sql.*;
public class StudentDemo
{
	
	
	public static void main(String[] args)
		{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("Driver loaded");
			Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","");
			System.out.println("Connection created");
			Statement stmt = con.createStatement();
			String sql = "create table student(roll_no int(10),sname varchar(30),branch varchar(30))";
			stmt.executeUpdate(sql);
			System.out.println("Table created");
			sql = "insert into student values(1212,'ABCD','CM')";
			stmt.executeUpdate(sql);
			System.out.println("Record inserted");
			stmt.close();
			con.close();
		}
		catch(Exception e)
		{
			System.out.println(e);
		}
	}
}