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("582115545", "qwerty", "19"
			+ "19");
			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://LAB324-11\\LAB324;DatabaseName=Lab31116";
				String user = "sa";
				String pass = "582115045";
				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,String Age) {
			Connection conn = null;
			ArrayList<String> productlist = new ArrayList<String>();

			try {
				String dbURL = "jdbc:sqlserver://LAB324-11\\LAB324;DatabaseName=Lab31116";
				String user = "sa";
				String pass = "582115045";
				conn = DriverManager.getConnection(dbURL, user, pass);
				if (conn != null) {
					Statement m_Statement = conn.createStatement();
					String query = "Insert into student (StudentId,StudentName,StudentAge) values('" + id + "','" + Name + "','" + Age + "')";
					m_Statement.execute(query);
				}
			} catch (SQLException ex) {
				ex.printStackTrace();
			} finally {
				try {
					if (conn != null && !conn.isClosed()) {
						conn.close();
					}
				} catch (SQLException ex) {
					ex.printStackTrace();
				}
			}
		}
	}