package test;
import java.sql.*; 
public class sql2 {int n;
	public int execsql(String query){
	String dbURL="jdbc:odbc:student"; 
	
	Statement stmt = null;



	String userName = "sa"; 
	String userPwd = ""; 
	Connection con;

	try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 

	con = DriverManager.getConnection(dbURL, userName, userPwd); 
	System.out.println("Connection Successful!"); 
	stmt = con.createStatement();
	n=stmt.executeUpdate(query);
	
	
	
	} 
	catch(Exception e) { 
	e.printStackTrace(); 
	}
		
		

		
		
		
		
		
		return n;
		
		
		
	}

}