import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.sql.*;

	public class DBExample2 {

		public static void main(String[] args) {
			List<String> list1 = GetAllProductName();
			for (String item : list1) {
				System.out.println(item);
			}
			InsertProduct("6", "Product 6");
			list1 = GetAllProductName();
			for (String item : list1) {
				System.out.println(item);
			}
		}

		public static List<String> GetAllProductName() {
			Connection conn = null;
			ArrayList<String> productlist = new ArrayList<String>();
			try {
				String dbURL = "jdbc:sqlserver://DESKTOP-SA6L2QJ\\PRAPHUSAK;DatabaseName=Student";
				String user = "sa";
				String pass = "582115033";
				conn = DriverManager.getConnection(dbURL, user, pass);
				if (conn != null) {
					Statement m_Statement = conn.createStatement();
					String query = "SELECT * FROM Student";
					ResultSet m_ResultSet = m_Statement.executeQuery(query);
					while (m_ResultSet.next()) {
						productlist.add(m_ResultSet.getString(1) + "," + m_ResultSet.getString(2));
					}
				}
			} catch (SQLException ex) {
				ex.printStackTrace();

			} finally {
				try {
					if (conn != null && !conn.isClosed()) {
						conn.close();
					}
				} catch (SQLException ex) {
					ex.printStackTrace();
				}
			}
			return productlist;
		}

		public static void InsertProduct(String id, String Name) {
			Connection conn = null;
			ArrayList<String> productlist = new ArrayList<String>();

			try {
				String dbURL = "jdbc:sqlserver://DESKTOP-SA6L2QJ\\PRAPHUSAK;DatabaseName=Student";
				String user = "sa";
				String pass = "582115033";
				conn = DriverManager.getConnection(dbURL, user, pass);
				if (conn != null) {
					Statement m_Statement = conn.createStatement();
					String query = "Insert into product_tbl (p) values('" + id + "','" + Name + "')";
					m_Statement.execute(query);
				}
			} catch (SQLException ex) {
				ex.printStackTrace();
			} finally {
				try {
					if (conn != null && !conn.isClosed()) {
						conn.close();
					}
				} catch (SQLException ex) {
					ex.printStackTrace();
				}
			}
		}
	}