Java

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import java.awt.Container;
import javax.swing.JOptionPane;
import java.awt.Frame;
import java.awt.event.*;
import java.io.IOException;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import javax.swing.SpringLayout;

public class SpringSample extends Frame implements ActionListener

{
		 JLabel F_namelbl = new JLabel("Username: ");
	    JLabel L_namelbl = new JLabel("Password: ");
	    JTextField tf_Fname = new JTextField(15);
	    JPasswordField tf_Lname = new JPasswordField(15);
	    JLabel Lbl_HW = new JLabel("< Login Area >");
	    JButton Btn = new JButton("Login");
	    JButton btn_cancel = new JButton("Cancel");
	
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	
	SpringSample()
	{
		
	    
		 JFrame frame = new JFrame("Login Area!");		 
		    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		    Container contentPane = frame.getContentPane();
		    JPanel p = new JPanel(new SpringLayout());
		    SpringLayout layout = (new SpringLayout());
		    contentPane.setLayout(layout);		   
		    JPanel p1=new JPanel();    
		   
		     
		    //--------------------------------------------------------------------------------------------------------------------
		    
		    //---------------------------------------------------------------------------------------------------------------------
		    /*Adding Components to the ContentPane */
		    frame.add(p1);
		    contentPane.add(F_namelbl);
		    contentPane.add(L_namelbl);
		    contentPane.add(tf_Fname);
		    contentPane.add(tf_Lname);
		    contentPane.add(Lbl_HW);
		    contentPane.add(Btn);
		    contentPane.add(btn_cancel);
		    	    
		      //--------------------------------------------------------------------------------------------------------------------
		    /*Lay out Components according to the position and coordinates on the SpringLayout*/
		    
		    layout.putConstraint(SpringLayout.WEST, Lbl_HW, 140, SpringLayout.WEST, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, Lbl_HW, 0, SpringLayout.NORTH, contentPane);    
		    layout.putConstraint(SpringLayout.WEST, Lbl_HW, 140, SpringLayout.WEST, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, Lbl_HW, 0, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.WEST, F_namelbl, 30, SpringLayout.WEST, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, F_namelbl, 25, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.WEST, L_namelbl, 30, SpringLayout.WEST, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, L_namelbl, 50, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, tf_Fname, 25, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.WEST, tf_Fname, 15, SpringLayout.EAST, F_namelbl);
		    layout.putConstraint(SpringLayout.NORTH, tf_Lname, 50, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.WEST, tf_Lname, 15, SpringLayout.EAST, F_namelbl);
		    layout.putConstraint(SpringLayout.NORTH, Btn, 80, SpringLayout.NORTH, contentPane);
		    layout.putConstraint(SpringLayout.WEST, Btn, 110, SpringLayout.WEST, contentPane);
		    layout.putConstraint(SpringLayout.NORTH, btn_cancel, 80, SpringLayout.NORTH, p1);
		    layout.putConstraint(SpringLayout.WEST, btn_cancel, 200, SpringLayout.WEST, p1);	    
		    
		    //---------------------------------------------------------------------------------------------------------------------
		    /*Adding Action Listener/Action*/
		    btn_cancel.addActionListener(this);
		    Btn.addActionListener(this);
		    
		    //------------------------------------------------------------------------------------------------------------------------
		    /*Setting up JFrame*/
		    
		    frame.pack();
		    frame.setSize(350, 200);
		    frame.setLocationRelativeTo(null); //to appear frame in the center of the window screen
		    //setLocation(700,280);
		    frame.setVisible(true);	
	}
  public static void main(String args[]) 
  {	 
	  
    new SpringSample();    
   Connectionstring();  
  
    
    try {						 
		insertRecordIntoDbUserTable();
		selectfromdb();
	} 
	catch (SQLException e)
	{

		System.out.println(e.getMessage());

	}  
	  
  }
  //connection string method
  static Connection Connectionstring()
 	{		
 		Connection con = null;
 		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch (ClassNotFoundException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
 		String conUrl = "jdbc:sqlserver://localhost:1433; databaseName=paytest; user=PC; password=; integratedSecurity=true;";
 		
 		try 
 		{
 				 con = DriverManager.getConnection(conUrl);
 				 JOptionPane.showMessageDialog(null,"Connection is open!","Connection",JOptionPane.WARNING_MESSAGE);
 				 
 				 }
 		catch (SQLException e)
 		{
 			
 			e.printStackTrace();
 		}		
 		return con;
 		
 	}
  
  private static void insertRecordIntoDbUserTable() throws SQLException
	{
		Connection con = null;
		Statement statement = null;
		String insertTableSQL = "INSERT INTO LoginDetails" + "(Username, Password) " + "VALUES" + "('user1','user1')";
		try 
		{
			con = Connectionstring();
			statement = con.createStatement(); 
			System.out.println(insertTableSQL);			
			statement.executeUpdate(insertTableSQL);			
			
			JOptionPane.showMessageDialog(null,"Your Data has been Inserted","Data Inserted",JOptionPane.WARNING_MESSAGE);
		} 
		catch (SQLException e)
		{

			System.out.println(e.getMessage()); 
		} 
		finally 
		{

			if (statement != null)
			{
				statement.close();
				
				JOptionPane.showMessageDialog(null,"Statement is closed","Statement",JOptionPane.WARNING_MESSAGE);
			}

			if (con != null)
			{
				con.close();
				
				JOptionPane.showMessageDialog(null,"Connection is closed!","Connection",JOptionPane.WARNING_MESSAGE);
			}

		}
		
		
	}
 
  private static void selectfromdb() throws SQLException
	{		
	    Statement stmt = Connectionstring().createStatement();
		ResultSet rs = stmt.executeQuery("SELECT Username,Password FROM LoginDetails");
		while (rs.next())
		{
			  String lastName = rs.getString("Username");
			  String Pass = rs.getString("Password");
			  System.out.println(lastName + "" + Pass + "\n");
			 
			}		
	} 

 public void actionPerformed(ActionEvent e) 
{
	 
	if(e.getSource() == btn_cancel)
	{
		JOptionPane.showMessageDialog(null,"You have clicked on Cancel","button cancel",JOptionPane.WARNING_MESSAGE);
	}
	else if(e.getSource() == Btn)
	{
		//SpringSample sp = new SpringSample();
		//DBConnectionstring db = new DBConnectionstring();
		JOptionPane.showMessageDialog(null,"You have clicked login","button login",JOptionPane.WARNING_MESSAGE);		
		
	}
	
	

}
 
 //NEW CONNECTION STRING(CLASS) FOR JDBC CONNECTION I HOPE THIS WORKS
 
 
 
 
 
}

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
public abstract class ConnectionDB 
{	
	
	/**
	 * @param args
	 */
	public static void main(String[] args)
	{	
		SpringSample sp = new SpringSample();
		
		try {						 
			insertRecordIntoDbUserTable();
			selectfromdb();
		} 
		catch (SQLException e)
		{ 
			System.out.println(e.getMessage()); 
		}
}		
	private static void insertRecordIntoDbUserTable() throws SQLException
	{
		Connection con = null;
		Statement statement = null;
		String insertTableSQL = "INSERT INTO LoginDetails" + "(Username, Password) " + "VALUES" + "('null2','tf_Lname')";
		try 
		{
			con = DBConnectionstring();
			statement = con.createStatement(); 
			System.out.println(insertTableSQL);			
			statement.executeUpdate(insertTableSQL);			
			
			JOptionPane.showMessageDialog(null,"Your Data has been Inserted","Data Inserted",JOptionPane.WARNING_MESSAGE);
		} 
		catch (SQLException e)
		{
 
			System.out.println(e.getMessage()); 
		} 
		finally 
		{ 
			if (statement != null)
			{
				statement.close();				
				JOptionPane.showMessageDialog(null,"Statement is closed","Statement",JOptionPane.WARNING_MESSAGE);
			}
 
			if (con != null)
			{
				con.close();				
				JOptionPane.showMessageDialog(null,"Connection is closed!","Connection",JOptionPane.WARNING_MESSAGE);
			} 
		}		
	}	
	private static void selectfromdb() throws SQLException
	{		
	    Statement stmt = DBConnectionstring().createStatement();
		ResultSet rs = stmt.executeQuery("SELECT Username,Password FROM LoginDetails");
		while (rs.next())
		{
			  String lastName = rs.getString("Username");
			  String Pass = rs.getString("Password");
			  System.out.println(lastName + "" + Pass + "\n");			 
			}		
	}	
	 static Connection DBConnectionstring()
	{		
		Connection con = null;
		String conUrl = "jdbc:sqlserver://localhost:1433; databaseName=paytest; user=PC; password=; integratedSecurity=true;";		
		try 
		{
				 con = DriverManager.getConnection(conUrl);				
				 JOptionPane.showMessageDialog(null,"Connection is open!","Connection",JOptionPane.WARNING_MESSAGE);				 
				 }
		catch (SQLException e)
		{			
			e.printStackTrace();
		}		
		return con;		
	}
	 
	 
	 
	 
	}

static Connection Connectionstring()
   {
       Connection con = null;
       try {
           Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
       } catch (ClassNotFoundException e1) {
           // TODO Auto-generated catch block
           e1.printStackTrace();
       }
       String conUrl = "jdbc:sqlserver://localhost;databaseName=paytest;user=PC;password=;integratedSecurity=true";

       try
       {
                con = DriverManager.getConnection(conUrl);
                JOptionPane.showMessageDialog(null,"Connection is open!","Connection",JOptionPane.WARNING_MESSAGE);

                }
       catch (SQLException e)
       {

           e.printStackTrace();
       }
       return con;

   }//connection string method ends

Exception in thread "main" java.lang.NoSuchFieldError: address
	at java.net.InetAddress.init(Native Method)
	at java.net.InetAddress.<clinit>(Unknown Source)
	at java.net.InetSocketAddress.<init>(Unknown Source)
	at com.microsoft.sqlserver.jdbc.SocketFinder.getDefaultSocket(IOBuffer.java:2430)
	at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2094)
	at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at SpringSample.Connectionstring(SpringSample.java:290)
	at SpringSample.main(SpringSample.java:120)