public static Connection createConnection() {
            String server="DESKTOP-FKIO7OD\\SQLEXPRESS";
            int port=1433;
            String user="sa";
            String password="272627abc";
            String database="Bank" ;
            String jdbcurl;
            Connection con=null;
            try {
                Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

            }catch(ClassNotFoundException e){
                e.printStackTrace();
            }
            jdbcurl = "jdbc:sqlserver://" + server + ":" + port + ";user=" + user
                    + ";password=" + password + ";databasename=" + database + "";
            try {

                con=DriverManager.getConnection( jdbcurl);;
                System.out.println("Worked");
                PreparedStatement P1=con.prepareStatement("insert into CUSTOMER values(?,?,?) ");
                PreparedStatement P=con.prepareStatement("Select * from CUSTOMER");
                ResultSet rs=P.executeQuery();
                P1.setInt(1,3);
                P1.setString(2,"sara");
                P1.setString(3,"saida");
             //   P1.executeUpdate();
                //ResultSet rs1=P1.executeQuery();

                while(rs.next())
                System.out.println("ID: "+rs.getInt("CID")+ "  Name:"+rs.getString("CNAME")+"   CITY:"+rs.getString("CCITY"));

            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        return con;

    }
    public static void main(String[]args){
            createConnection();

    }