FBForm

package Business;

import java.awt.Container;
import java.awt.LayoutManager;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.awt.FlowLayout; 
import java.awt.GridLayout;

import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPasswordField;
import javax.swing.JRadioButton;
import javax.swing.JTextField;

import DBManage.ConnectDB;

import java.awt.CardLayout;


public class FacebookForm extends JFrame {
	JFrame f = new JFrame("The Frame");
	JLabel lbSignUp = new JLabel("Sign Up");
	JTextField tfFirstName = new JTextField(10);
	JPasswordField tfPass = new JPasswordField(10);
	JButton btnSignUp = new JButton("Sign Up");
	JRadioButton rbMale=new JRadioButton("Male");    
	JRadioButton rbFemale=new JRadioButton("Female");
	ButtonGroup br= new ButtonGroup();
	
	PreparedStatement ps;
	Connection conn;
	public FacebookForm() {
		//tao 1 container de add cac component vao
		 // this.getContentPane().;
		f.setLocation(300, 300);
		f.setLayout(new FlowLayout());
		Container cont = f.getContentPane();
		//cont.setLayout(new LayoutManager());
		cont.add(lbSignUp);
		cont.add(tfFirstName);
		cont.add(tfPass);
		br.add(rbMale);
		br.add(rbFemale);
		cont.add(rbMale);
		cont.add(rbFemale);
		//Hobbies : Game Music
		cont.add(btnSignUp);
				
		f.setSize(200,200);
		f.pack();
	    f.setVisible(true);
	}
	
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		//new FacebookForm();
		new FacebookForm();    
	    
	}

}



====db-===
package DBManage;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.Statement;

public class ConnectDB {
	
	Connection conn;
	Statement stmt ;
	PreparedStatement ps;
	
	
	public void connect() {
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").getConstructor().newInstance();
			//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			String connectionUrl = "jdbc:sqlserver://DESKTOP-NU4VCB7\\SQLEXPRESS:1433;databaseName=StudentManage;user=sa;password=123456";
			conn = DriverManager.getConnection(connectionUrl);
			System.out.println("Connected...");
			
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
	}
	public int executeDB(String sql) { //insert, update, delete
		int record=0;
		try {
			connect();
			stmt = conn.createStatement();
			record = stmt.executeUpdate(sql); //so luong hang thay doi sau khi thuc hien 1 trong 3 cau lenh tren
			
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		}
		finally {
			try {
				conn.close();
				stmt.close();
			} catch (Exception e2) {
				// TODO: handle exception
				e2.printStackTrace();
			}
		}
		return record;
	}
	}