package javaapplication1;
import java.sql.*;
public class jdboupdate {
    public static void main(String[] args) throws Exception {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        Connection con = DriverManager.getConnection("jdbc:sqlserver://BTR3-PC6;databasename=poru;"
                +"user=sa;password=aptech");
        con.setAutoCommit(false);
        Statement st = con.createStatement();
        st.addBatch("insert into Person3 values('13','name1','email1','25','4000'");
        st.addBatch("insert into Person3 values('14','name2','email2','26','5000'");
        st.addBatch("insert into Person3 values('15','name3','email3','27','6000'");
        st.addBatch("insert into Person3 values('16','name4','email4','28','8000'");
        st.executeBatch();
        con.commit();con.setAutoCommit(true);
        System.out.println("Four Record inserted to database successfully");
    }
}