import java.sql.*;
public class Test {
	private String query;
	private Statement s;
	private Connection c;
	private ResultSet rs;
	private PreparedStatement ps;
	public Test(){

		this.c=null;
		this.ps=null;
		this.rs=null;
		this.s=null;
		query=new String();
	}
	public void Connection() throws Exception{
		Class.forName("com.mysql.jdbc.Driver");
		c=DriverManager.getConnection("jdbc:mysql://localhost/db1?user=root");
		s=c.createStatement();

	}
	public void Create() throws Exception{

		query="create table SC(id int not null,name varchar(25),Address varchar(40),Primary Key(id));";
		s.executeUpdate(query);
	}
	public void Insert() throws Exception{
		 query="insert into SC values(1,'cclass','303-B1')";
		 s.executeUpdate(query);
	}
	public void Select() throws Exception{
		 query= "select *from SC";
		 rs=s.executeQuery(query);
		 while(rs.next())
		 {
			 System.out.println(rs.getInt("id")+" "+rs.getString("name")+" "+rs.getString("Address"));
			 }
		 }
	public void Update() throws Exception{
		query="Update SC set name= 'waleed' where id=1;";
		s.executeUpdate(query);
	}

public static void main(String agrs[]) throws Exception{

	Test t=new Test();
	t.Connection();
	t.Update();

}
}